0
votes
0answers
15 views

difference between pg_dump command's --column-insert and --attribute-insert

Background: I'm trying to create a dump file that only contains the data in my database. I would like it to create the data with the INSERT command. In reading the manual, ...
0
votes
0answers
42 views

Error while taking backup in Postgresql

While taking a backup from my PostgrSQL database, it is showing this: pg_dump: Dumping the contents of table "gtab17" failed: PQgetResult() failed. pg_dump: Error message from server: ERROR: invalid ...
3
votes
1answer
320 views

How to take pg_dump of a very large postgres database?

I have a production database server running Postgres 8.4 on Cent OS 6.5.The volume of data has increased recently and within few one month database now has 18500 tables amounting to approx 350GB ...
2
votes
1answer
480 views

I need help understanding Postgres's archive cleanup functionality

I'm reading http://www.postgresql.org/docs/9.2/static/pgarchivecleanup.html and to me it seems like it will remove any and all WAL segments from my slave server that aren't required to perform ...