[GENERAL] problem with pg_restore

I am working with postgres 8.0.3 on suse linux 9.3.I want to restore data from pg_dump backup.Previously it was working fine with the same dump. But now it is giving the following error... pg_restore: [archiver (db)] could not execute query: ERROR: relation "sw_4904.operatorjob" does not exist

[GENERAL] recovery problem

pg_xlog directory. Please help me,in this stage. Thanking you Jayati Biswas ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

[GENERAL] recovery problem

hello, I am trying to setup a "hot standby" on a second machine. I have created a "recovery.conf" file and started a restore with logs from the primary machine. everything was OK. now a have new transaction logs generated by the primary machine and I want to "play" them on the secondary one. I

[GENERAL] recovery with pg_xlog

possible,to doing such a procedure,if yes,then please tell me the steps. thanking you jayati biswas ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Recovery with pg_xlog

I have two questions: 1. In Postgresql, what is the name of the exact DATAFILE under the DATA DIRECTORY ? 2. We want to prepare a backup machine (for disaster management)by passing the pg_xlog diectory.First time we have made a base backup & restore the backup server by this backup.