Re: problem with access database

Hello

I use 1.12.0 PGAdminIII from a client for seven windows connect to a
postgres server 8.4.2.1 installed on a Windows 2008 server 32-bit server
(service pack 2). The connection is extremely slow.

Should we change a parameter in the configuration either Postgres or
pgAdmin?

Thank you

MCQ

-----------------------------

Marie-Claude QUIDOZ

CEFE / CNRS

1919, Route de Mende

34293 Montpellier Cedex 5

Tel : 04 67 61 32 55

Marie-Claude(dot)Quidoz(at)cefe(dot)cnrs(dot)fr
<mailto:Marie-Claude(dot)Quidoz(at)cefe(dot)cnrs(dot)fr>

Le 27/09/2010 11:58, Marie-Claude QUIDOZ a écrit :
> Hello
>
> I use 1.12.0 PGAdminIII from a client for seven windows connect to a
> postgres server 8.4.2.1 installed on a Windows 2008 server 32-bit server
> (service pack 2). The connection is extremely slow.
>
> Should we change a parameter in the configuration either Postgres or
> pgAdmin?
>

If the connection is slow, there's nothing you can do on PostgreSQL or
pgAdmin. If you're using SSL connection, disabling it will have a good
result on performance (but a bad one on security).

What do you exactly mean with connection? when you connect to a server?
when you use pgAdmin? when you launch queries?

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

Hello

I find a solution

If I put the IP number (x.x.x.x) instead of the name of the server, the connection is speed.

Thanks

MCQ

-----Message d'origine-----
De : Marie-Claude QUIDOZ
Envoyé : lundi 27 septembre 2010 15:32
À : Guillaume Lelarge
Cc : pgadmin-support(at)postgresql(dot)org
Objet : RE: [pgadmin-support] slowness in the connection

Hello

Thanks for you answer

I dont'use SSL connection for my test

Yes It is particulary slow when I want connect me to a server (for example, when I click on "cnx-xxx". -cf file) or when I want open a database

A+

MCQ

-----Message d'origine-----
De : pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org] De la part de Guillaume Lelarge Envoyé : lundi 27 septembre 2010 13:30 À : Marie-Claude QUIDOZ Cc : pgadmin-support(at)postgresql(dot)org Objet : Re: [pgadmin-support] slowness in the connection

Le 27/09/2010 11:58, Marie-Claude QUIDOZ a écrit :
> Hello
>
> I use 1.12.0 PGAdminIII from a client for seven windows connect to a
> postgres server 8.4.2.1 installed on a Windows 2008 server 32-bit
> server (service pack 2). The connection is extremely slow.
>
> Should we change a parameter in the configuration either Postgres or
> pgAdmin?
>

If the connection is slow, there's nothing you can do on PostgreSQL or pgAdmin. If you're using SSL connection, disabling it will have a good result on performance (but a bad one on security).

What do you exactly mean with connection? when you connect to a server?
when you use pgAdmin? when you launch queries?

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

--
Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Le 27/09/2010 17:47, Marie-Claude QUIDOZ a écrit :
> [...]
> I find a solution
>
> If I put the IP number (x.x.x.x) instead of the name of the server, the connection is speed.
>

Which means you have a DNS resolution issue, not a PostgreSQL or pgAdmin
issue.

You should probably talk to your sysadmin, so that he could check you
DNS config.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

Hello

I use 1.12.0 PGAdminIII from a client for seven windows connect to a postgres server 8.4.2.1 installed on a Windows 2008 server 32-bit server (service pack 2).

I want to give access at the database "PicSaintLoup" to user "rihouet"

---------------------

If I configure pg_hba.conf with this line

"host PicSaintLoup rihouet 193.49.134.96/32 md5"

I obtain this message
" Error connecting to the server : Fatal : Aucune entrée dans pg_hab.conf pour l'hote "193.49.134.96", utilisateur "rihouet", base de données "postgres", SSL inactif"

---------------------

If I configure pg_hba.conf with this line

"host postgres, PicSaintLoup rihouet 193.49.134.96/32 md5"

It is ok

--------------------

I don't understand why I must make "postgres" in this line ?

Thank you

MCQ

