Skip site navigation (1) Skip section navigation (2)

Re: Moving the data directory

From: Sairam Krishnamurthy <kmsram420(at)gmail(dot)com>
To: Scott Mead <scottm(at)openscg(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Moving the data directory
Date: 2011-02-15 22:54:10
Message-ID: 4D5B0412.7050309@gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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" <kmsram420(at)gmail(dot)com 
> <mailto:kmsram420(at)gmail(dot)com>> wrote:
> >
> > 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.
>
> What about the permissions on your mountpoint?  Are they too 
> restrictive for the postgres user?  ( or any of the higher level dirs)
> >
> > Thanks,
> > Sairam Krishnamurthy
> > +1 612 859 8161
> >
> >
> > On 02/15/2011 04:37 PM, Scott Mead wrote:
> >>
> >>
> >>
> >> On Tue, Feb 15, 2011 at 5:32 PM, Sairam Krishnamurthy 
> <kmsram420(at)gmail(dot)com <mailto:kmsram420(at)gmail(dot)com>> wrote:
> >>>
> >>> Scott,
> >>>
> >>> I get this error.
> >>>
> >>> server starting
> >>> krishnam(at)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.
> >>
> >>
> >> My mistake, I screwed up!
> >>
> >> /usr/lib/postgresql/8.4/bin/pg_ctl start -D 
> /media/extension/var/lib/postgresql/8.4/main/ -o "-c 
> config_file="/etc/postgresql/8.4/main/postgresql.conf"
> >>
> >>  (-c inside the quotes)
> >>
> >> --Scott
> >>
> >>> Thanks,
> >>> Sairam Krishnamurthy
> >>> +1 612 859 8161
> >>>
> >>>
> >>> On 02/15/2011 04:27 PM, Scott Mead wrote:
> >>>>
> >>>> /usr/lib/postgresql/8.4/bin/pg_ctl start -D 
> /media/extension/var/lib/postgresql/8.4/main/ -o 
> config_file="/etc/postgresql/8.4/main/postgresql.conf
> >>
> >>
>

In response to

pgsql-admin by date

Next:From: Frederiko CostaDate: 2011-02-15 22:56:24
Subject: Re: Moving the data directory
Previous:From: Scott MeadDate: 2011-02-15 22:48:46
Subject: Re: Moving the data directory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group