Hi,
I'm new to this list, and I need a little advice on PostgreSQL database initialization. The pgsql and postgres groups and users from my OSX 10.2 Fink installation all have the same ID (252). I have seen this mentioned on a Fink mailing list, but I still don't understand this ID sharing. It seems initializing under one name would be preferable to initializing under another name with respect to Fink/PostgreSQL upgrades.
Which DB initialization method would be the most compatible with future postgresql73 upgrades:
sudo -u pgsql /sw/bin/initdb -D /sw/var/postgresql/data
or
sudo chown -R postgres /sw/var/postgresql sudo -u postgres /sw/bin/initdb -D /sw/var/postgresql/data
or
sudo -u #252 /sw/bin/initdb -D /sw/var/postgresql/data
or
some other command(s)?
Also, what is the purpose of sharing the same ID across groups and users?
Well, the sharing is a side-effect of something we don't handle, unfortunately. I think the passwd package needs to be updated to remove groups and users.
Basically, postgresql used to use the user "postgres", but that caused all kinds of problems, so I changed it to use "pgsql" instead. If this were a normal unix, it would have worked just fine, but apparently netinfo is getting a tad confused.
PostgreSQL is pending a major cleanup as soon as I have the chance, until then, it's really best to do everything as 'pgsql', that's what it will be set to eventually.
-- [ Benjamin Reed a.k.a. Ranger Rick ] [ http://ranger.befunk.com/ ] "In the pants of peace, there will always be pockets of resistance." -- Fake Geraldo on Conan O'Brien
------------------------------------------------------- This SF.net email is sponsored by: ObjectStore. If flattening out C++ or Java code to make your application fit in a relational database is painful, don't do it! Check out ObjectStore. Now part of Progress Software. http://www.objectstore.net/sourceforge _______________________________________________ Fink-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/fink-users
