Re: Creating a user for pg_start_backup

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Creating a user for pg_start_backup
Date: 2015-07-21 08:46:09
Message-ID: 55AE06D1.80001@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/21/2015 1:31 AM, Andrew Beverley wrote:
> I had to specify a database name when connecting:
>
> psql -U backup -c "select pg_start_backup('Daily backup')" -d postgres

psql defaults to the current user for both the database name and user
name. I probably would have run that psql command as the system
postgres user and not specified any -U or -d ...

--
john r pierce, recycling bits in santa cruz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Beverley 2015-07-21 08:51:11 Re: Creating a user for pg_start_backup
Previous Message Andrew Beverley 2015-07-21 08:31:49 Re: Creating a user for pg_start_backup