pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRE: [ODBC] fatal ODBC error?
2+ messages / 2 participants
[nested] [flat]
* RE: [ODBC] fatal ODBC error?
@ 2001-07-12 07:50 Christian Bucanac <christian.bucanac@mindark.com>
0 siblings, 1 reply; 2+ messages in thread
From: Christian Bucanac @ 2001-07-12 07:50 UTC (permalink / raw)
To: 'jim davis' <jdavis@amphi.com>; pgsql-interfaces
You have to
* start postmaster with the -i option, see man postmaster
* add host config to pg_hba.conf, see pg_hba.conf
* enter the right configuration in the odbc driver
* make sure the user you are connecting as exists in the db, see createuser
/Buckis
-----Original Message-----
From: jim davis [mailto:jdavis@amphi.com]
Sent: den 11 juli 2001 22:09
To: pgsql-odbc@postgresql.org
Subject: [ODBC] fatal ODBC error?
I posted this on the "Novice" list, but the more I think about it, I
more I think it should be asked here. I have downloaded the 7.1.2
version of PostgreSQL and ./configure'ed it with --enable-odbc and
gmake'd install-with-full-headers, I started it with
/usr/local/pgsql/bin postmaster -D /usr/local/pgsql/data. Then I went
in with "Webmin v. .82" and opened it up so any host can see any
database, created a "testdb" database. I then downloaded from a
postgresql mirror the pgsql_ODBC drivers and installed it on my win2k
box. then when I try and access the testdb database with the ODBC
driver, I see on the server, an error that says, "FATAL 1: Database
template0 not accepting connections" and the win2k box cant connect...
help?
-Jim Davis
Network Coordinator II
Amphitheater Public Schools
Voice: (520)696-5120
Fax: (520)696-5070
e-mail: jdavis@amphi.com
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [ODBC] fatal ODBC error?
@ 2001-07-13 15:35 jim davis <jdavis@amphi.com>
parent: Christian Bucanac <christian.bucanac@mindark.com>
0 siblings, 0 replies; 2+ messages in thread
From: jim davis @ 2001-07-13 15:35 UTC (permalink / raw)
To: Christian Bucanac <christian.bucanac@mindark.com>; +Cc: pgsql-odbc@postgresql.org; pgsql-novice@postgresql.org
Thanks!! the -i option was the key.
-Jim
Christian Bucanac wrote:
>
> You have to
> * start postmaster with the -i option, see man postmaster
> * add host config to pg_hba.conf, see pg_hba.conf
> * enter the right configuration in the odbc driver
> * make sure the user you are connecting as exists in the db, see createuser
>
> /Buckis
>
> -----Original Message-----
> From: jim davis [mailto:jdavis@amphi.com]
> Sent: den 11 juli 2001 22:09
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] fatal ODBC error?
>
> I posted this on the "Novice" list, but the more I think about it, I
> more I think it should be asked here. I have downloaded the 7.1.2
> version of PostgreSQL and ./configure'ed it with --enable-odbc and
> gmake'd install-with-full-headers, I started it with
> /usr/local/pgsql/bin postmaster -D /usr/local/pgsql/data. Then I went
> in with "Webmin v. .82" and opened it up so any host can see any
> database, created a "testdb" database. I then downloaded from a
> postgresql mirror the pgsql_ODBC drivers and installed it on my win2k
> box. then when I try and access the testdb database with the ODBC
> driver, I see on the server, an error that says, "FATAL 1: Database
> template0 not accepting connections" and the win2k box cant connect...
> help?
>
> -Jim Davis
> Network Coordinator II
> Amphitheater Public Schools
> Voice: (520)696-5120
> Fax: (520)696-5070
> e-mail: jdavis@amphi.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-07-13 15:35 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-07-12 07:50 RE: [ODBC] fatal ODBC error? Christian Bucanac <christian.bucanac@mindark.com>
2001-07-13 15:35 ` jim davis <jdavis@amphi.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox