Re: [ADMIN] rename a cluster

2007-02-16 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Peter Eisentraut wrote: >> Renaming the directory is OK. Just make sure your init script or >> whatever finds it. > Oh, and make sure the postmaster isn't running when you do the rename. While that's surely good practice, I don't think it's actually c

Re: [ADMIN] rename a cluster

2007-02-16 Thread Ray Stell
On Fri, Feb 16, 2007 at 04:35:40PM -0500, Bruce Momjian wrote: > Peter Eisentraut wrote: > > Renaming the directory is OK. Just make sure your init script or > > whatever finds it. > > Oh, and make sure the postmaster isn't running when you do the rename. Right, there are a few operational con

Re: [ADMIN] rename a cluster

2007-02-16 Thread Bruce Momjian
Peter Eisentraut wrote: > Ray Stell wrote: > > What I was trying to get at is, is mv of the dir ok or > > is there something else that needs to be considered? Thx. > > Renaming the directory is OK. Just make sure your init script or > whatever finds it. Oh, and make sure the postmaster isn't r

Re: [ADMIN] rename a cluster

2007-02-15 Thread Andy Shellam (Mailing Lists)
It comes under Server Startup: http://www.postgresql.org/docs/8.2/static/server-start.html Ray Stell wrote: Many thx. It that in the doc? On Thu, Feb 15, 2007 at 06:21:05PM +, Andy Shellam (Mailing Lists) wrote: The cluster's "name" is only the file-system's directory path. You

Re: [ADMIN] rename a cluster

2007-02-15 Thread Ray Stell
Many thx. It that in the doc? On Thu, Feb 15, 2007 at 06:21:05PM +, Andy Shellam (Mailing Lists) wrote: > The cluster's "name" is only the file-system's directory path. > > You can easily rename this directory, as long as you pass the relevant > directory name to pg_ctl's -D parameter (

Re: [ADMIN] rename a cluster

2007-02-15 Thread Peter Eisentraut
Ray Stell wrote: > What I was trying to get at is, is mv of the dir ok or > is there something else that needs to be considered? Thx. Renaming the directory is OK. Just make sure your init script or whatever finds it. -- Peter Eisentraut http://developer.postgresql.org/~petere/ -

Re: [ADMIN] rename a cluster

2007-02-15 Thread Andy Shellam (Mailing Lists)
The cluster's "name" is only the file-system's directory path. You can easily rename this directory, as long as you pass the relevant directory name to pg_ctl's -D parameter (which tells PostgreSQL which database "cluster" to use.) It goes without saying, don't move the directory while Postgr

Re: [ADMIN] rename a cluster

2007-02-15 Thread Ray Stell
On Thu, Feb 15, 2007 at 06:36:23PM +0100, Peter Eisentraut wrote: > Ray Stell wrote: > > Is there a method to rename a cluster? > > Clusters don't have names in the first place. So, from 16.2 "Creating a Database Cluster" "...you must initialize a database storage area on disk. We call this a da

Re: [ADMIN] rename a cluster

2007-02-15 Thread Peter Eisentraut
Ray Stell wrote: > Is there a method to rename a cluster? Clusters don't have names in the first place. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map setti

[ADMIN] rename a cluster

2007-02-15 Thread Ray Stell
Is there a method to rename a cluster? ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate