Postgres Pro
Downloads
Home   >   mailing lists

Thread: first time

first time

From
"Camila Rocha"
Date:
Hi!
I'm a student from brazil... i want to know what should i write in the fields datasource, user and password.
sorry for the bad english and the stupid question!
 
thanx!

Re: first time

From
Dave Page
Date:
If you have a datasouce field, then you need to upgrade to the latest version from http://www.pgadmin.org. Versions or pgAdmin with the datasource field haven't been supported for some time.
 
Regards, Dave.
-----Original Message-----
From: Camila Rocha [mailto:camilarrocha@hotmail.com]
Sent: 08 April 2002 04:46
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] first time

Hi!
I'm a student from brazil... i want to know what should i write in the fields datasource, user and password.
sorry for the bad english and the stupid question!
 
thanx!

Re: first time

From
"Camila Rocha"
Date:
Thanks, but it didn't work... I created the driver, with this parameters:
 
 
 
i tried localhost as a server too. It's a local machine, with no connections.
 
But, when i tried to open pgAdmin, this error message appeared:
 
 
 
what can i do????????????????
 
 
 
 
----- Original Message -----
Sent: Monday, April 08, 2002 3:37 AM
Subject: RE: [pgadmin-support] first time

Camila,
When you created an ODBC connection to a database (in our case to a Postgresql database) you told it a few things:
1. The name of the host (this is the name of the machine where Postgresql server is running)
2. The port number (this is the number of the port where Postgresql is listening for requests. The default value is 5432)
3. Database Name. Here you write the name of the database you wish to connect to. If you have several databases and you will be using this ODBC connection to connect to any of them, then it is better that you leave this field blank.
4. User and Password: This is the user id that has privileges to access the database.and its respective password. You can leave this two fields in blank or you can enter the information.
 
The ODBC connection that you created above was saved with a name. This name is known as the DATASOURCE. For example if you saved the ODBC connection above with the name "postgres" then every time your are asked for the datasource you will have to write "postgres".
 
Once you created an ODBC connection, you tell pgAdmin the information it needs: DATASOURCE is the name of the ODBC connection that you created above. If in the above connection you entered a user name and password then you do not have to entered here in pgAdmin. If you did not entered a user id and password in the ODBC connection then you will have to enter them here.
 
NOTE: Remember that to be able to create an ODBC connection to Postgresql you have to install an ODBC driver for Postgresql. To create the ODBC connection you will go to the ODBC administrator in the control pannel.
-----Original Message-----
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org]On Behalf Of Camila Rocha
Sent: Sunday, April 07, 2002 11:46 PM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] first time

Hi!
I'm a student from brazil... i want to know what should i write in the fields datasource, user and password.
sorry for the bad english and the stupid question!
 
thanx!
Attachment

Re: first time

From
Jean-Michel POURE
Date:
Le Lundi 8 Avril 2002 20:39, Camila Rocha a écrit :
> Thanks, but it didn't work... I created the driver, with this parameters:
> i tried localhost as a server too. It's a local machine, with no
> connections.
> But, when i tried to open pgAdmin, this error message appeared:
> what can i do????????????????

1) General Windows setup:
http://www.ejip.net/faq/postgresql_win_setup_faq.jsp.
2) Is socket connection enabled on PostgreSQL? Have a look at
/var/lib/pgsql/data/ files.
3) Log in template1 database.

Cheers,
Jean-Michel