Re: accidentally deleted user --> postgres

This error actually indicates that the host and port information you are
providing for the PostgreSQL database server is incorrect or there is not
database server running on that (or it might be the firewall settings too).

First of all what I will recommend is to check on your database server to
see if the db server is running or not. You can do that using:

pg_ctl -D <data folder path> status

Once that gives a good status then you might have to tweak 'pg_hba.conf'
file to allow for users connecting to the database.

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 2/2/07, gf <gforty(at)gmail(dot)com> 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.
>
> 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.
> --
> View this message in context:
> http://www.nabble.com/accidentally-deleted-user---%3E-postgres-tf3161276.html#a8768443
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>