Search Postgresql Archives

Re: n00b question: createdb seeming to fail quietly on new ubuntu 9.1 installation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Apr 19, 2010 at 5:14 PM, Wells Oliver <wells@xxxxxxxxxxx> 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:

smarlowe@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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux