Re: pg_dumpall: could not connect to database "template1": FATAL:

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dumpall: could not connect to database "template1": FATAL:
Date: 2016-11-13 17:27:57
Message-ID: 2cff908b-9480-abd2-d160-e7bfd2658c8b@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/13/2016 9:13 AM, Adrian Klaver wrote:
>
>> For example: How can I restart the SQL server? Oh sorry we can't help
>> you with this … ?
>
> https://www.postgresql.org/docs/9.5/static/app-pg-ctl.html

the best way of doing this depends on the way postgres was installed,
and varies by OS/distribution. for instance, on RHEL/CentOS <= 6,

service postgresql-X.Y restart

on RHEL/CentOS 7

systemctl restart postgresql-X.Y

(both these run by root, or via sudo)

--
john r pierce, recycling bits in santa cruz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2016-11-13 18:40:42 Re: Why is this query not using GIN index?
Previous Message Adrian Klaver 2016-11-13 17:13:05 Re: pg_dumpall: could not connect to database "template1": FATAL: