Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] unable to find data folder postgres9.4 - Mailing list pgsql-admin

From John Scalia
Subject Re: [ADMIN] unable to find data folder postgres9.4
Date
Msg-id CABzCKRCdLCx6Ct_0UtZsAuxGuXskWVWiH6bhuBuhqQz2wdk6xQ@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] unable to find data folder postgres9.4  (srilinux <srilinux09@gmail.com>)
List pgsql-admin
Tree view
Hmmm... Some linux systems do not put the $PGDATA directory where we all expect it, Ubuntu comes to mind for that. That said, however, if you ran your "find" as root, and could discover any of the normal subdirectories under the $PGDATA directory. Then I'm at a loss to try to tell you where the database might be. This is just awfully weird. One thought that does come to mind maybe you're missing some NFS or other normally mounted filesystems on this system, but without those subdirectories, PostgreSQL will not run.

On Wed, Mar 22, 2017 at 12:15 PM, srilinux <srilinux09@gmail.com> wrote:
Being root user
[root@testserver ~]# ls -al /var/lib/psql/
ls: cannot access /var/lib/psql/: No such file or directory
[root@testserver ~]# ls -al /var/lib/psql/9.4/
ls: cannot access /var/lib/psql/9.4/: No such file or directory
[root@testserver ~]# ls -al /var/lib/psql/9.4/data
ls: cannot access /var/lib/psql/9.4/data: No such file or directory
[root@testserver ~]# sudo su - postgres




===============
Being postgress user - output
-bash-4.2$ id
uid=26(postgres)
-bash-4.2$ ls -al /var/lib/psql/
ls: cannot access /var/lib/psql/: No such file or directory
-bash-4.2$ ls -al /var/lib/psql/9.4/
ls: cannot access /var/lib/psql/9.4/: No such file or directory
-bash-4.2$ ls -al /var/lib/psql/9.4/data
ls: cannot access /var/lib/psql/9.4/data: No such file or directory
-bash-4.2$




--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951282.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: srilinux
Date:
Subject: Re: [ADMIN] unable to find data folder postgres9.4
Next
From: Scott Whitney
Date:
Subject: Re: [ADMIN] unable to find data folder postgres9.4