Re: [pgadmin-support] Restore Database

2015-01-21 Thread Raymond O'Donnell
On 20/01/2015 18:37, Parth Desai wrote: > Hello, > > I have my postgres SQL database on my server PC and i want to restore > the database backup from my server PC to Client PC using Batch > file.Please help me how can i create batch file in order to restore my > postgres databse. > If possible ple

[pgadmin-support] Restore Database

2015-01-20 Thread Parth Desai
Hello, I have my postgres SQL database on my server PC and i want to restore the database backup from my server PC to Client PC using Batch file.Please help me how can i create batch file in order to restore my postgres databse. If possible please send me the example batch file to retore the datab

[pgadmin-support] Restore database from files (not dump files)?

2006-12-04 Thread wheel
Can a pgsql 8.1 database be restored from the raw file? For one database I have only the files found in the base folder, example C:\PostgreSQL \data\base\16404, under that there are many files called 1247, 1248, etc (no extension). I think these are the files that make up the database? For this

[pgadmin-support] Restore Database

2006-07-11 Thread Burbello
I need to test and create a procedure to restore databases. I followed the steps based on the site, but I couldn't finish succesfully. I did: 1. Put the database on Backup Mode and copy datafiles. /pg/bin/psql cresoldev -c "SELECT pg_start_backup('/pg/backup/');" tar -cvf /pg/backup/bk_b