Top "Pg-dump" questions

pg_dump is a utility for backing up a PostgreSQL database.

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 …

postgresql pg-dump pg-restore
Postgresql: backup all table structures but only a few data table

I have a database with some tables for the application settings, lists like users, departments, cities. I want the structure …

postgresql database-backups pg-dump
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 …

postgresql backup restore pg-dump
pg_dump windows command prompt invalid command

trying to using pg_dump to backup a postgres db i connected through the command prompt and here is my …

postgresql pg-dump
PostgreSQL - dump each table into a different file

I need to extract SQL files from multiple tables of a PostgreSQL database. This is what I've come up with …

sql database postgresql postgresql-9.1 pg-dump
How to run pg_dump/pg_dumpall command on Linux?

Hello everyone i am try to create backup in postgres through dump. when i run the command through command line …

linux postgresql pg-dump pg-dumpall
Problems with $libdir on PostgreSQL

In short, my question is "why doesn't $libdir work on my PSQL installation." CREATE FUNCTION st_box2d_in(cstring) …

postgresql postgis pg-dump
pg_restore with -C option does not create the database

I am using pg_dump and pg_restore for backup and restore of postgres database. Here is some information from …

postgresql pg-dump pg-restore
Restoring the data from pg_dump doesn't overwrite the data but it appends the data to the original database

I am taking the dump of postgres database using "pg_dump database_name > backup.sql". Later on I am …

postgresql backup psql restore pg-dump
Can I install pg_dump without installing postgres on Alpine?

I have tried to install pg_dump as part of installation of postgres-client, however it does not include pg_dump. …

postgresql pg-dump alpine