From: | "Marchello Lippi" <postgresql(dot)org(at)marchello(dot)tk> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: run copy of database on another (backup) server |
Date: | 2016-08-29 08:46:18 |
Message-ID: | 64c2847d5a84cecc9a37286f3f2920dc.squirrel@127.0.0.1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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.
From | Date | Subject | |
---|---|---|---|
Next Message | Wouter Verhelst | 2016-08-29 12:02:14 | Initiating log shipping backups when the initial filesystem-level backup went out of sync |
Previous Message | Marchello Lippi | 2016-08-29 07:13:25 | run copy of database on another (backup) server |