Обсуждение: Backup complete
Dear all, I take backup of postgres databases with pg_dump command. But it didn't take backup of all sequences,views & functions in different databases. I want to know how we can complete backup so we can get complete data after restoring from a single file. I faced errors when dumping data from one system to another , if the same sequence doesn't exist in the other system. Thanks
On 27/07/2011 10:51, Adarsh Sharma wrote: > Dear all, > > I take backup of postgres databases with pg_dump command. > But it didn't take backup of all sequences,views & functions in > different databases. That's because you told it to backup only the postgres database. pg_dump only dumps a single database. If you want to backup all databases in the cluster, use pg_dumpall. You should read up on the two commands in the documentation: http://www.postgresql.org/docs/9.0/static/reference-client.html Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
Raymond O'Donnell wrote:
Adarsh
Thanks Raymond, I know that but did it take the backups of procedures & views too.On 27/07/2011 10:51, Adarsh Sharma wrote:Dear all, I take backup of postgres databases with pg_dump command. But it didn't take backup of all sequences,views & functions in different databases.That's because you told it to backup only the postgres database. pg_dump only dumps a single database. If you want to backup all databases in the cluster, use pg_dumpall. You should read up on the two commands in the documentation: http://www.postgresql.org/docs/9.0/static/reference-client.html Ray.
Adarsh
> I take backup of postgres databases with pg_dump command. > But it didn't take backup of all sequences,views & functions in > different databases. > > I want to know how we can complete backup so we can get complete data > after restoring from a single file. > > I faced errors when dumping data from one system to another , if the > same sequence doesn't exist in the other system. Check out pg_dumpall: http://www.postgresql.org/docs/current/interactive/app-pg-dumpall.html Benny -- "Open your door, or I open your wall." -- Seen on an image on fukung.net
On 27/07/2011 11:31, Adarsh Sharma wrote: > Raymond O'Donnell wrote: >> On 27/07/2011 10:51, Adarsh Sharma wrote: >> >>> Dear all, >>> >>> I take backup of postgres databases with pg_dump command. >>> But it didn't take backup of all sequences,views & functions in >>> different databases. >>> >> >> That's because you told it to backup only the postgres database. pg_dump >> only dumps a single database. If you want to backup all databases in the >> cluster, use pg_dumpall. >> >> You should read up on the two commands in the documentation: >> >> http://www.postgresql.org/docs/9.0/static/reference-client.html >> >> Ray. >> >> > Thanks Raymond, I know that but did it take the backups of procedures & > views too. > > > Adarsh Hi Adarsh, Yes, pg_dump backs up everything - schema and data. If you need to convince yourself, use the -s option to dump just the schema and examine the output. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie