pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Sairam Krishnamurthy <kmsram420@gmail.com>
To: Scott Mead <scottm@openscg.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Moving the data directory
Date: Tue, 15 Feb 2011 16:54:10 -0600
Message-ID: <4D5B0412.7050309@gmail.com> (raw)
In-Reply-To: <AANLkTik1_0+dyrUhHq76i_Xm1TX5snNrT4W22cgStA+h@mail.gmail.com>
References: <AANLkTik0FbNw2RC=3dMMGruB+UsJrXkpDGhAynAYp6TL@mail.gmail.com>
	<AANLkTikP6CNconEYKpyc5hyRLs4FoD_Q=vseqiZ0a3D7@mail.gmail.com>
	<AANLkTikD-KGTmx45vxK+uaPgAXyJkUY+jspdgcR-dNgN@mail.gmail.com>
	<AANLkTine4wsmdxr5spt_xx92TBX4ey33cM1uB9fThQ2s@mail.gmail.com>
	<4D5AFF19.8030905@gmail.com>
	<AANLkTinrVBd0e6f6Q4HFg2BH5WjsHoB4YB1LjW2Rbfke@mail.gmail.com>
	<4D5B01AC.4040101@gmail.com>
	<AANLkTik1_0+dyrUhHq76i_Xm1TX5snNrT4W22cgStA+h@mail.gmail.com>

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@gmail.com 
> <mailto:kmsram420@gmail.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@gmail.com <mailto:kmsram420@gmail.com>> wrote:
> >>>
> >>> 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.
> >>
> >>
> >> 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
> >>
> >>
>

view thread (18+ messages)  latest in thread

Message-ID: <4D5B0412.7050309@gmail.com>
Permalink:  ../4D5B0412.7050309@gmail.com/
Also on:    postgresql.org/message-id/4D5B0412.7050309@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: kmsram420@gmail.com, scottm@openscg.com
  Subject: Re: Moving the data directory
  In-Reply-To: <4D5B0412.7050309@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox