Hi PGSQL Team,
While taking backup of PostgreSQL DB, observed hang in pg_dump.
The PostgreSQL version is 14.6
Need help understand if this is a known issue. If not, need help in resolving the hang seen.
The command that has hung is as follows
pg_dump --host=DBSERVER.postgres.database.azure.com -p 5432 --username=USER1 -w -F c --dbname=DB1 -v -f PATH/DBNAME/DB1.dump
Details of hang are as follows
I]. DB1 - Table count: 667, size around 30 GB
STACK1
————
(gdb) bt
#0 0x00007f6ab8ea6bc8 in write () from /lib64/libc.so.6
#1 0x00007f6ab8e18dad in _IO_file_write@@GLIBC_2.2.5 () from /lib64/libc.so.6
#2 0x00007f6ab8e1811f in new_do_write () from /lib64/libc.so.6
#3 0x00007f6ab8e194de in __GI__IO_file_xsputn () from /lib64/libc.so.6
#4 0x00007f6ab8e0e56c in fwrite () from /lib64/libc.so.6
#5 0x000000000043d861 in flushbuffer ()
#6 0x000000000043f064 in pg_vfprintf ()
#7 0x000000000043f148 in pg_fprintf ()
#8 0x000000000043bf4a in pg_log_generic_v ()
#9 0x000000000043c1d8 in pg_log_generic ()
#10 0x00000000004090d9 in dumpTableData_copy ()
#11 0x000000000043195b in WriteDataChunksForTocEntry ()
#12 0x00000000004319e6 in WriteDataChunks ()
#13 0x0000000000433199 in _CloseArchive ()
#14 0x000000000042c92e in CloseArchive ()
#15 0x0000000000406536 in main ()
II] DB2 - table count : 5193, size around 60 MB
Command fired: pg_dump --host=DBSERVER.postgres.database.azure.com -p 5432 --username=USER1 -w -F c --dbname=DB2 -v -f PATH/DBNAME/DB2.dump
STACK2
————
(gdb) bt
#0 0x00007fe6a9920bc8 in write () from /lib64/libc.so.6
#1 0x00007fe6a9892dad in _IO_file_write@@GLIBC_2.2.5 () from /lib64/libc.so.6
#2 0x00007fe6a989211f in new_do_write () from /lib64/libc.so.6
#3 0x00007fe6a98934de in __GI__IO_file_xsputn () from /lib64/libc.so.6
#4 0x00007fe6a988856c in fwrite () from /lib64/libc.so.6
#5 0x000000000043d861 in flushbuffer ()
#6 0x000000000043f064 in pg_vfprintf ()
#7 0x000000000043f148 in pg_fprintf ()
#8 0x000000000043bf4a in pg_log_generic_v ()
#9 0x000000000043c1d8 in pg_log_generic ()
#10 0x0000000000421db1 in getTableAttrs ()
#11 0x0000000000425431 in getSchemaData ()
#12 0x00000000004059a1 in main ()
Regards,
Atul D.