Re: Re: Issue with postgres login

It appears the permissions with your data directory have changed. According
to the error message, you should set the appropriate permissions for
/var/lib/pgsql/9.3/data

-B

On Thu, Nov 23, 2017 at 23:04 Daulat Ram <Daulat(dot)Ram(at)cyient(dot)com> wrote:

> Hi team,
>
>
>
> But it was working fine earlier.
>
>
>
> Another message I have seen after starting by
>
> -bash-4.2$ /usr/pgsql-9.3/bin/pg_ctl -D /var/lib/pgsql/9.3/data/ -l
> logfile start
>
> < 2017-11-24 04:00:40.780 UTC >FATAL: data directory
> "/var/lib/pgsql/9.3/data" has group or world access
>
> < 2017-11-24 04:00:40.780 UTC >DETAIL: Permissions should be u=rwx (0700).
>
>
>
> For more details please refer to trail mail
>
> Regards,
>
> Daulat
>
> *From:* Bob Strecansky [mailto:bob(at)mailchimp(dot)com]
> *Sent:* 24 November, 2017 9:07 AM
> *To:* Daulat Ram <Daulat(dot)Ram(at)cyient(dot)com>
> *Cc:* pgsql-performance(at)postgresql(dot)org
> *Subject:* [EXTERNAL]Re: Issue with postgres login
>
>
>
> It seems you may have just the postgresql package installed and not the
> postgresql-server package. This Linode guide may be helpful:
>
>
> https://www.linode.com/docs/databases/postgresql/how-to-install-postgresql-relational-databases-on-centos-7
>
> -B
>
> On Thu, Nov 23, 2017 at 22:28 Daulat Ram <Daulat(dot)Ram(at)cyient(dot)com> wrote:
>
> Hi team,
>
>
>
> We are facing the below issue while logging with postgres as given below:
>
>
>
> [centos(at)ip-192-90-2-208 ~]$ su - postgres
>
> Password:
>
> *Last login: Thu Nov 23 16:15:45 UTC 2017 on pts/1*
>
> *-bash-4.2$ psql*
>
> *psql: could not connect to server: No such file or directory*
>
> * Is the server running locally and accepting*
>
> * connections on Unix domain socket "/tmp/.s.PGSQL.5432"?*
>
> -bash-4.2$
>
>
>
>
>
> *OS: Centos*
>
> *AWS environment*
>
>
>
> Regards,
>
> Daulat
>
>
> ------------------------------
>
>
> DISCLAIMER:
>
> This email message is for the sole use of the intended recipient(s) and
> may contain confidential and privileged information. Any unauthorized
> review, use, disclosure or distribution is prohibited. If you are not the
> intended recipient, please contact the sender by reply email and destroy
> all copies of the original message. Check all attachments for viruses
> before opening them. All views or opinions presented in this e-mail are
> those of the author and may not reflect the opinion of Cyient or those of
> our affiliates.
>
> --
>
> Thanks,
>
> -B
>
--
Thanks,

-B