Postgresql

Hey Chris

Not exact;y sure I understand what you mean by ‘nothing there’

For what purpose have you established the pgpass file ? For performing backups ?

In which home directory is the hidden file ?

Did you restrict its rights ? The pgpass file needs a chmod 0600 running (if I remember correctly) in order for postgres to use it…..

If you are just trying to get postgres to work in any which way – did you go in through a temrinal and set a password for the postgres user (in postgres) ?

You may find an article in Mark Philips’ archives a help here……

www.mophilly.com/kb/index.php/Automated_Backup_with_Omnis_Studio <www.mophilly.com/kb/index.php/Automated_Backup_with_Omnis_Studio>

Andy

> On Jun 3, 2017, at 12:23 AM, Chris hughes <ataddata@bigpond.net.au> wrote:
>
> Hi one and I am having trouble establishing Postgres 9.5 on my Centos 7
> server, the installation is ok. Did the status thing etc.
>
>
>
> I am using Pgadmin3 The trouble is when we try and establish .pgpass file it
> is apparently located in the home directory.
>
>
>
> I establish the names etc and save, then go back however nothing there any
> help appreciated.
>
>
>
>
>
> Chris Hughes
>
>
>
> Copious Data Pty Ltd (Trading as Atad Data)
>
> Unit 8 /3460 Pacific Highway
>
> Springwood QLD 4127
>
> Phone No:- 07 3208 6347
>
> Mobile No:- 0409 263 349
>
> Fax No:- 07 3208 9347
>
> Email:- ataddata@bigpond.net.au
>
> Web Site:- ataddata.com.au
>
>
>
>
>
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com