Re: BUG #16204: Fail to setup - Mailing list pgsql-bugs
| From | 小林 巧 |
|---|---|
| Subject | Re: BUG #16204: Fail to setup |
| Date | |
| Msg-id | TYAPR01MB3885435554E6D2B1B12BC5CADA3A0@TYAPR01MB3885.jpnprd01.prod.outlook.com Whole thread Raw |
| In response to | Re: BUG #16204: Fail to setup (Tom Lane <tgl@sss.pgh.pa.us>) |
| Responses |
Re: BUG #16204: Fail to setup
|
| List | pgsql-bugs |
Dear Tom
Thank you for your reply.
Yeah my guess seem to be wrong but the log says "Success" like this:
[root@tkw-pgcl-sv004 ~]# ls -l /var/lib/pgsql/10/initdb.log
[root@tkw-pgcl-sv004 ~]#
-rw-------. 1 postgres postgres 831 1月 12 00:52 /var/lib/pgsql/10/initdb.log
[root@tkw-pgcl-sv004 ~]# cat /var/lib/pgsql/10/initdb.logThe files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "C".
The default text search configuration will be set to "english".
Data page checksums are enabled.
fixing permissions on existing directory /mnt/postgres/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default timezone ... Asia/Tokyo
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
Success. You can now start the database server using:
/usr/pgsql-10/bin/pg_ctl -D /mnt/postgres/data -l logfile start
And I have another hypothesis that
"The path used in postgresql-10-setup:L151,L158 is different from data path I set in the environment variable PGSETUP_INITDB_OPTION"
[root@tkw-pgcl-sv004 ~]# ls -l /var/lib/pgsql/10/data//PG_VERSION
ls: cannot access /var/lib/pgsql/10/data//PG_VERSION: No such file or directory
[root@tkw-pgcl-sv004 ~]# ls -l /mnt/postgres/data/PG_VERSION
-rw-------. 1 postgres postgres 3 1月 12 00:52 /mnt/postgres/data/PG_VERSION
[root@tkw-pgcl-sv004 ~]# cat /mnt/postgres/data/PG_VERSION
10
from: my log below, $PGDATA might not be set from the environment variable:
+ PGDATA=/var/lib/pgsql/10/data/
+ '[' x/var/lib/pgsql/10/data/ = x ']'
+ '[' -f /etc/systemd/system/postgresql-10.service ']'
+ '[' -f /usr/lib/systemd/system/postgresql-10.service ']'
+ SERVICE_FILE=/usr/lib/systemd/system/postgresql-10.service
+ PGUPLOG=/var/lib/pgsql/10/pgupgrade.log
+ PGLOG=/var/lib/pgsql/10/initdb.log Is this some kind of bug or can I set data path not to default ?
Best regards, Takumi Kobayashi
差出人: Tom Lane <tgl@sss.pgh.pa.us>
送信日時: 2020年1月12日 0:42
宛先: chamaharun@outlook.com <chamaharun@outlook.com>
CC: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
件名: Re: BUG #16204: Fail to setup
送信日時: 2020年1月12日 0:42
宛先: chamaharun@outlook.com <chamaharun@outlook.com>
CC: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
件名: Re: BUG #16204: Fail to setup
PG Bug reporting form <noreply@postgresql.org> writes:
> I installed postgresql10.11 and ran postgresql-10-setup but it fails.
> Maybe character $ for variable of PG_VERSION is missing in
> /usr/pgsql-10/bin/postgresql-10-setup below :
No, that guess is wrong. The error message told you to look in
/var/lib/pgsql/10/initdb.log, so what does that file contain?
regards, tom lane
> I installed postgresql10.11 and ran postgresql-10-setup but it fails.
> Maybe character $ for variable of PG_VERSION is missing in
> /usr/pgsql-10/bin/postgresql-10-setup below :
No, that guess is wrong. The error message told you to look in
/var/lib/pgsql/10/initdb.log, so what does that file contain?
regards, tom lane
pgsql-bugs by date: