On Tue, Feb 15, 2011 at 4:58 PM, Sairam Krishnamurthy <kmsram...@gmail.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 <sco...@openscg.com> wrote: > > > > On Tue, Feb 15, 2011 at 4:41 PM, Sairam Krishnamurthy < > kmsram...@gmail.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@postgresql.org) > >> To make changes to your subscription: > >> http://www.postgresql.org/mailpref/pgsql-admin > > > > >
