Where is the function add_users defined? I see it in the Portfile for postgresql13-server.
Peter -- Peter West p...@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 <li...@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 > p...@pbw.id.au > “…a light for revelation to the Gentiles, and for glory to your people > Israel.” >