On Fri, Jul 27, 2007 at 11:28:58AM -0300, Paolo Victor wrote: > Hello, > > For a short description, I'll just show the sequence of commands I'm trying > to execute: > > paolo@box> initdb -D /usr/local/pgsql/data/ This looks like a mistake. Unless you plan to develop the PostgreSQL code itself, you should not be installing from source. Instead, you should be using one from the packaging system your operating system uses. > paolo@box> postgres -D /usr/local/pgsql/data -i -p 5435 > paolo@box> createdb foo -p 5435 > createdb: could not connect to database foo: FATAL: database "foo" does not > exist > > And > > "postgres -D /usr/local/pgsql/data -i -p 5435"'s output: > > /* > LOG: database system was shut down at 2007-07-27 11:25:27 BRT > LOG: checkpoint record is at 0/42C4B4 > LOG: redo record is at 0/42C4B4; undo record is at 0/0; shutdown TRUE > LOG: next transaction ID: 0/593; next OID: 10820 > LOG: next MultiXactId: 1; next MultiXactOffset: 0 > LOG: database system is ready > FATAL: database "foo" does not exist > */ > Now, am I doing something terribly wrong/noobish, or Postgres is freaking > out because I want to create a database that does not exist? It's freaking out because you are not the postgres user it expects when trying to connect with createdb. It expects you to be the postgres user, not the foo user. Your best move would be to wipe this and reinstall using your OS's packages. Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! Consider donating to PostgreSQL: http://www.postgresql.org/about/donate ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
