From: Constantin Teodorescu <teo@flex.ro>
To: Roland N Verrier <verrier@oneworldsolution2by2.mb.ca>
Cc: PostgreSQL PgAccess <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] PGACCESS formdemo.sql
Date: Sat, 04 Sep 1999 06:16:14 +0000
Message-ID: <37D0B92E.A9A00170@flex.ro> (raw)
References: <37D07D6C.6034BF55@oneworldsolution2by2.mb.ca>
Roland N Verrier wrote:
>
> Postmaster running, PgAccesss running
> PgAccess v 0.98 is in /usr/local/pgaccess
> Off the Web site it says, Create an empty database and psql your
> database <formdemo.sql
> I have the template1 and other databases in /var/lib/pgsql/base
> How do I make the connection with formdemo.sql and the base dir., if I
> create a new database, opened in PgAccess?
Let's say you are the Linux user roland on your computer.
There is a postgres user , the master of PostgreSQL database server as
the system administrator.
Don't know the password for postgres user but you should assign one as
root and then log in as postgres user.
Then create a PostgreSQL user with the following command:
$ createuser roland
and follow the instructions there. Now you have a PostgreSQL user roland
and you may create databases , other users and so on.
As postgres linux user (or as roland) create and fill the formdemo
database :
$ createdb formdemo
$ psql formdemo <formdemo.sql
Now database formdemo should exist, check it with :
$ psql formdemo
formdemo=> \d
Then run PgAccess as :
$ pgaccess formdemo
or simply run PgAccess without parameter and the from the Database/Open
menu, specify formdemo as your database, localhost to host, 5432 as
port. Username and password may not be supplied if you are connecting to
localhost.
Enjoy,
--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: teo@flex.ro, verrier@oneworldsolution2by2.mb.ca
Subject: Re: [INTERFACES] PGACCESS formdemo.sql
In-Reply-To: <37D0B92E.A9A00170@flex.ro>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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