From: Marchello Lippi <postgresql.org@marchello.tk>
To: pgsql-admin@postgresql.org
Subject: Re: run copy of database on another (backup) server
Date: Mon, 29 Aug 2016 11:46:18 +0300
Message-ID: <64c2847d5a84cecc9a37286f3f2920dc.squirrel@127.0.0.1> (raw)
In-Reply-To: <14fa203f89daa60be46db181e2f456a7.squirrel@127.0.0.1>
References: <14fa203f89daa60be46db181e2f456a7.squirrel@127.0.0.1>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Fixed using
stopped postgres
chown postgres:postgres /var/lib/postgresql/9.3/main -R
chmod 0700 /var/lib/postgresql/9.3/main -R
started postgres
Regards,
--
Marchello Lippi
Marchello Lippi wrote:
> 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: postgresql.org@marchello.tk
Subject: Re: run copy of database on another (backup) server
In-Reply-To: <64c2847d5a84cecc9a37286f3f2920dc.squirrel@127.0.0.1>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox