Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Sebastian ScaranoDate: 2005-11-24 01:34:50
Subject: Re: Linux DB designer tools
Previous:From: Andrej Ricnik-BayDate: 2005-11-23 20:41:20
Subject: Re: Linux DB designer tools

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group