Re: Moving the data directory

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