[GENERAL] Moving a live production database to different server and postgres release

2010-06-11 Thread Ulas Albayrak
Hi, I’m in the process of moving our production database to a different physical server, running a different OS and a newer release of postgreSQL. My problem is that I’m not really sure how to go about it. My initial idea was to use WAL archiving to reproduce the db on the new server and then get

[GENERAL] Moving a live production database to different server and postgres release

2010-06-11 Thread Ulas Albayrak
Hi, I'm in the process of moving our production database to a different physical server, running a different OS and a newer release of postgreSQL. My problem is that I'm not really sure how to go about it. My initial idea was to use WAL archiving to reproduce the db on the new server and then

[GENERAL] Re: Moving a live production database to different server and postgres release

2010-06-14 Thread Ulas Albayrak
supports a limited number of versions at the moment. > > - -- > Greg Sabino Mullane g...@turnstep.com > End Point Corporation http://www.endpoint.com/ > PGP Key: 0x14964AC8 201006110927 > http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -- Ulas Alb

Re: [GENERAL] Re: Moving a live production database to different server and postgres release

2010-06-14 Thread Ulas Albayrak
on of Slony-I would spare me some future work. /Regards On Mon, Jun 14, 2010 at 3:15 PM, Raymond O'Donnell wrote: > On 14/06/2010 14:09, Ulas Albayrak wrote: > >> After your post I had a look at Slony-I, which, according to it web >> page, requires postgres 8.3 or later

Re: [GENERAL] Re: Moving a live production database to different server and postgres release

2010-06-15 Thread Ulas Albayrak
te: > On Mon, Jun 14, 2010 at 7:09 AM, Ulas Albayrak > wrote: >> The database is < 10GB and currently on a postgres version 8.2.15 on a >> BSD system and moving to postgres version 8.4.4 on a windows 2008 >> server. The adding of data is continuous but in small quantities

[GENERAL] deleting db cluster

2010-08-03 Thread Ulas Albayrak
Hi, I have a Linux/Debian machine running postgres 8.3 and I need to remove a database cluster that I created with the "initdb" command. Is it enough to just delete the folder in which the cluster resides on the filesystem, or does it require some additional actions? Regards -- Ula