Linux Format Gambas Easy Database Access!
От | John Hedge |
---|---|
Тема | Linux Format Gambas Easy Database Access! |
Дата | |
Msg-id | 1132791759.14100.9.camel@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: Linux Format Gambas Easy Database Access!
|
Список | 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@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@zaphod2:~$ /usr/lib/postgresql/bin/postmaster -D /usr/local/pgsql/data/ >~/logfile 2>&1 & [1] 14081 postgres@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@zaphod2:~$ /usr/lib/postgresql/bin/psql customers < data.sql bash: data.sql: No such file or directory
В списке pgsql-novice по дате отправления: