Re: run copy of database on another (backup) server

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.