New DB cluster.

Поиск
Список
Период
Сортировка
От Ron Watkins
Тема New DB cluster.
Дата
Msg-id 2c7401d3ac09$edecab30$c9c60190$@gmail.com
обсуждение исходный текст
Ответы Re: New DB cluster.
Список pgsql-novice

I finally got postgresql working on the host.

Next, I read a web-site which said to use a different directory for your postgres database, you would first remove the old directory then run the init commands to create a new cluster. However, when I tried that I ran into a problem…

Now im out of action again with no database and no server running…

 

postgres@localhost ~$ pg_ctl initdb -D /pgsql/data

The 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 "en_US.UTF-8".

The default database encoding has accordingly been set to "UTF8".

The default text search configuration will be set to "english".

 

Data page checksums are disabled.

 

creating directory /pgsql/data ... ok

creating subdirectories ... ok

selecting default max_connections ... 100

selecting default shared_buffers ... 128MB

selecting dynamic shared memory implementation ... posix

creating configuration files ... ok

running bootstrap script ... ok

performing post-bootstrap initialization ... ok

syncing data to disk ... ok

 

WARNING: enabling "trust" authentication for local connections

You can change this by editing pg_hba.conf or using the option -A, or

--auth-local and --auth-host, the next time you run initdb.

 

Success. You can now start the database server using:

 

    /usr/pgsql-10/bin/pg_ctl -D /pgsql/data -l logfile start

 

postgres@localhost ~$ pg_ctl -D /pgsql/data -l logfile start

waiting for server to start.... stopped waiting

pg_ctl: could not start server

Examine the log output.

postgres@localhost ~$ cat logfile

2018-02-22 11:18:51.702 MST [3113] LOG:  listening on IPv6 address "::1", port 5432

2018-02-22 11:18:51.702 MST [3113] LOG:  listening on IPv4 address "127.0.0.1", port 5432

2018-02-22 11:18:51.703 MST [3113] FATAL:  could not create lock file "/var/run/postgresql/.s.PGSQL.5432.lock": No such file or dire                                                                                                         ctory

2018-02-22 11:18:51.703 MST [3113] LOG:  database system is shut down

В списке pgsql-novice по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Differing data directories
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: New DB cluster.