run copy of database on another (backup) server

From: "Marchello Lippi" <postgresql(dot)org(at)marchello(dot)tk>
To: pgsql-admin(at)postgresql(dot)org
Subject: run copy of database on another (backup) server
Date: 2016-08-29 07:13:25
Message-ID: 14fa203f89daa60be46db181e2f456a7.squirrel@127.0.0.1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

I tried to run copy of my database on another server.

Found its path using
Code:

SHOW data_directory

it is /var/lib/postgresql/9.3/main

Put it into tar.gz archive using sudo on main server, copied archive into
backup server, stopped postgresql on backup server, extracted archive into
/var/lib/postgresql/9.3/main2 directory, changed data_directory path in
/etc/postgresql/9.3/main/postgresql.conf, tried to start postgresql on
backup server, but got error:

$ sudo service postgresql start
* Starting PostgreSQL 9.3 database server
* Error: could not exec /usr/lib/postgresql/9.3/bin/pg_ctl
/usr/lib/postgresql/9.3/bin/pg_ctl start -D /var/lib/postgresql/9.3/main2
-l /var/log/postgresql/postgresql-9.3-main.log -s -o -c
config_file="/etc/postgresql/9.3/main/postgresql.conf" :
[fail]

Tried to put files into default directory and changed back path in conf
file, then tried to start postgresql on backup server, got error again:

$ sudo service postgresql start
* Starting PostgreSQL 9.3 database server
* Error: could not exec /usr/lib/postgresql/9.3/bin/pg_ctl
/usr/lib/postgresql/9.3/bin/pg_ctl start -D /var/lib/postgresql/9.3/main
-l /var/log/postgresql/postgresql-9.3-main.log -s -o -c
config_file="/etc/postgresql/9.3/main/postgresql.conf" :
[fail]

How do I solve it?
I suppose, I should change rights after extracting files from archive
under sudo, but don't know what exactly to change.

versions (on both main and backup servers)
Ubuntu 14.04.5 LTS
Postgresql 9.3

Please advise.
Thanks ahead.

Regards,

--
Marchello Lippi

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marchello Lippi 2016-08-29 08:46:18 Re: run copy of database on another (backup) server
Previous Message leo 2016-08-29 03:35:21 how to find correct command parameter of pg_resetxlog (9.4.5)