– “FATAL: ERROR: could not extend file "base/24834/32917": No space left on device

IQBAL, MOHAMMAD 5 Reputation points
2024-04-10T01:17:54.12+00:00

while copying data via ora2pg getting below error message. Please suggest where space need to be added.

– “FATAL: ERROR:  could not extend file "base/24834/32917": No space left on device

Azure Database for PostgreSQL

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
    2024-04-10T04:27:34.31+00:00

    Hi IQBAL, MOHAMMAD •,

    Welcome to Microsoft Q&A forum.

    As I understand, you are getting Fatal Error in Azure Database for PostgreSQL with "No Space Left on Device" message.

    Could you please refer to the solutions provided at the below posts and see if that helps:

    https://serverfault.com/questions/933401/postgresql-could-not-extend-file-no-space-left-on-device-hint-check-free-dis

    https://dba.stackexchange.com/questions/329204/msg-cannot-execute-sql-copy-my-table-from-path-big-file-csv-error-could/329205#329205

    https://stackoverflow.com/questions/64753593/postgresql-error-could-not-extend-file-no-space-left-on-device

    Awaiting your reply.

    Thanks

    0 comments