Mon Aug 25 23:39:16 PDT 2008
- Previous message: [Slony1-general] Building against multiple Postgres versions [SOLVED WONTFIX]
- Next message: [Slony1-general] Simple, step by step instructions to upgrade PG
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
HI On the PG-General list, I was recommended to look at Slony as I wish to upgrade from PG 8.2.3 to the latest 8.3.3 without significant downtime. I have a very typical CentOS 4.4 Linux server with Cpanel/WHM. Postgresql is used to work with Apache and PHP n a very busy site. I am looking for simple instructions to 1. Install Slony 2. Install PG 8.3.3, and make sure it is working with same settings in "pg_hba.conf" and "postgresql.conf" as my current working db 3. Replicate my current working db of PG 8.2.3 to this new installed 8.3.3 using Slony? (I am not familiar with master and slave stuff, so simple instructions would be nice) 4. When all data is replicated and working, just switch the master and slave, so that the new 8.3.3 becomes the main database Are there any simple straightforward instructions for this that don't assume that I'm a super techsavvy DBA with 300 years of experience? Thanks! for any advice or pointers.
- Previous message: [Slony1-general] Building against multiple Postgres versions [SOLVED WONTFIX]
- Next message: [Slony1-general] Simple, step by step instructions to upgrade PG
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list