Re: ~/.psqlrc file is ignored

On 19 July 2017 at 20:12, vstuart <mail(at)victoriasjourney(dot)com> wrote:
> Hi David: I see what you are saying; sorry for the confusion. This is how
> postgres operates on my system:
>
> [victoria(at)victoria ~]$ echo $HOME
> /home/victoria
>
> [victoria(at)victoria ~]$ which postgres
> /usr/bin/postgres
>
> [victoria(at)victoria ~]$ postgres
> postgres does not know where to find the server configuration file.
> You must specify the --config-file or -D invocation option or set the
> PGDATA environment variable.
>
> [victoria(at)victoria ~]$ psql
> psql: FATAL: database "victoria" does not exist

By default, psql will attempt to connect to a database named after the
operating system user you are connected as. It will also use that as
the database user name. As you don't have a database of the same name
as your user account, you will need to specify it:

psql -d <databasename> -U <username>

Thom