Re: [GENERAL] pgadmin3 / postgresql newbie question

2005-03-02 Thread Guy Rouillier
Jonathan Schreiter wrote: > i can't seem to connect to the new database using > pgadmin3. i have the correct IP address of the local > computer, default port 5432, mydb as the initaldb, > postgres as the username, and my new password as the > password. i keep getting the error > > Error connecting

Re: [GENERAL] pgadmin3 / postgresql newbie question

2005-03-02 Thread Edward Macnaghten
pgadmin3 does not seem to want to connect to the server using UNIX sockets, it only does it through TCP. Set up the Postgres server to use TCP (as well as UNIX sockets) - i.e. - starting postmaster with the -i option, sorting it pg_hba.conf etc. Eddy Jonathan Schreiter wrote: hi all, running am

Re: [GENERAL] pgadmin3 / postgresql newbie question

2005-03-02 Thread Greg Patnude
That particular error message is typically associated with a missing pg_hba.conf entry that tells the postgreSQL server which remote machines to allow connections FROM # If you want to allow non-local connections, you need to add more # "host" records. Also, remember TCP/IP connections are

Re: [GENERAL] pgadmin3 / postgresql newbie question

2005-03-02 Thread Sim Zacks
Did you set up the pg_hba.conf file with the proper security rights? "Jonathan Schreiter" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > hi all, > running amd64 fedora core 3 w/ default postgresql > 7.4.7-3. did asu - , su postgres and createdb mydb as > explained in the postgresql

Re: [GENERAL] pgadmin3 / postgresql newbie question

2005-03-02 Thread Marco Colombo
On Wed, 2 Mar 2005, Jonathan Schreiter wrote: hi all, running amd64 fedora core 3 w/ default postgresql 7.4.7-3. did asu - , su postgres and createdb mydb as explained in the postgresql tutorial. installed the latest pgadmin3 and am trying to connect to this database. as i wasn't sure what the FC3

Re: [GENERAL] pgadmin3 / postgresql newbie question

2005-03-02 Thread Sean Davis
Did you start the postmaster using '-i' to allow tcp/ip connections? Sean On Mar 2, 2005, at 6:15 AM, Jonathan Schreiter wrote: hi all, running amd64 fedora core 3 w/ default postgresql 7.4.7-3. did asu - , su postgres and createdb mydb as explained in the postgresql tutorial. installed the latest

[GENERAL] pgadmin3 / postgresql newbie question

2005-03-02 Thread Jonathan Schreiter
hi all, running amd64 fedora core 3 w/ default postgresql 7.4.7-3. did asu - , su postgres and createdb mydb as explained in the postgresql tutorial. installed the latest pgadmin3 and am trying to connect to this database. as i wasn't sure what the FC3 default password was for postgres, i changed i