Message-ID: <64c2847d5a84cecc9a37286f3f2920dc.squirrel@127.0.0.1>
In-Reply-To: <14fa203f89daa60be46db181e2f456a7.squirrel@127.0.0.1>
References: <14fa203f89daa60be46db181e2f456a7.squirrel@127.0.0.1>
Date: Mon, 29 Aug 2016 11:46:18 +0300
Subject: Re: run copy of database on another (backup) server
From: "Marchello Lippi" <postgresql.org@marchello.tk>
To: pgsql-admin@postgresql.org
User-Agent: SquirrelMail/1.4.23 [SVN]
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit
Importance: Normal
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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