Page 1 of 2
Reinstalling PostgreSQL

Posted:
Sat Nov 22, 2008 6:01 am
by BennyBoy
I've had problems with turning PostgreSQL on since installing Norton. I managed to disable Norton but still coudln't get it to switch on.
I decided to uninstall and re-install PostgreSQL. But when I re-install it asks for a password for the superuser and service account. I seem to recall that PT3 auto installed PostgreSQL for me so I didn't set up an account or password.
Any idea how I get past this problem?
Thanks
Re: Reinstalling PostgreSQL

Posted:
Sat Nov 22, 2008 6:10 am
by WhiteRider
The default password is 'dbpass' (no quotes).
Alternatively, you can remove the need for postgres passwords:
How To: Remove PostgreSQL Password
Re: Reinstalling PostgreSQL

Posted:
Sat Nov 22, 2008 6:23 am
by BennyBoy
The default password doesn't work.
So I tried the removing the need for password route, when I try to edit and save the text it denies me access.
Any idea from here?
Thanks
Re: Reinstalling PostgreSQL

Posted:
Sat Nov 22, 2008 7:47 am
by WhiteRider
Re: Reinstalling PostgreSQL

Posted:
Sat Nov 22, 2008 1:25 pm
by BennyBoy
I'm actually on XP so I assume this doesn't apply
Re: Reinstalling PostgreSQL

Posted:
Sat Nov 22, 2008 1:58 pm
by WhiteRider
That's right, but if you're using XP you ought to be able to edit and save the file..
Is this your own XP machine? Do you have full permissions on it? Are you running as an administrator?
Re: Reinstalling PostgreSQL

Posted:
Sat Nov 22, 2008 2:13 pm
by BennyBoy
I've logged on as administrator in safe mode and managed to change the file to "trust", but it's still asking me for a password when I try to re-install PostgreSQL.
I'm such an IT donk
Re: Reinstalling PostgreSQL

Posted:
Sat Nov 22, 2008 2:22 pm
by BennyBoy
I'm installing the Windows version of the one-click installation on the postegresql website - i assume this is right?
I also assume if i install and re-install PT3 and PostgreSQL I am likely to encounter the same problem?
Thanks.
Re: Reinstalling PostgreSQL

Posted:
Sat Nov 22, 2008 2:34 pm
by WhiteRider
Is there a reason that you're installing postgres manually?
The PT3 with postgres installer should set everything up for you.
If you don't have any postgres databases you need to keep, try a full postgres uninstall / reinstall.
Total uninstall/reinstall of pt3
Re: Reinstalling PostgreSQL

Posted:
Sat Nov 29, 2008 5:33 pm
by DerekG
I also have XP, I have dbs I need to keep and I have the exact same problem. I have never been able to update a version of PSQL because it keeps giving me some bs "you must have rights to install system services" error messages (I'm an administrator). So I know going in I have to do a complete uninstall/reinstall of PSQL even for an update. Only problem is this time I get the same message BennyBoy gets. It's like there are two sets of passwords somewhere. One to access the databases and another for some kind of account it calls a superuser/postgres account. I also have the hba.conf file set to 'Trust' - doesn't help.
In the past, uninstall/reinstalls of PSQL used to work. No longer.