Re: Move cluster to new host, upgraded version

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Re: Move cluster to new host, upgraded version
Дата
Msg-id alpine.LNX.2.20.1811140652550.26515@salmo.appl-ecosys.com
обсуждение исходный текст
Ответ на Re: Move cluster to new host, upgraded version  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Move cluster to new host, upgraded version  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Move cluster to new host, upgraded version  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Tue, 13 Nov 2018, Adrian Klaver wrote:

> Just realized the question I should have asked is:
> How did you get the pg_dumpall file processed by Postgres?
> In other words how did you do it without a password?

   As user postgres I entered the command
$ psql -f dump-all.sql

   In any case, I need to back up because I missed something when
initializing the cluster.

   ps ax | grep postgres

shows a number of processes, but psql tells me there's no server running,
and there is no postmaster.opts or postmaster.pid in the data directory.

   I can delete contents of the data directory and re-initdb, or re-install
the application and start from scratch.

Advice appreciated,

Rich


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

Предыдущее
От: Nicolas Paris
Дата:
Сообщение: Default Privilege Table ANY ROLE
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Move cluster to new host, upgraded version