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
