On Thu, Jul 29, 2010 at 8:15 AM, Mudy Situmorang wrote:
> psql runs only from the server, while pgAdmin (which is a standard
> installation in PostgerSQL for windows) easily installed in any clients.
Incorrect. psql, like pretty much any PostgreSQL client can run on any
machine and connect to a
Ok, Thanks for the answer.
2010/7/29 Guillaume Lelarge
> Le 29/07/2010 09:15, Mudy Situmorang a écrit :
> > psql runs only from the server, while pgAdmin (which is a standard
> > installation in PostgerSQL for windows) easily installed in any clients.
> >
>
> Wrong. psql can run from anywhere.
Le 29/07/2010 09:15, Mudy Situmorang a écrit :
> psql runs only from the server, while pgAdmin (which is a standard
> installation in PostgerSQL for windows) easily installed in any clients.
>
Wrong. psql can run from anywhere. "psql -h ip_of_the_server -U
my_superuser postgres" will connect to
psql runs only from the server, while pgAdmin (which is a standard
installation in PostgerSQL for windows) easily installed in any clients.
In a network with several different projects & many databases that requires
dozens of superuser, pg_hba could provide the required access control.
In this b
Le 29/07/2010 07:34, Mudy Situmorang a écrit :
> Superuser without pg_hba could drop database from client at pgAdminIII
> Object browser by left click & Delete/Drop.
>
> User has superuser rights, but no pg_hba connection entry for the host.
>
> There are warnings on left click, twice:
> An error
Superuser without pg_hba could drop database from client at pgAdminIII
Object browser by left click & Delete/Drop.
User has superuser rights, but no pg_hba connection entry for the host.
There are warnings on left click, twice:
An error has occured:
FATAL: no pg_hba.conf entry for host "172.17.0.
