Forum OpenACS Q&A: Problems with postgres installation
Install Guide". So far it has installed perfectly and even runs when
the postmaster is started up. Every time I try to create a database I
get the following error.
FATAL 1: database "mydb" does not exist in the system catalog.
Bring postmaster down, do an initdb, start postmaster again and then try your createdb and it should work.
We will be releasing another version of the docs with these quirks fixed in the upcoming OpenACS 3.2.4 that should be released this or next week.
FATAL 1: Database "postgres" does not exist in the system catalog
(assumming your data will reside in /usr/local/psql/data). Stop postmaster before doing this.
(as user postgres) /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data /usr/local/pgsql/bin/postmaster -S -D /usr/local/pgsql/data createuser youruser su - youruser createdb yourdb psql mydb
Where 'youruser' is the user AOLserver will connect to PG and 'mydb' is the name you're giving to the database.
Sorry about this mistake in the documentation.
is it like that???
export PATH MANPATH
hehe... did i miss something???
But, when i used psql, i cannot 'scroll up/down' my previous command or even pressing TAB key to obtain the tables name or SQL command easily. I've used psql before on other machine and they have this functionality. I donno whether you understand or not my problem here bcoz i'm new in this linux stuff too.
So..anyone can help me to figure out this?....or Did i missed something...AGAIN?? :))