Re: Moving the data directory

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(at)gmail(dot)com> 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(at)gmail(dot)com> 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(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?
>
> 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
>
>
>