Re: connecting to the database from pgadmin client

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: connecting to the database from pgadmin client
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B17C242AB@ntex2010a.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: connecting to the database from pgadmin client  (Thara Vadakkeveedu <tharagv@yahoo.com>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "DDT"
Дата:
Сообщение: Re: pd_dump server mismatch error
Следующее
От: Thara Vadakkeveedu
Дата:
Сообщение: Fw: pd_dump server mismatch error