Ah well I have made some progress since this previous posting. Still no answers on the cause though.
I downloaded 'Administration Tools' from the apple website and started the 'Workgroup Manager.app'. This allowed me to change the settings for the 'postgres' user. I had to change the settings that gave 'postgres' a shell and a home directory. I could then perform 'sudo -u postgresql /sw2/bin/initdb /sw2/var/ postgresql-8.2/data' to create a new database. and 'sudo -u postgesql /sw2/bin/pgsql.sh-8.2 start' to start up the database. I haven't worked out yet if this will start up as a daemon on os restart. The other thing is that I have a sneaky suspicion that the install process might have done an 'initdb' somewhere but I'm stuffed if I can find it. I looked for the PG_VERSION file using mdfind but to no avail. The saga continues On 04/03/2008, at 12:39 PM, Upi Weston wrote: > I'm having trouble with the postgres user after upgrading to > postgresql82 > Following the install of postgresql82 I have not been able to login as > the 'postgres' user. This user existed before as I was running > postgresql 8.0. > I do vaguely recall the install prompt me regarding passwords etc but > not understanding the issue I just excepted the default. > > I'm now not sure how to login as the 'postgres' user anymore since I > need to do this to dump the old tables from postgresql 8.0. > I am guessing that this has something to do with the use of Directory > Services. > > Any ideas how I can resolve the issue of dumping my 8.0 databases and > loading them into 8.2. Also, how can I do that without being able to > login as 'postgres' and starting pg_ctl? > > > > > PS: I have been running postgresql80 on tiger and have just upgraded > to postgresql82 using leopard. > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Fink-beginners mailing list > [email protected] > http://news.gmane.org/gmane.os.apple.fink.beginners ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Fink-beginners mailing list [email protected] http://news.gmane.org/gmane.os.apple.fink.beginners
