Re: lug_: Fw: PostgreSQL problems

Paul Bagyenda Tue, 02 Sep 2003 05:47:33 +0000

You probably want to run pgaccess first as user postgres not as root. It seems that pgaccess is failing to connect to the database. Permissions problems.

On Monday, Sep 1, 2003, at 04:27 Africa/Kampala, Lule George William wrote:

Hello All,
Someone sent me this appeal, but I was also unable to find a solution
to it (I tried google'ing first). For one reason or another, Postgre
works only on the Cmd Line but not on the GUI. Could someone please
bail us out?

------------- Forwarded message follows -------------

Good Morning to you,
We are working with Prof.Victor van Reijswoud on trying to install
postgreSQL
on Knoppix linux V3.2. We have met a number of set backs while trying
to run
pgaccess. Please bail us out because we are completely running out of
time.
Below we got the command line after installing postgreSQL-
7.3.4 but
on installing pgaccess, the GUI appears but fails to create a database
giving us
an error. The asterisks(*********) show the beginning of the
respective
commands with their output at the end.

//This is what we obtain when we install postgreSQL and eventually
gives us
the command line//********************************************

[EMAIL PROTECTED]:/usr/local/pgsql/postgresql-7.3.4# ln -s

/usr/lib/libpgtcl.so.2.3
/usr/lib/libpgtcl.so
ln: `/usr/lib/libpgtcl.so': File exists
[EMAIL PROTECTED]:/usr/local/pgsql/postgresql-7.3.4# chown postgres
/usr/local/pgsql/data
[EMAIL PROTECTED]:/usr/local/pgsql/postgresql-7.3.4# su - postgres
[EMAIL PROTECTED]:~$ /usr/local/pgsql/bin/initdb -

D /usr/local/pgsql/data

The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.
The database cluster will be initialized with locale C.

Fixing permissions on existing directory /usr/local/pgsql/data...

ok

creating directory /usr/local/pgsql/data/base... ok
creating directory /usr/local/pgsql/data/global... ok
creating directory /usr/local/pgsql/data/pg_xlog... ok
creating directory /usr/local/pgsql/data/pg_clog... ok
creating template1 database in /usr/local/pgsql/data/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
vacuuming database template1... ok
copying template1 to template0... ok

Success. You can now start the database server using:

    /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
or
    /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l

logfile

start

[EMAIL PROTECTED]:~$ /usr/local/pgsql/bin/pg_ctl -

D /usr/local/pgsql/data

-l logfile
start
postmaster successfully started
[EMAIL PROTECTED]:~$ /usr/local/pgsql/bin/createdb test
CREATE DATABASE
[EMAIL PROTECTED]:~$ /usr/local/pgsql/bin/psql test
Welcome to psql 7.3.4, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

test=#

//This is what we obtain when we install pgaccess and try to create a
database//****************************************************

[EMAIL PROTECTED]:~# cd /usr/local/
[EMAIL PROTECTED]:/usr/local# ls
bin  include  lib  man  pgaccess  pgsql  sbin  share  src  tcl
[EMAIL PROTECTED]:/usr/local# cd pgaccess
[EMAIL PROTECTED]:/usr/local/pgaccess# ls
pgaccess-0.98.8.20030520  pgaccess-0.98.8.20030520.tar
[EMAIL PROTECTED]:/usr/local/pgaccess# cd pgaccess-0.98.8.20030520
[EMAIL PROTECTED]:/usr/local/pgaccess/pgaccess-0.98.8.20030520# ls
Makefile  changelog  demo  extra   known_bugs  osx

pgmonitor

 win32
README    copyright  doc   images  lib         pgaccess.tcl  todo
[EMAIL PROTECTED]:/usr/local/pgaccess/pgaccess-

0.98.8.20030520# ./pgaccess.tcl

Parsing the command line parameters:
        Couldn't find cmdline package elsewhere on your machine.
        Now trying to load the cmdline package from PgAccess.
        But first I need to load some default values to find it...

Setting the default values:
        PgAcVar(currentdb,host):
        PgAcVar(query,links):
        CurrentDB:
        PgAcVar(query,tables):
        PgAcVar(mwcount): 0
        PgAcVar(PGACCESS_CONNLOAD): 0
        PgAcVar(PGACCESS_NOAUTO): 0
        PgAcVar(currentdb,pgport): 5432
        PgAcVar(PGACCESS_LOGIN): 0
        PgAcVar(opendb,host): localhost
        PgAcVar(opendb,dbname):
        PgAcVar(tablist): Tables Queries Views Sequences Functions
Reports
Graphs Forms Scripts Images Usergroups Diagrams
        PgAcVar(activetab):
        PgAcVar(opendb,username):
        PgAcVar(query,results):
        PgAcVar(PGACCESS_HIDDEN): 0
        PgAcVar(opendb,password):
        PgAcVar(opendb,pgport): 5432
        PgAcVar(PGACCESS_SMLOGIN): 0
        PgAcVar(PGACCESS_NOSCRIPT): 0
        PGACCESS_HOME: /usr/local/pgaccess/pgaccess-

0.98.8.20030520/.

PGLIB: /usr/lib
        cmdline: 1.1.1
        Got cmdline package supplied by PgAccess !
Loading the enviroment variables:

Loading the /root/.pgaccess/pgaccess.cfg config file:

Setting the default values:

Loading namespaces: mainlib stack syntax database debug tables

queries

visualqb forms views functions reports scripts usergroups

sequences

diagrams
help preferences printer importexport connections graphs pgackages
images
Loading plugins: pgin-(NOT LOADED) pgmonitor
Loading the required packages:
        tablelist: 2.7
        BWidget: 1.4.1
        icons: 1.0
        base64: 2.2
        csv: 0.3
        fileutil: 1.4
        tkwizard: 1.0
Tcl error executing pg_exec create database trial

is not a valid postgresql connection

Look forward to hearing from you soon and thanks in advance.

Muramira Paul
Uganda Martyrs University
P.O.Box 5498, Kampala Uganda E.A.


Muramira Paul
Uganda Martyrs University
P.O.Box 5498, Kampala Uganda E.A.

*********************************************************************** * Lule George William (Mr) Network and Systems Administrator Uganda Martyrs University, Nkozi P.O. Box 5498 Kampala Uganda


---------------------------------------------
This service is hosted on the Infocom network
http://www.infocom.co.ug


---------------------------------------------
This service is hosted on the Infocom network
http://www.infocom.co.ug

Re: lug_: Fw: PostgreSQL problems

Reply via email to