gf wrote:
Hello all,
I was recently installing pg on a virtual machine. I also had pg installed
and working on my local machine.
On the vm I was having some issues installing a Drupal db so in searching
for a solution I found a recommendation of the following:
net user postgres /delete
and then reinstall pg.
You will find that this is a standard system userid that was removed and
is normally setup/created when installing postgresql. You will need to
either reinstall postgresql on your local system or recreate the
postgres user on your local system (not your vm)
Part of the security of postgresql is that the user running the server
itself has limited privileges so that the database data is all that it
can access. Without this user account it will not run, if you create the
userid manually make sure it is not a member of the admin group and
check that the postgresql service is started with that userid.
I ran this command in what I thought was my newly built virtual machine's
dos window but it turned out to be the window for my localmachine which had
a fully functioning pg install with several dbs.
I was able to get my virtual machine up and running with pg and drupal as I
was easily able to reinstall pg.
The problem I have is I cannot connect to the postgres sql server database
using pgadmin III on my localmachine(the one I accidentally ran net user
postgres /delete on).
If I open up pgadmin and then in left column I have:
database
below this I have:
PostgreSQL Database Server 8.1(localhost:5432)...
If I right click on the above and select connect, I get the following error:
Server doesn't listen
The server doesn't accept connections: the connection library reports
could not connect to server: Connection refused (0x0000274D/10061) Is the
server running on host "127.0.0.1" and accepting TCP/IP connections on port
5432?
Any Ideas?
I am new to PG so perhaps it is a simple adduser statement(I hope)?
Thanks in advance.
--
Shane Ambler
pgSQL@xxxxxxxxxxxxxxxx
Get Sheeky @ http://Sheeky.Biz
