pg-dump_开发者

Taking dump of the database without getting specific table records :Postgres

Can any one tell 开发者_JS百科me , How can i take database dump using pg_dump without getting specific table records.If you want a table-wide filter, you can use either --exclude-table=table or --tabl[详细]

2023-04-08 10:36 分类：问答

How to find the PostgreSQL installation folder via Java without user interaction?

In my Java application I want to implement the option to dump/restore a PostgreSQL database. Some google research showed me that calling pg_dump/pg_restore via Java\'s ProcessBuilder is probably the b[详细]

2023-03-22 21:29 分类：问答

Is a pg_dump DB dump 'at-that-time' dump?

I know PostgresQL pg_dump guarantees consistency even if DB is modified while dump is going on, but I want 开发者_如何学运维to know if the final dump contains any data modified/inserted after the dump[详细]

2023-03-18 10:18 分类：问答

How to check if postgresql backup was successful?

We have a postgresql database that is backed up nightly from a cron job with a following command: su postgres -c \"pg_dump our_database | gzip > /home/smb/shared/database_backup.bak.gz\"[详细]

2023-03-13 07:05 分类：问答

Postgres : pg_restore/pg_dump everything EXCEPT the table id's for a table

Currently I\'m doing something like: pg_dump -a -O -t my_table my_db > my_data_to_import.sql What I really want is to be 开发者_C百科able to import/export just the data without causing conflicts[详细]

2023-03-10 10:10 分类：问答

empty output when calling pg_dump under php code

I need to make a dump via pg_dump in php so i\'ve got a function like this: function fnDump() { exec(\"/usr/local/bin/sudo -u pg_user /usr/local/bin/pg_dump mon_al开发者_如何学JAVAarm > /usr/home/[详细]

2023-03-09 00:47 分类：问答

pg_dump ignoring table sequence?

I have been playing around with PostgreSQL lately, and am having trouble understanding how to backup and restore a single table.[详细]

2023-02-02 11:30 分类：问答

Use pg_restore to restore from a newer version of PostgreSQL

I have a (production) DB server running PostgreSQL v9.0 and a development machine running PostgreSQL v8.4. I would like to take a dump of the production DB and use it开发者_如何学Go on the development[详细]

2023-02-02 05:29 分类：问答

How to create a backup of a single table in a postgres database?

Is there a way to create a backup of a single table within a d开发者_运维百科atabase using postgres? And how? Does this also work with the pg_dump command?Use --table to tell pg_dump what table it has[详细]

2023-01-16 03:08 分类：问答