Re: Moving the data directory

On Tue, Feb 15, 2011 at 4:58 PM, Sairam Krishnamurthy
<kmsram420(at)gmail(dot)com>wrote:

> None. The log is empty.
>

Can you manually start the database as the postgres user:

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

--Scott

>
> Thanks,
> Sairam Krishnamurthy
> +1 612 859 8161
>
>
>
> On Tue, Feb 15, 2011 at 3:45 PM, Scott Mead <scottm(at)openscg(dot)com> wrote:
> >
> > On Tue, Feb 15, 2011 at 4:41 PM, Sairam Krishnamurthy <
> kmsram420(at)gmail(dot)com>
> > wrote:
> >>
> >> All,
> >>
> >> I am using Ubuntu 10.04 and Postgres 8.4, I have been trying to move
> >> my data dir to another device for the past couple of days but ran into
> >> a lot of problems.
> >>
> >> I did the following:
> >>
> >> 1. Copy the contents of /var/lib/postgresql/8.4/main to my folder.
> >> 2. Changed the data_directory in postgresql.conf.
> >>
> >> When I start postgres using /etc/init.d script I get the following
> error,
> >>
> >> * Starting PostgreSQL 8.4 database server
> >> * Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl
> >> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
> >> /media/extension/var/lib/postgresql/8.4/main/ -l
> >> /var/log/postgresql/postgresql-8.4-main.log -s -o -c
> >> config_file="/etc/postgresql/8.4/main/postgresql.conf" :
> >>
> >>
> >> I tried changing the ownership of the
> >> /media/extension/var/lib/postgresql dir to <myusername>, postgres and
> >> root. Now of them worked and I keep getting the same error message.
> >>
> >> I found a lot of similar problems online but none had a solution.
> >>
> >> Can someone help me with this?
> >
> > Do you have any useful information in the logs?
> >
> > /var/log/postgresql/postgresql-8.4-main.log
> >
> > --Scott
> >
> >
> >
> >>
> >> TIA
> >>
> >> Thanks,
> >> Sairam Krishnamurthy
> >> +1 612 859 8161
> >>
> >> --
> >> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> >> To make changes to your subscription:
> >> http://www.postgresql.org/mailpref/pgsql-admin
> >
> >
>