<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Help
<br>Concerning the the sample formdemo, ( formdemo.sql )
<br>This demo file is in the ( /usr/local/pgaccess/demo/formdemo.sql )
directory, from the upgrade v 0.98.
<br>Or you can download the ( formdemo.sql ) <u>file only</u>, from the
PgAccess web site.
<br>My question is, which directory do you put the ( formdemo.sql ) file.
<br>So when you type
<br>$ createdb formdemo
<br>$ psql formdemo <formdemo.sql
<br>I get no such file or directory
<br>Thanks, Roland
<br>
<br>
<blockquote TYPE=CITE>Roland N Verrier wrote:
<br>>
<br>> Postmaster running, PgAccesss running
<br>> PgAccess v 0.98 is in /usr/local/pgaccess
<br>> Off the Web site it says, Create an empty database and psql your
<br>> database <formdemo.sql
<br>> I have the template1 and other databases in /var/lib/pgsql/base
<br>> How do I make the connection with formdemo.sql and the base dir.,
if I
<br>> create a new database, opened in PgAccess?</blockquote>
<blockquote TYPE=CITE>Constantin Teodorescu wrote:
<p>Let's say you are the Linux user roland on your computer.
<p>There is a postgres user , the master of PostgreSQL database server
as
<br>the system administrator.
<br>Don't know the password for postgres user but you should assign one
as
<br>root and then log in as postgres user.
<br>Then create a PostgreSQL user with the following command:
<p>$ createuser roland
<p>and follow the instructions there. Now you have a PostgreSQL user roland
<br>and you may create databases , other users and so on.
<p>As postgres linux user (or as roland) create and fill the formdemo
<br>database :
<p>$ createdb formdemo
<br>$ psql formdemo <formdemo.sql
<p>Now database formdemo should exist, check it with :
<p>$ psql formdemo
<br>formdemo=> \d
<p>Then run PgAccess as :
<p>$ pgaccess formdemo
<p>or simply run PgAccess without parameter and the from the Database/Open
<br>menu, specify formdemo as your database, localhost to host, 5432 as
<br>port. Username and password may not be supplied if you are connecting
to
<br>localhost.
<p>Enjoy,
<br>--
<br>Constantin Teodorescu
<br>FLEX Consulting Braila, ROMANIA</blockquote>
</html>