pgAdminII Error

Started by javier garcia - CEBASover 22 years ago8 messagesgeneral
Jump to latest
#1javier garcia - CEBAS
rn001@cebas.csic.es

Hi all;
Up to date. I've used Microsoft Access as a WindowsXP Client for Postgres.
But I want to know if pgAdmin can do the job.
I've downloaded pgAdminII Version 1.6.0 for Windows.
My current Postgres version is 7.2
And I can acces it from Microsoft Access2000
.
When I try to connect the server from pgAdminI, I receive the message:

FATAL1: Missing or erroneous pg_hba.conf file, see postmaster log for details.

But I'm using postgres with normality. Can you help me with this?

Thanks and regards

Javier

#2Carmen Gloria Sepulveda Dedes
csepulveda@atichile.com
In reply to: javier garcia - CEBAS (#1)
Schema

Hi!

I want to know if the statement "create schema" exists for postgres 7.3.x.

Thanks.

CGS

#3Bruno Wolff III
bruno@wolff.to
In reply to: Carmen Gloria Sepulveda Dedes (#2)
Re: Schema

On Fri, Aug 22, 2003 at 10:12:05 -0400,
Carmen Gloria Sepulveda Dedes <csepulveda@atichile.com> wrote:

Hi!

I want to know if the statement "create schema" exists for postgres 7.3.x.

Yes. Schemas got added to Postgres in 7.3.

#4Dennis Bjorklund
db@zigo.dhs.org
In reply to: Carmen Gloria Sepulveda Dedes (#2)
Re: Schema

On Fri, 22 Aug 2003, Carmen Gloria Sepulveda Dedes wrote:

I want to know if the statement "create schema" exists for postgres 7.3.x.

http://www.postgresql.org/docs/7.3/static/sql-createschema.html

--
/Dennis

#5Carmen Gloria Sepulveda Dedes
csepulveda@atichile.com
In reply to: javier garcia - CEBAS (#1)
Re: Schema

Thanks.
Exists a one to one relationship between schemas and users?

Bruno Wolff III wrote:

Show quoted text

Yes. Schemas got added to Postgres in 7.3.

#6scott.marlowe
scott.marlowe@ihs.com
In reply to: Carmen Gloria Sepulveda Dedes (#2)
Re: Schema

On Fri, 22 Aug 2003, Carmen Gloria Sepulveda Dedes wrote:

Hi!

I want to know if the statement "create schema" exists for postgres 7.3.x.

Yes it does.

#7Alvaro Herrera
alvherre@dcc.uchile.cl
In reply to: Carmen Gloria Sepulveda Dedes (#5)
Re: Schema

On Fri, Aug 22, 2003 at 10:28:56AM -0400, Carmen Gloria Sepulveda Dedes wrote:

Thanks.
Exists a one to one relationship between schemas and users?

No.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Crear es tan dificil como ser libre" (Elsa Triolet)

#8Ron St-Pierre
rstpierre@syscor.com
In reply to: javier garcia - CEBAS (#1)
Re: pgAdminII Error

javier garcia - CEBAS wrote:

Hi all;
Up to date. I've used Microsoft Access as a WindowsXP Client for Postgres.
But I want to know if pgAdmin can do the job.
I've downloaded pgAdminII Version 1.6.0 for Windows.
My current Postgres version is 7.2
And I can acces it from Microsoft Access2000
.
When I try to connect the server from pgAdminI, I receive the message:

FATAL1: Missing or erroneous pg_hba.conf file, see postmaster log for details.

But I'm using postgres with normality. Can you help me with this?

Thanks and regards

Javier

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

You need to change your pg_hba.conf file to grant access for pgAdimII's
user and ip address, by adding/modifying a line in the conf file. Then
restart the postmaster or send it a sighup to reread the configuration
settings. Check out the documentation at
http://www.postgresql.org/docs/7.3/static/client-authentication.html

Ron