You might find something in the documentation about migrating the data directory to another server. ~Fred Linkedin profile: http://www.linkedin.com/in/frederikocosta On Tue, Feb 15, 2011 at 2:58 PM, Sairam Krishnamurthy <kmsram420@xxxxxxxxx> wrote: > Frederiko, > > I will try that. I was hoping to have a better solution than to reinstall > postgres. > > Thanks, > Sairam Krishnamurthy > +1 612 859 8161 > > On 02/15/2011 04:56 PM, Frederiko Costa wrote: > > What I meant was that when you install postgresql, you initialize the > area where your data directory will be. There you have the database, > config files, logs, etc. Before you restore the DB into the new pgsql, > as far as I'm aware, you have to create/init this area. > > On Tue, Feb 15, 2011 at 2:27 PM, Sairam Krishnamurthy > <kmsram420@xxxxxxxxx> wrote: > > Can you explain a bit? I dint get what you mean data area. > > Thanks, > Sairam Krishnamurthy > +1 612 859 8161 > > On 02/15/2011 04:09 PM, Frederiko Costa wrote: > > I would recommend to create the data area in the destination pgsql > server and dump the source database into it, rather than copying the > data directory. > > On Tue, Feb 15, 2011 at 1:41 PM, Sairam Krishnamurthy > <kmsram420@xxxxxxxxx> 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? > > TIA > > Thanks, > Sairam Krishnamurthy > +1 612 859 8161 > > -- > Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > > > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
