Re: [GENERAL] Backup complete

2011-07-27 Thread Raymond O'Donnell
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. >>>

Re: [GENERAL] Backup complete

2011-07-27 Thread C. Bensend
> 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

Re: [GENERAL] Backup complete

2011-07-27 Thread Adarsh Sharma
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.

Re: [GENERAL] Backup complete

2011-07-27 Thread Raymond O'Donnell
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

[GENERAL] Backup complete

2011-07-27 Thread Adarsh Sharma
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