Thara Vadakkeveedu wrote: > I need to create a database and a user and make this new user the owner of > this new database. > > Since I cannot access postgres db from pgadmin client on my desktop, > > > I tried to do the same from the command line on the linux db server: > > su - postgres > -bash-4.1$ psql -d postgres > > postgres=# create user puser password 'xxxxxx' > > postgres=# create database pfdb owner puser > > If I now try to list databases using \l > it lists postgres, template0 and template1 but not the new database I > created... > > How can I create a new database successfully ? It will be easier for me to > try this from the pgadmin client.
... but it is better with psql first because that is simpler. I see that there are no semicolons at the end of your statements. That would mean that the statements don't get executed at all. Is this just a copy/paste error? Could you copy the complete session (what exactly you typed and what response you got)? Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
