[GENERAL] What is better method to backup postgresql DB.

new to postgresl. need to backup postgresql DB, which way is better to backup DB. from training, I learned that we can backup the whole PGdata and other direcotries to acheive backup goal, originally I was plainned to schedule jobs to use pgdump to backup all DBs. so which way is better for backu

Re: [GENERAL] Need help on WAL shipping

Yes, that's me and it is for windows. I enabled archive and copy WAL file, created base backup. Restored base backup to target, removed files under pg-xlog, copy over archived WAL files, for some reason recovery always look for WAL files from base restore, not those archived WAL files. --Or

[GENERAL] Need help on WAL shipping

Hi, I posted twice and didn't get any response, wonder my post didn't get populated properly. Again, followed the document on WAL shipping, and couldn't get target to recognize the archive WAL files. It looks for different WAL files. Did I miss any steps? Thx Sent from my BlackBerry device on

[GENERAL] Need help on WAL configure

Need some help to configure the WAl files shipping and restore it to the target server.here is what I configured in the source server. (both windows)In postgresql.conf, I enabled the following option.# WRITE AHEAD LOGfsync = on                synchronous_commit = on      wal_sync_method = fsync  

Re: [GENERAL] Can WAL files be shipped to multiple servers?

, 2010 at 12:31 PM, Magnus Hagander wrote: > On Fri, Jul 23, 2010 at 18:29, Steeles wrote: > > I am working on shipping WAL files, can WAL files do one-to-many > shipping? > > The target PG instances are running in the recovery mode waiting for the > WAL > > files. >

[GENERAL] Can WAL files be shipped to multiple servers?

I am working on shipping WAL files, can WAL files do one-to-many shipping? The target PG instances are running in the recovery mode waiting for the WAL files. also, once the target PG database receives WAL files and update its own database, can I run pg_dump to dump all the data when it is in reco

[GENERAL] Need some help on PG database transfer

Hi all, I am doing some tests on the file level copying for one of database in windows platform. Here is what I want to achieve. copy files within PG tablespace folder where PG database resides to target machine. I want to attache the copied data to target PG database. What I have done is 1. D

Re: [GENERAL] pg dump.. issue with when using crontab

I am new to posgres. By running Pg-dump like this, do we need to type in pwd for login manually? Thanks Sent from my BlackBerry device on the Rogers Wireless Network -Original Message- From: Moe Date: Tue, 26 Jan 2010 19:25:50 To: Subject: Re: [GENERAL] pg dump.. issue with when using

[GENERAL] Help: Postgresql on Microsoft cluster (MSCS)

As title, please help. I want to setup Postgresql HA by MSCS in VMWARE platform. (win server 2003, PG 8.3 on 32 bit) MSCS has been setup, the problem can't start postgresql service. PGDATA is on the shared disk. I tried generic service, and application, either one won't bring up postgresql data

[GENERAL] Postgresql HA on MSCS over VMWARE

As title, please help. I want to setup Postgresql HA by MSCS in VMWARE platform. (win server 2003, PG 8.3 on 32 bit) MSCS has been setup, the problem can't start postgresql service. PGDATA is on the shared disk. I tried generic service, and application, either one won't bring up postgresql data