On Mon, Apr 19, 2010 at 5:14 PM, Wells Oliver <we...@submute.net> wrote: > Just did an install via apt-get of 8.4 and ... well ... I was able to set > the password for the postgres user, then I log in and type: > > createdb test
Is that from a command line that looks like this: smarl...@steamboat:/$ or this: Welcome to psql 8.3.9, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit smarlowe=# from the first one, createdb will work. From the second it's: create database test; (notice the ; which terminates the line and executes the SQL) ? > It goes quietly, which according to the documentation is a success, but... > > \l doesn't show the database. Nor does > /var/log/postgresql/postgresql-8.4-main.log indicate any issue. Yeah, I'm betting you're in the psql monitor. createdb is a command line command and it won't work from there. The psql monitor is silent until it gets a command, which is terminated with ;. > Secondly, adding a user seems to work, but I can't create the DB for the > user (same issue as above). Any tips? Anything I can look at? This is a > brand spanking new fresh 8.4 installation using the packages included in the > 9.1 ubuntu packages. Got an error message? Also, it's 9.10, not 9.1. The numbers represent the year / month of the release, hence 9.10, not 9.1. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general