[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 -- Ulas Albayrak

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

2010-06-15 Thread Ulas Albayrak
: On Mon, Jun 14, 2010 at 7:09 AM, Ulas Albayrak ulas.albay...@gmail.com 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, totaling

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

2010-06-14 Thread Ulas Albayrak
://www.endpoint.com/ PGP Key: 0x14964AC8 201006110927 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -- Ulas Albayrak ulas.albay...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

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

2010-06-14 Thread Ulas Albayrak
of Slony-I would spare me some future work. /Regards On Mon, Jun 14, 2010 at 3:15 PM, Raymond O'Donnell r...@iol.ie 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, so I guess that won't

[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] 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