Re: psql: FATAL: the database system is starting up
| От | Tom K |
|---|---|
| Тема | Re: psql: FATAL: the database system is starting up |
| Дата | |
| Msg-id | CAE3EmBD5MhBdhq1X+E-Rt7Nf5gbEqZ7prZ=jXzj8F3sbsq=92A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: psql: FATAL: the database system is starting up (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Список | pgsql-general |
On Sat, Jun 1, 2019 at 6:39 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 6/1/19 3:14 PM, Tom K wrote:
>
> ** Correction. There is postgres, template1 and template2 but none of
> the other databases we had.
Just noticed, is that really template2 or is it actually template0?
Apologies. You're right, that was a typo:
-bash-4.2$ psql -h psql03 -U postgres
Password for user postgres:
psql (10.8)
Type "help" for help.
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
(3 rows)
postgres=#
Password for user postgres:
psql (10.8)
Type "help" for help.
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
(3 rows)
postgres=#
--
Adrian Klaver
adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: