pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedOpen database with Pgaccess
3+ messages / 2 participants
[nested] [flat]
* Open database with Pgaccess
@ 1999-02-28 15:57 fabien.vallon <fabien.vallon@wanadoo.fr>
1999-02-28 16:00 ` Re: [INTERFACES] Open database with Pgaccess Leo Cyr <lcyr@itnetsys.com>
0 siblings, 1 reply; 3+ messages in thread
From: fabien.vallon @ 1999-02-28 15:57 UTC (permalink / raw)
To: pgsql-interfaces
I know, it's a basic question (sory) but i didn't find doc.
I'm working with Postgres6.3.2 and pgacess0.9 (with Linux Redhat 5.2 or
Debian 2.0)
I've done :
* on root account
* su postgres
* createuser Dizzy (this user already exists (users-group))
* that's was Ok
* on Dizzy account
*createdb KADOCKDB
*psql KADOCKDB
*create table client (nom_client char(20) not null primary
key);
And all seems OK
But with Pgaccess, I can't open database
Host localhost
Port 5432 (???)
Database KADOCKDB
Username Dizzy
Password (Dizzy-Password)
Error connecting database
Is postmaster running (Yes )
and accepting TCP.IP connection at 'localhost' on port '5432' (I don't
know)
Thanks for you answer
( Where can i find documentation and script about
Apache->CGI(Perl)->Postgres ?)
(I've downloaded DBI an DBD)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Open database with Pgaccess
1999-02-28 15:57 Open database with Pgaccess fabien.vallon <fabien.vallon@wanadoo.fr>
@ 1999-02-28 16:00 ` Leo Cyr <lcyr@itnetsys.com>
0 siblings, 0 replies; 3+ messages in thread
From: Leo Cyr @ 1999-02-28 16:00 UTC (permalink / raw)
To: fabien.vallon <fabien.vallon@wanadoo.fr>; +Cc: pgsql-interfaces
By default postgres only listens on Unix domain sockets NOT TCP/IP. You
need to edit the startup script for postgres and pass the call to
postmaster the "-i" parameter. You should see this and more with man
postmaster. I use my own build of postgres so my startup scripts is home
brew, but you can start by following the symbolic link in /etc/rc.d/rc3.d
(if you boot the server to text console) or /etc/rc.d/rc5.d (if the server
boots to some x login). To do this just do an "ls -l | grep post" you
should see where the link points.
As for apache, perl, and postgres I have found if I scrutinized the
directores in the DBD-Pg-<version> directory there is a test.pl for both
standard ops and one for blobs. Note, If your "make test" when you
installed the DBD-Pg stuff that means that the code in test.pl will run.
And is therefore the best simple example around. As far as general doc
on DBI I found great examples to get me started at
www.hermetica.com/technologia/perl/DBI.
On 28 Feb 1999, fabien.vallon wrote:
> I know, it's a basic question (sory) but i didn't find doc.
> I'm working with Postgres6.3.2 and pgacess0.9 (with Linux Redhat 5.2 or
> Debian 2.0)
> I've done :
> * on root account
> * su postgres
> * createuser Dizzy (this user already exists (users-group))
> * that's was Ok
>
> * on Dizzy account
> *createdb KADOCKDB
> *psql KADOCKDB
> *create table client (nom_client char(20) not null primary
> key);
> And all seems OK
>
> But with Pgaccess, I can't open database
> Host localhost
> Port 5432 (???)
> Database KADOCKDB
> Username Dizzy
> Password (Dizzy-Password)
>
> Error connecting database
> Is postmaster running (Yes )
> and accepting TCP.IP connection at 'localhost' on port '5432' (I don't
> know)
>
> Thanks for you answer
>
> ( Where can i find documentation and script about
> Apache->CGI(Perl)->Postgres ?)
> (I've downloaded DBI an DBD)
>
>
>
>
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Open Database with Pgaccess
@ 1999-02-28 16:07 fabien.vallon <fabien.vallon@wanadoo.fr>
0 siblings, 0 replies; 3+ messages in thread
From: fabien.vallon @ 1999-02-28 16:07 UTC (permalink / raw)
To: pgsql-interfaces
I know, it's a basic question (sory) but i didn't find doc.
I'm working with Postgres6.3.2 and pgacess0.9 (with Linux Redhat 5.2 or
Debian 2.0)
I've done :
* on root account
* su postgres
* createuser Dizzy (this user already exists (users-group))
* that's was Ok
* on Dizzy account
*createdb KADOCKDB
*psql KADOCKDB
*create table client (nom_client char(20) not null primary
key);
And all seems OK
But with Pgaccess, I can't open database
Host localhost
Port 5432 (???)
Database KADOCKDB
Username Dizzy
Password (Dizzy-Password)
Error connecting database
Is postmaster running (Yes )
and accepting TCP.IP connection at 'localhost' on port '5432' (I don't
know)
Thanks for you answer
( Where can i find documentation and script about
Apache->CGI(Perl)->Postgres ?)
(I've downloaded DBI an DBD)
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-02-28 16:07 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-28 15:57 Open database with Pgaccess fabien.vallon <fabien.vallon@wanadoo.fr>
1999-02-28 16:00 ` Leo Cyr <lcyr@itnetsys.com>
1999-02-28 16:07 Open Database with Pgaccess fabien.vallon <fabien.vallon@wanadoo.fr>
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