On Wednesday, June 18, 2003, at 04:38 PM, Benjamin Reed wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
James Gibbs wrote:On Wednesday, June 18, 2003, at 09:35 AM, Benjamin Reed wrote:Then shouldn't the passwd package be changed to reflect this?
The user name was changed in postgresql-7.3.2 to "postgres" instead of "pgsql" because a lot of tools expected the "root" postgresql user to be it, and I wanted to have it "correct" before putting postgresql into stable. You might be able to go into /sw/var/postgresql/data/ and see if there's somewhere that it's looking for the default superuser.
It was.
My conjecture is that somewhere postgresql still "remembers" having been pgsql when the database was created, so it's getting pissed off that it's being started as "postgres" now.
I'm not sure about that, I haven't had a chance to test it to be certain. But it should be repairable by re-creating the "pgsql" user and group, exporting the database, and re-importing it as postgres again, if that is the case.
Well, I was partly successful. I recreated the pgsql user and group in NetInfo, chown'ed /sw/var/postgresql and all enclosed files/directories back to pgsql.pgsql, and was then able to launch postgresql. So I dumped a fresh copy of my database tables and then dropped them. I then shutdown postgresql and restored ownership to postgres.wheel. But I'm still running into problems launching as user postgres. The error report is now as follows:
[cube:~] steve_w% sudo -u postgres pg_ctl start -D /sw/var/postgresql/data
2003-06-18 23:06:41 LOG: Could not set group of /tmp/.s.PGSQL.5432: Operation not permitted
/sw/bin/postmaster: cannot create UNIX stream port
Steve Wall
------------------------------------------------------- This SF.Net email is sponsored by: INetU Attention Web Developers & Consultants: Become An INetU Hosting Partner. Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission! INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php _______________________________________________ Fink-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/fink-users