Le 01/10/2010 16:20, Marie-Claude QUIDOZ a écrit :
> Hello
>
> I use 1.12.0 PGAdminIII from a client for seven windows connect to a postgres server 8.4.2.1 installed on a Windows 2008 server 32-bit server (service pack 2).
>
> I want to give access at the database "PicSaintLoup" to user "rihouet"
>
> ---------------------
>
> If I configure pg_hba.conf with this line
>
> "host PicSaintLoup rihouet 193.49.134.96/32 md5"
>
> I obtain this message
> " Error connecting to the server : Fatal : Aucune entrée dans pg_hab.conf pour l'hote "193.49.134.96", utilisateur "rihouet", base de données "postgres", SSL inactif"
>
> ---------------------
>
> If I configure pg_hba.conf with this line
>
> "host postgres, PicSaintLoup rihouet 193.49.134.96/32 md5"
>
> It is ok
>
> --------------------
>
> I don't understand why I must make "postgres" in this line ?
>

By default, pgAdmin connects to the postgres database. With "by default"
I mean that you didn't change the maintenance DB in the server dialog.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

Hello

> By default, pgAdmin connects to the postgres database. With "by default"
> I mean that you didn't change the maintenance DB in the server dialog.

Yes I haven't change because I don't know what to put. I have the choice between postgres, edb or template1 and I don't find any documentation to help me to understand. I don't understand what is "maintenance DB"

Bye

MCQ

-----Message d'origine-----
De : Guillaume Lelarge [mailto:guillaume(at)lelarge(dot)info]
Envoyé : vendredi 1 octobre 2010 23:20
À : Marie-Claude QUIDOZ
Cc : pgadmin-support(at)postgresql(dot)org
Objet : Re: [pgadmin-support] problem with access database

Le 01/10/2010 16:20, Marie-Claude QUIDOZ a écrit :
> Hello
>
> I use 1.12.0 PGAdminIII from a client for seven windows connect to a postgres server 8.4.2.1 installed on a Windows 2008 server 32-bit server (service pack 2).
>
> I want to give access at the database "PicSaintLoup" to user "rihouet"
>
> ---------------------
>
> If I configure pg_hba.conf with this line
>
> "host PicSaintLoup rihouet 193.49.134.96/32 md5"
>
> I obtain this message
> " Error connecting to the server : Fatal : Aucune entrée dans pg_hab.conf pour l'hote "193.49.134.96", utilisateur "rihouet", base de données "postgres", SSL inactif"
>
> ---------------------
>
> If I configure pg_hba.conf with this line
>
> "host postgres, PicSaintLoup rihouet 193.49.134.96/32 md5"
>
> It is ok
>
> --------------------
>
> I don't understand why I must make "postgres" in this line ?
>

By default, pgAdmin connects to the postgres database. With "by default"
I mean that you didn't change the maintenance DB in the server dialog.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

Le 04/10/2010 18:36, Marie-Claude QUIDOZ a écrit :
> Hello
>
>> By default, pgAdmin connects to the postgres database. With "by default"
>> I mean that you didn't change the maintenance DB in the server dialog.
>
> Yes I haven't change because I don't know what to put. I have the choice between postgres, edb or template1 and I don't find any documentation to help me to understand. I don't understand what is "maintenance DB"
>

The maintenance database is the first database that pgAdmin will connect
to. pgAdmin needs to connect to at least one database to get the list of
the databases in the server. BTW, you can change what's in the combobox
because the editing is allowed. Just type the name of your database and
it will work.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

On 04/10/2010 17:36, Marie-Claude QUIDOZ wrote:
> Hello
>
>> By default, pgAdmin connects to the postgres database. With "by
>> default" I mean that you didn't change the maintenance DB in the
>> server dialog.
>
> Yes I haven't change because I don't know what to put. I have the
> choice between postgres, edb or template1 and I don't find any
> documentation to help me to understand. I don't understand what is
> "maintenance DB"

The "maintenance DB" is just a database to which pgAdmin connects by
default, before you click some other one which you're going to work on.
There's nothing special about it - it's usually an empty database.

This is necessary because PostgreSQL doesn't have the concept of just
"connecting to the server" - you *have* to connect to a specific
database as well. In a normal PostgreSQL installation, the "postgres"
database is provided as a convenience for this purpose.

I presume that "edb" is the equivalent in EnterpriseDB - the EDB folks
here will be able to confirm.

"template1" is what was used in older versions of PostgreSQL. However,
template1 is also used as a default template when new databases are
created, so having a separate "postgres" database keeps things tidy.

I hope that this makes sense. :-)

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

On Mon, Oct 4, 2010 at 5:45 PM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:

> I presume that "edb" is the equivalent in EnterpriseDB - the EDB folks here
> will be able to confirm.

It is.

> "template1" is what was used in older versions of PostgreSQL. However,
> template1 is also used as a default template when new databases are created,
> so having a separate "postgres" database keeps things tidy.

Thats correct.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company

Hello

I don't find how i can use the command "copy from" with pgadmin in sql
windows

