: pgsql-general@lists.postgresql.org
Subject: Re: pg_ctl can't start db server
Tanja Savic writes:
The configuration file path is /etc/postgresql/12/main/ postgresql.conf and it
is configured in /var/lib/postgresql/12/main/postmaster.opts:
"/usr/lib/postgresql/12/bin/postgres "-D"
Hi Tanja,
> On 01. Jun, 2020, at 09:04, Tanja Savic export
> PGDATA=" /var/lib/postgresql/12/main"
my wild guess is that the blank should not be there.
Cheers,
Paul
24538 online postgres /var/lib/postgresql/12/main
/var/log/postgresql/postgresql-12-main.log
Thank you for your replies.
BR,
Tanja
-Original Message-
From: Tom Lane
Sent: Friday, May 29, 2020 5:32 PM
To: Tanja Savic
Cc: pgsql-general@lists.postgresql.org
Subject: Re: pg_ctl can&#x
On 5/29/20 8:19 AM, Tanja Savic wrote:
Hi,
We did the upgrade of PostgreSQL 10 to 12 on linux server. Everything
was fine (can connect via pgAdmin, data is there…) except two
tablespaces which are still in directory for PostgreSQL 10.
So we followed these steps to move tablespaces:
https://
Tanja Savic writes:
> The configuration file path is /etc/postgresql/12/main/ postgresql.conf and
> it is configured in /var/lib/postgresql/12/main/postmaster.opts:
> "/usr/lib/postgresql/12/bin/postgres "-D" "/var/lib/postgresql/12/main" "-c"
> "config_file=/etc/postgresql/12/main/postgresql.c
Hi,
We did the upgrade of PostgreSQL 10 to 12 on linux server. Everything was fine
(can connect via pgAdmin, data is there...) except two tablespaces which are
still in directory for PostgreSQL 10.
So we followed these steps to move tablespaces:
https://www.enterprisedb.com/blog/moving-tablespa
