Screwed-up postgresql13 install

[Peter West]

Where is the function add_users defined? I see it in the Portfile for postgresql13-server.

Peter

--
Peter West
pbw at pbw.id.au
“…a light for revelation to the Gentiles, and for glory to your people Israel.”

> On 4 Feb 2021, at 1:04 am, Peter West <lists at pbw.id.au> wrote:
> 
> MacOS Big Sur 11.2 MacBook Air M1
> 
> I’m migrating to the M1 from an Intel MacBook Pro running Mojave.
> 
> I installed postgresql13 and -server, and copied my defaultdb across from the Pro.
> 
> I can’t vouch for the order of these things, because I wasn’t expecting to get into a quagmire.
> 
> I tried to give the postgres user a password using passwd as root. That’s not enough. I have to use a command ’security’ with a reference to a Keychain to complete the process. In the wake of all this, I assume that the user postgres is created without a password, and that’s Ok with the default pg_hba.conf.
> 
> Then I thought that maybe I should build up the databases by dumping databases from the Pro and restoring to the M1. So I uninstalled the postgresql ports and tried to delete /opt/local/var/db/postgresql13. The defaultdb disappeared but root was not allowed to remove a directory Library sitting beside the defaultdb. It had Preferences and Keychains subdirs, and they wouldn’t go.
> 
> I deleted the postgres user through the System Preferences, but that left the entry for _postgres in /etc/passwd.
> 
> Ok, install postgresql13 again. Installation proceeded, but this time did not create the postgres user visible through System Preferences, which I assume was created when I first installed.
> 
> When I try to access the macports wrapper (via su) to start the database, I get the complaint
> shell-init: error retrieving current directory: getcwd: cannot access parent directories: Permission denied
> could not identify current directory: Permission denied (3times)
> The program “postgres” is needed by pg_ctl but was not found in the same directory as pg_ctl
> (for obvious reasons, me)
> Check your installation.
> (you don’t say)
> 
> Any advice on how I can clean this up and start again.
> 
> Peter
> 
> --
> Peter West
> pbw at pbw.id.au
> “…a light for revelation to the Gentiles, and for glory to your people Israel.”
>