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?
Derek
------------------------------------------------------- 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
