Linux Format Gambas Easy Database Access!

From: John Hedge <john(at)hedge(dot)com(dot)au>
To: pgsql-novice(at)postgresql(dot)org
Subject: Linux Format Gambas Easy Database Access!
Date: 2005-11-24 00:22:39
Message-ID: 1132791759.14100.9.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

As you'll realise I'm new to all things Postgresql (& Gambas).

I'm following Dr Bain's article in LXF71.

Everything has gone ok (now) up until the introduction of "< data.sql"
as per below.

Can someone explain what we're trying to do here, and more importantly
why it's not working and what I've done wrong, please?

TIA

John

postgres(at)zaphod2:~$ /usr/lib/postgresql/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.

initdb: directory "/usr/local/pgsql/data/" exists but is not empty
If you want to create a new database system, either remove or empty
the directory "/usr/local/pgsql/data/" or run initdb with an argument
other than
"/usr/local/pgsql/data/".
postgres(at)zaphod2:~$ /usr/lib/postgresql/bin/postmaster
-D /usr/local/pgsql/data/ >~/logfile 2>&1 &
[1] 14081
postgres(at)zaphod2:~$ /usr/lib/postgresql/bin/createdb customers CREATE
DATABASE
[1]+ Exit 1 /usr/lib/postgresql/bin/postmaster
-D /usr/local/pgsql/data/ >~/logfile 2>&1
postgres(at)zaphod2:~$ /usr/lib/postgresql/bin/psql customers < data.sql
bash: data.sql: No such file or directory

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sebastian Scarano 2005-11-24 01:34:50 Re: Linux DB designer tools
Previous Message Andrej Ricnik-Bay 2005-11-23 20:41:20 Re: Linux DB designer tools