<!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 ) file only, from the PgAccess
web site.
<br><u>My question is, in which directory do you put the ( formdemo.sql
) database file in.</u>
<br>So when you type
<br># su - roland
<br>$ createdb formdemo
<br>$ psql formdemo <formdemo.sql
<br>I get
<br>bash: formdemo.sql: No such file or directory
<br>~~~~~~~~~
<br>I do get when I type
<br>$ psql formdemo
<br>Welcome etc.
<br>formdemo=> \d
<br>Then I get a table
<br>~~~~~~
<br>The formdemo.sql does not show up in PgAccess
<br>I have other databases, tables and forms working in PgAccess?
<br>Thanks, Roland
<p><u>Constantin Teodorescu wrote:</u>
<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
<p><u>Roland N Verrier wrote:</u>
<p>Question for the Masters
<br>This maybe a simple question, but how do you activate the sample demo,
formdemo.sql in PgAccess.
<p>~~~~~~
<br>I have install on my Linux machine,
<br>Red Hat 6.0
<br>PostgreSQL v 6.4.2-6
<br>PgAccess v 0.98, nice improvement
<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 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 create a new database,
<br>opened in PgAccess?
<br>~~~~~~
<br>Thanks, for Being Creators and Helpers ************</html>