On 19 July 2017 at 20:12, vstuart <mail@victoriasjourney.com> wrote:
> Hi David: I see what you are saying; sorry for the confusion. This is how
> postgres operates on my system:
>
> [victoria@victoria ~]$ echo $HOME
> /home/victoria
>
> [victoria@victoria ~]$ which postgres
> /usr/bin/postgres
>
> [victoria@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@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