When i try to execute this command
"copy dico_coordonnee_geographique from 'C:/Dossier de
travail/Temporaire/dico_coordonnee"

I receive this text
" ERREUR: n'a pas pu ouvrir le fichier "C:/Dossier de
travail/Temporaire/dico_coordonnee> pour une lecture : No such file or
directory

It 's ok with psql

Thanks

MCQ

Le 25/10/2010 09:54, Marie-Claude QUIDOZ a écrit :
> [...]
> I don't find how i can use the command "copy from" with pgadmin in sql
> windows
>
> When i try to execute this command
> "copy dico_coordonnee_geographique from 'C:/Dossier de
> travail/Temporaire/dico_coordonnee"
>
> I receive this text
> " ERREUR: n'a pas pu ouvrir le fichier "C:/Dossier de
> travail/Temporaire/dico_coordonnee> pour une lecture : No such file or
> directory
>
> It 's ok with psql
>

Is psql executed from the server and pgAdmin from a desktop PC?

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

Hello

Yes, but both are on windows system

MCQ

-----Message d'origine-----
De : Guillaume Lelarge [mailto:guillaume(at)lelarge(dot)info]
Envoyé : mardi 26 octobre 2010 05:43
À : Marie-Claude QUIDOZ
Cc : pgadmin-support(at)postgresql(dot)org
Objet : Re: [pgadmin-support] problem with copy from on a windows system

Le 25/10/2010 09:54, Marie-Claude QUIDOZ a écrit :
> [...]
> I don't find how i can use the command "copy from" with pgadmin in sql
> windows
>
> When i try to execute this command
> "copy dico_coordonnee_geographique from 'C:/Dossier de
> travail/Temporaire/dico_coordonnee"
>
> I receive this text
> " ERREUR: n'a pas pu ouvrir le fichier "C:/Dossier de
> travail/Temporaire/dico_coordonnee> pour une lecture : No such file or
> directory
>
> It 's ok with psql
>

Is psql executed from the server and pgAdmin from a desktop PC?

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

Hello

nobody has any idea ?

MCQ

-----Message d'origine-----
De : pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org] De la part de Marie-Claude QUIDOZ
Envoyé : mardi 26 octobre 2010 08:56
À : Guillaume Lelarge
Cc : pgadmin-support(at)postgresql(dot)org
Objet : Re: [pgadmin-support] problem with copy from on a windows system

Hello

Yes, but both are on windows system

MCQ

-----Message d'origine-----
De : Guillaume Lelarge [mailto:guillaume(at)lelarge(dot)info]
Envoyé : mardi 26 octobre 2010 05:43
À : Marie-Claude QUIDOZ
Cc : pgadmin-support(at)postgresql(dot)org
Objet : Re: [pgadmin-support] problem with copy from on a windows system

Le 25/10/2010 09:54, Marie-Claude QUIDOZ a écrit :
> [...]
> I don't find how i can use the command "copy from" with pgadmin in sql
> windows
>
> When i try to execute this command
> "copy dico_coordonnee_geographique from 'C:/Dossier de
> travail/Temporaire/dico_coordonnee"
>
> I receive this text
> " ERREUR: n'a pas pu ouvrir le fichier "C:/Dossier de
> travail/Temporaire/dico_coordonnee> pour une lecture : No such file or
> directory
>
> It 's ok with psql
>

Is psql executed from the server and pgAdmin from a desktop PC?

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

On Mon, Oct 25, 2010 at 5:54 PM, Marie-Claude QUIDOZ
<Marie-Claude(dot)QUIDOZ(at)cefe(dot)cnrs(dot)fr> wrote:
> Hello
>
> I don't find how i can use the command "copy from" with pgadmin in sql
> windows
>
> When i try to execute this command
> "copy dico_coordonnee_geographique from 'C:/Dossier de
> travail/Temporaire/dico_coordonnee"
>
> I receive this text
> " ERREUR: n'a pas pu ouvrir le fichier "C:/Dossier de
> travail/Temporaire/dico_coordonnee> pour une lecture : No such file or
> directory

Are you really using COPY, or \COPY ? The latter is a client-side
feature in psql, which won't work in pgAdmin. The former is a
server-side copy, which should work in any interface, but requires the
file to be on the server.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Le 27/10/2010 03:24, Marie-Claude QUIDOZ a écrit :
> [...]
> Yes, but both are on windows system
>

When you use the COPY command, the file you specify must be on the
PostgreSQL server. When you use \copy from psql, the file must be on the
computer where you execute the \copy command.

If you use the copy command, then the file wasn't available on the
server when you launched the copy command.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com