[ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
online but none had a solution. Can someone help me with this? TIA Thanks, Sairam Krishnamurthy +1 612 859 8161 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
None. The log is empty. Thanks, Sairam Krishnamurthy +1 612 859 8161 On Tue, Feb 15, 2011 at 3:45 PM, Scott Mead wrote: > > On Tue, Feb 15, 2011 at 4:41 PM, Sairam Krishnamurthy > wrote: >> >> All, >> >> I am using Ubuntu 10.04 and Postgres 8.4, I have been

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
Can you explain a bit? I dint get what you mean data area. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 02/15/2011 04:09 PM, Frederiko Costa wrote: I would recommend to create the data area in the destination pgsql server and dump the source database into it, rather than copying the data

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
Scott, I get this error. server starting krishnam@nipa-umh:/media/extension/var/lib$ postgres: invalid argument: "config_file=/etc/postgresql/8.4/main/postgresql.conf" tried with both -o and -c arguments. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 02/15/2011 04:27 PM,

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
Again, pg_ctl: could not open PID file "/media/extension/var/lib/postgresql/8.4/main/postmaster.pid": Permission denied Tried all the different ownership possible. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 02/15/2011 04:37 PM, Scott Mead wrote: On Tue, Feb 15, 2011

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
Scott, I have 755 permission until "/media/extension/var/lib" and postgres owns the folder from postgresql. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 02/15/2011 04:48 PM, Scott Mead wrote: On Feb 15, 2011 5:44 PM, "Sairam Krishnamurthy" <mailto:kmsr

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
Frederiko, I will try that. I was hoping to have a better solution than to reinstall postgres. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 02/15/2011 04:56 PM, Frederiko Costa wrote: What I meant was that when you install postgresql, you initialize the area where your data directory

Re: [ADMIN] Moving the data directory

2011-02-15 Thread Sairam Krishnamurthy
I followed the preferred way to migrate the data and ran into this problem. So i guess I am stuck here and cant get any help from the docs. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 02/15/2011 04:59 PM, Frederiko Costa wrote: You might find something in the documentation about