Re: Move cluster to new host, upgraded version - Mailing list pgsql-general

From Rich Shepard
Subject Re: Move cluster to new host, upgraded version
Date
Msg-id alpine.LNX.2.20.1811140652550.26515@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Move cluster to new host, upgraded version  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Move cluster to new host, upgraded version
Re: Move cluster to new host, upgraded version
List 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 by date:

Previous
From: Nicolas Paris
Date:
Subject: Default Privilege Table ANY ROLE
Next
From: Adrian Klaver
Date:
Subject: Re: Move cluster to new host, upgraded version