Обсуждение: [ADMIN] unable to find data folder postgres9.4
unable to find data folder postgres9.4 application is running normal any tricks to figure out ? Thank you -- View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Hi Srilinux,
On my system, the data folder appears on the command line. You could query it using ps :# ps -o cmd= -C postgres
/usr/local/postgresql-8.4.7/
postgres: writer process
postgres: wal writer process
/usr/local/postgresql-8.4.7/
postgres: writer process
postgres: wal writer process
postgres: autovacuum launcher process
postgres: stats collector process
Regards
-------------------------
Santiago DIEZ
Quark Systems & CAOBA
23 rue du Buisson Saint-Louis, 75010 Paris
-------------------------
Santiago DIEZ
Quark Systems & CAOBA
23 rue du Buisson Saint-Louis, 75010 Paris
-------------------------
On Tue, Mar 21, 2017 at 11:03 PM, srilinux <srilinux09@gmail.com> wrote:
unable to find data folder postgres9.4
application is running normal
any tricks to figure out ? Thank you
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder -postgres9-4-tp5951044.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
Thank you for the reply I did all kinds of troubleshooting to find the answer cd /var/lib/pgsql/9.4/data -bash: cd: /var/lib/pgsql/9.4/data: No such file or directory this is the issue the path refereed is empty any suggestions ? I tried find to locate the pg_log and conffiles nothing returned except config sameples -- View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951232.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Try:
lsof | grep postgres | grep base
(assuming your user is "postgres")
From: pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org> on behalf of srilinux <srilinux09@gmail.com>
Sent: Wednesday, March 22, 2017 9:35 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] unable to find data folder postgres9.4
Sent: Wednesday, March 22, 2017 9:35 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] unable to find data folder postgres9.4
Thank you for the reply
I did all kinds of troubleshooting to find the answer
cd /var/lib/pgsql/9.4/data
-bash: cd: /var/lib/pgsql/9.4/data: No such file or directory
this is the issue
the path refereed is empty
any suggestions ?
I tried find to locate the pg_log and conffiles nothing returned except
config sameples
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951232.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
I did all kinds of troubleshooting to find the answer
cd /var/lib/pgsql/9.4/data
-bash: cd: /var/lib/pgsql/9.4/data: No such file or directory
this is the issue
the path refereed is empty
any suggestions ?
I tried find to locate the pg_log and conffiles nothing returned except
config sameples
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951232.html
www.postgresql-archive.org unable to find data folder postgres9.4. unable to find data folder postgres9.4 application is running normal any tricks to figure out ? Thank you |
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
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/
Scott Whitney <scott@journyx.com> writes:
> Try:
> lsof | grep postgres | grep base
... or just connect to the server and do "show data_directory".
regards, tom lane
Well, you could try "find" as root and look for some of the standard subdirectories for PostgreSQL, subdirs like pg_xlog, pg_clog, pg_logical, pg_stat, and so forth. Just remember that these are mode 700 for the postgres user, so a normal user find will not work, you must use postgres or root.
On Wed, Mar 22, 2017 at 10:35 AM, srilinux <srilinux09@gmail.com> wrote:
Thank you for the reply
I did all kinds of troubleshooting to find the answer
cd /var/lib/pgsql/9.4/data
-bash: cd: /var/lib/pgsql/9.4/data: No such file or directory
this is the issue
the path refereed is empty
any suggestions ?
I tried find to locate the pg_log and conffiles nothing returned except
config sameples
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data- folder-postgres9-4- tp5951044p5951232.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
Thank you Scott lsof | grep postgres | grep base postgres 58495 postgres 5u REG 253,3 8192 600190 /var/lib/pgsql/9.4/data/base/16385/12858 postgres 58495 postgres 7u REG 253,3 679936 623872 /var/lib/pgsql/9.4/data/base/16385/16462 postgres 58495 postgres 8u REG 253,3 40960 624612 /var/lib/pgsql/9.4/data/base/16385/16668 cd /var/lib/pgsql/9.4/data/base/ -bash: cd: /var/lib/pgsql/9.4/data/base/: No such file or director any suggestions ? -- View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951275.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Thank you Tom Below is the output postgres 58495 postgres 5u REG 253,3 8192 600190 /var/lib/pgsql/9.4/data/base/16385/12858 postgres 58495 postgres 7u REG 253,3 679936 623872 /var/lib/pgsql/9.4/data/base/16385/16462 postgres 58495 postgres 8u REG 253,3 40960 624612 /var/lib/pgsql/9.4/data/base/16385/16668 cd /var/lib/pgsql/9.4/data/base/ -bash: cd: /var/lib/pgsql/9.4/data/base/: No such file or director Any suggestions ? -- View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951276.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Thank you Jay I tried locate , show and find being root user nothing returns show data_directory xxxxxxxx-# [root@testserver~]# find / -type d -name "pg_clog" -ls [root@testserver~]# find / -type d -name "pg_clog" [root@testserver~]# find / -type d -name "pg_stat" [root@testserver~]# -- View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951277.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Are you running your "cd" as the user "postgres" or the "root" user?
Provide the output of:
"ls -al /var/lib/psql/"
"ls -al /var/lib/psql/9.4/"
"ls -al /var/lib/psql/9.4/data"
From: pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org> on behalf of srilinux <srilinux09@gmail.com>
Sent: Wednesday, March 22, 2017 11:06 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] unable to find data folder postgres9.4
Sent: Wednesday, March 22, 2017 11:06 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] unable to find data folder postgres9.4
Thank you Scott
lsof | grep postgres | grep base
postgres 58495 postgres 5u REG 253,3
8192 600190 /var/lib/pgsql/9.4/data/base/16385/12858
postgres 58495 postgres 7u REG 253,3
679936 623872 /var/lib/pgsql/9.4/data/base/16385/16462
postgres 58495 postgres 8u REG 253,3
40960 624612 /var/lib/pgsql/9.4/data/base/16385/16668
cd /var/lib/pgsql/9.4/data/base/
-bash: cd: /var/lib/pgsql/9.4/data/base/: No such file or director
any suggestions ?
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951275.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
lsof | grep postgres | grep base
postgres 58495 postgres 5u REG 253,3
8192 600190 /var/lib/pgsql/9.4/data/base/16385/12858
postgres 58495 postgres 7u REG 253,3
679936 623872 /var/lib/pgsql/9.4/data/base/16385/16462
postgres 58495 postgres 8u REG 253,3
40960 624612 /var/lib/pgsql/9.4/data/base/16385/16668
cd /var/lib/pgsql/9.4/data/base/
-bash: cd: /var/lib/pgsql/9.4/data/base/: No such file or director
any suggestions ?
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951275.html
www.postgresql-archive.org unable to find data folder postgres9.4. unable to find data folder postgres9.4 application is running normal any tricks to figure out ? Thank you |
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
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/
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.
All your mount points are ok?
On Wed, 22 Mar 2017 at 13:16 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
Thank you Yuri Yes all mount points were fine , I compared to other servers -- View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951285.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
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
Ha. Alright. Let's back up.
ls -al /var
ls -al /var/lib
From: pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org> on behalf of srilinux <srilinux09@gmail.com>
Sent: Wednesday, March 22, 2017 11:15 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] unable to find data folder postgres9.4
Sent: Wednesday, March 22, 2017 11:15 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] unable to find data folder postgres9.4
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
[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
www.postgresql-archive.org unable to find data folder postgres9.4. unable to find data folder postgres9.4 application is running normal any tricks to figure out ? Thank you |
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
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/
/proc/mounts /vol/nuspvg-lvol_01 /var/lib/pgsql xfs rw,seclabel,relatime,attr2,inode64,noquota 0 0 df -a /vol/nuspvg-lvol_01 104806400 1451336 103355064 2% /var/lib/pgsql -- View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951293.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Well, that doesn't look odd at all. If you do an 'ls -al' in that /var/lib/pgsql directory, what do you see? A subdirectory beginning with a number as 9.4, 9.2, or something else, like maybe 'data'? And are absolutely certain that this volume is mounted? I know /proc/mounts says it is, but if nothing is under that directory, then either the volume disappeared or someone deleted it.
On Wed, Mar 22, 2017 at 12:26 PM, srilinux <srilinux09@gmail.com> wrote:
/proc/mounts
/vol/nuspvg-lvol_01 /var/lib/pgsql xfs
rw,seclabel,relatime,attr2,inode64,noquota 0 0
df -a
/vol/nuspvg-lvol_01 104806400 1451336 103355064 2% /var/lib/pgsql
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data- folder-postgres9-4- tp5951044p5951293.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
ls -al /var/lib/pgsql/9.4/ ls: cannot access /var/lib/pgsql/9.4/: No such file or directory ? any suggestions -- View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951322.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
ls -al /var/lib/pgsql/ ls: cannot access /var/lib/pgsql/: No such file or directory -- View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951323.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
ls -la /var/lib/
On Wed, 22 Mar 2017 at 14:37 srilinux <srilinux09@gmail.com> wrote:
ls -al /var/lib/pgsql/
ls: cannot access /var/lib/pgsql/: No such file or directory
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951323.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
No, not that's not what I meant. Run your 'ls' in /var/lib/pgsql, not the 9.4 subdirectory. Of course, I'm expecting that nothing will be returned based on your last comment, and again, then, are absolutely certain that the mount point has been mounted properly. Maybe you should umount it and try mounting it again, but maybe that filesystem is corrupted.
On Wed, Mar 22, 2017 at 1:36 PM, srilinux <srilinux09@gmail.com> wrote:
ls -al /var/lib/pgsql/
ls: cannot access /var/lib/pgsql/: No such file or directory
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data- folder-postgres9-4- tp5951044p5951323.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
Hi ls -la /var/lib total 24 drwxr-xr-x. 41 root root 4096 Mar 20 13:44 . drwxr-xr-x. 23 root root 4096 Mar 20 13:44 .. drwxr-xr-x. 2 root root 4096 Mar 20 12:25 alternatives drwx------. 3 root root 17 Sep 1 2016 authconfig drwxr-xr-x. 2 chrony chrony 18 Mar 22 11:51 chrony drwxr-xr-x. 2 root root 6 Sep 12 2016 dbus drwxr-xr-x. 2 root root 6 Mar 20 13:44 dhclient drwxr-xr-x. 2 root root 6 Sep 13 2016 dnsmasq drwxr-xr-x. 2 root root 6 May 12 2014 fprint drwxr-xr-x. 2 root root 6 Mar 10 2016 games drwxr-xr-x. 4 root root 52 Mar 20 13:45 gssproxy drwxr-xr-x. 2 root root 27 Aug 26 2015 inital-setup drwxr-xr-x. 2 root root 6 Oct 5 10:45 initramfs drwxr-xr-x. 8 root root 84 Aug 18 2016 iscsi drwxr-xr-x. 3 root root 39 Dec 23 00:48 kpatch drwxr-xr-x. 2 root root 6 Jul 6 2016 lldpad drwxr-xr-x. 2 root root 29 Mar 22 03:44 logrotate -rw-r--r--. 1 root root 763 Nov 12 03:35 logrotate.status.rpmsave drwx------. 2 root root 6 Jan 16 2016 machines drwxr-xr-x. 2 root root 36 Mar 10 2016 misc drwxr-x---. 2 root slocate 23 Mar 22 03:44 mlocate drwxr-xr-x. 4 root root 60 Mar 20 13:45 net-snmp drwx------. 2 root root 83 Mar 20 13:45 NetworkManager drwxr-xr-x. 5 root root 4096 Mar 18 06:03 nfs drwxr-xr-x. 2 root root 6 Sep 15 2016 os-prober drwxr-xr-x. 6 root root 52 Aug 26 2016 pcp drwxr-xr-x. 4 postgres postgres 73 Mar 21 10:10 pgsql drwxr-xr-x. 2 root root 26 Jul 1 2016 plymouth drwxr-x---. 3 root polkitd 27 Aug 26 2015 polkit-1 drwx------. 2 postfix root 24 Aug 26 2015 postfix drwxr-xr-x. 2 root root 49 Nov 12 08:21 redhat_access_insights drwxr-x---. 5 root root 64 Sep 13 2016 rhsm drwx------. 2 rpc rpc 6 Aug 2 2016 rpcbind drwxr-xr-x. 2 root root 4096 Mar 20 19:05 rpm drwxr-xr-x. 2 root root 6 Mar 10 2016 rpm-state drwx------. 2 root root 84 Mar 22 12:45 rsyslog drwxr-xr-x. 3 root root 20 Nov 15 05:23 samba drwxr-xr-x. 4 root root 33 Sep 12 2016 stateless drwxr-xr-x. 4 root root 53 Nov 29 08:55 systemd drwx------. 2 tss tss 6 May 24 2015 tpm drwxr-xr-x. 2 root root 24 Jul 25 2016 up2date drwxr-xr-x. 6 root root 75 Mar 18 06:04 yum -- View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951333.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
ls -al /var/lib/pgsql/ ls: cannot access /var/lib/pgsql/: No such file or directory cd /var/lib/pgsql ls -al total 12 drwxr-xr-x. 4 postgres postgres 73 Mar 21 10:10 . drwxr-xr-x. 41 root root 4096 Mar 20 13:44 .. -rw-------. 1 postgres postgres 621 Mar 22 12:48 .bash_history drwxr-xr-x. 3 postgres postgres 17 Mar 21 09:21 .cache drwxr-xr-x. 3 postgres postgres 17 Mar 21 09:21 .config -rw-------. 1 postgres postgres 282 Mar 22 10:14 .psql_history Do you think postgress is installed in some other directory ? -- View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951335.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
I distinctly see the pgsql subdirectory in your listing. Usually that is given a mode 700, although that isn't actually necessary if the actual data is in the subdirectory under that. So, you're saying then that you cannot 'cd' into this pgsql subdirectory? And that is a mounted filesystem?
On Wed, Mar 22, 2017 at 1:50 PM, srilinux <srilinux09@gmail.com> wrote:
Hi
ls -la /var/lib
total 24
drwxr-xr-x. 41 root root 4096 Mar 20 13:44 .
drwxr-xr-x. 23 root root 4096 Mar 20 13:44 ..
drwxr-xr-x. 2 root root 4096 Mar 20 12:25 alternatives
drwx------. 3 root root 17 Sep 1 2016 authconfig
drwxr-xr-x. 2 chrony chrony 18 Mar 22 11:51 chrony
drwxr-xr-x. 2 root root 6 Sep 12 2016 dbus
drwxr-xr-x. 2 root root 6 Mar 20 13:44 dhclient
drwxr-xr-x. 2 root root 6 Sep 13 2016 dnsmasq
drwxr-xr-x. 2 root root 6 May 12 2014 fprint
drwxr-xr-x. 2 root root 6 Mar 10 2016 games
drwxr-xr-x. 4 root root 52 Mar 20 13:45 gssproxy
drwxr-xr-x. 2 root root 27 Aug 26 2015 inital-setup
drwxr-xr-x. 2 root root 6 Oct 5 10:45 initramfs
drwxr-xr-x. 8 root root 84 Aug 18 2016 iscsi
drwxr-xr-x. 3 root root 39 Dec 23 00:48 kpatch
drwxr-xr-x. 2 root root 6 Jul 6 2016 lldpad
drwxr-xr-x. 2 root root 29 Mar 22 03:44 logrotate
-rw-r--r--. 1 root root 763 Nov 12 03:35 logrotate.status.rpmsave
drwx------. 2 root root 6 Jan 16 2016 machines
drwxr-xr-x. 2 root root 36 Mar 10 2016 misc
drwxr-x---. 2 root slocate 23 Mar 22 03:44 mlocate
drwxr-xr-x. 4 root root 60 Mar 20 13:45 net-snmp
drwx------. 2 root root 83 Mar 20 13:45 NetworkManager
drwxr-xr-x. 5 root root 4096 Mar 18 06:03 nfs
drwxr-xr-x. 2 root root 6 Sep 15 2016 os-prober
drwxr-xr-x. 6 root root 52 Aug 26 2016 pcp
drwxr-xr-x. 4 postgres postgres 73 Mar 21 10:10 pgsql
drwxr-xr-x. 2 root root 26 Jul 1 2016 plymouth
drwxr-x---. 3 root polkitd 27 Aug 26 2015 polkit-1
drwx------. 2 postfix root 24 Aug 26 2015 postfix
drwxr-xr-x. 2 root root 49 Nov 12 08:21 redhat_access_insights
drwxr-x---. 5 root root 64 Sep 13 2016 rhsm
drwx------. 2 rpc rpc 6 Aug 2 2016 rpcbind
drwxr-xr-x. 2 root root 4096 Mar 20 19:05 rpm
drwxr-xr-x. 2 root root 6 Mar 10 2016 rpm-state
drwx------. 2 root root 84 Mar 22 12:45 rsyslog
drwxr-xr-x. 3 root root 20 Nov 15 05:23 samba
drwxr-xr-x. 4 root root 33 Sep 12 2016 stateless
drwxr-xr-x. 4 root root 53 Nov 29 08:55 systemd
drwx------. 2 tss tss 6 May 24 2015 tpm
drwxr-xr-x. 2 root root 24 Jul 25 2016 up2date
drwxr-xr-x. 6 root root 75 Mar 18 06:04 yum
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data- folder-postgres9-4- tp5951044p5951333.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
what will happen if I move /var/lib/pgsql to /var/lib/pgsqlBackup ? will it cause any problems as this is mounted ? -- View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951347.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Nothing really, although you'll break anyone logging in as postgres or su'ing to that. And being a mount point, you just can't 'mv' it. What are you trying to do? See if remounting the drive will fix things? If that's the case, I'd copy the contents not move them, then delete everything under /var/lib/pgsql, but I wouldn't do an 'rm -fr' just a normal 'rm'.
On Wed, Mar 22, 2017 at 2:28 PM, srilinux <srilinux09@gmail.com> wrote:
what will happen if I move /var/lib/pgsql to /var/lib/pgsqlBackup ?
will it cause any problems as this is mounted ?
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data- folder-postgres9-4- tp5951044p5951347.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
You can absolutely move it. I have found the easiest way is via a symlink. You need to ensure everything is stopped, AND there are no open files.
When I do something that intrinsic, I like to do it in single user mode after rebooting the server.
You can also just point your startup files to the proper date directories. I have 5 production PG servers.
Let's talk about the internal one.
Internal cluster (port 5432)
Replication of my training server (6432)
Replication of my production customers (7432)
I use these for DR, backups and support. EVERYTHING is under /pgdata then /internal /prod and /training. This is done with the startup scripts.
If this is not enough information, let me know, and I can add actual example files.
On Mar 22, 2017 1:29 PM, srilinux <srilinux09@gmail.com> wrote:
what will happen if I move /var/lib/pgsql to /var/lib/pgsqlBackup ?
will it cause any problems as this is mounted ?
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951347.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
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/
Be careful on the copy to preserve permissions.
On Mar 22, 2017 1:41 PM, John Scalia <jayknowsunix@gmail.com> wrote:
Nothing really, although you'll break anyone logging in as postgres or su'ing to that. And being a mount point, you just can't 'mv' it. What are you trying to do? See if remounting the drive will fix things? If that's the case, I'd copy the contents not move them, then delete everything under /var/lib/pgsql, but I wouldn't do an 'rm -fr' just a normal 'rm'.On Wed, Mar 22, 2017 at 2:28 PM, srilinux <srilinux09@gmail.com> wrote:what will happen if I move /var/lib/pgsql to /var/lib/pgsqlBackup ?
will it cause any problems as this is mounted ?
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data- folder-postgres9-4- tp5951044p5951347.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
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/
All Thank you very much for providing your inputs Now after reboot I can see the pgsql data I am trying to bind mount to new storage allocated when I do so it is empty again any suggestions ? echo "/ProdD/NusAp1/pgsql /var/lib/pgsql bind bind 0 0" >> /etc/fstab mount --bind /ProdD/NusAp1/pgsql /var/lib/pgsql cd /ProdD/NusAp1/pgsql is empty and /var/lib/pgsql is also empty -- View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951533.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
If the mount point is empty, then I suspect your mount attempt failed, perhaps silently. Under most mounts I've used, I think you should have seen a lost+found subdirectory under that mount. Have you setup this up in the mountable and tried a reboot to see if it then shows correctly? After your comments yesterday, it's starting to sound like your disk subsystem is having serious problems.
On Thu, Mar 23, 2017 at 10:37 AM, srilinux <srilinux09@gmail.com> wrote:
All Thank you very much for providing your inputs
Now after reboot I can see the pgsql data
I am trying to bind mount to new storage allocated
when I do so it is empty again
any suggestions ?
echo "/ProdD/NusAp1/pgsql /var/lib/pgsql bind bind 0 0" >> /etc/fstab
mount --bind /ProdD/NusAp1/pgsql /var/lib/pgsql
cd /ProdD/NusAp1/pgsql is empty and /var/lib/pgsql is also empty
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data- folder-postgres9-4- tp5951044p5951533.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
Jay could you brief me what to do ? Thanks -- View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951559.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
On most linux systems, the table used by the kernel during startup is /etc/fstab and that contains the complete set of filesystems/volumes that the system will have. You may wish to examine the man page, as in "man fstab" as to the format of the file, but basically you're going to put your postgresql volume into this table if it's not already in there. If it is in there already, carefully check that the settings are correct for what you want or expect. Then, you'd probably want to reboot the system to see what the filesystem looks like on a clean startup. At a minimum, every mounted filesystem contains a directory in it called "lost+found", so if you don't see that, it may not be a proper filesystem, or the mount is broken. Without knowing what you're using for the disks, or the O/S, it's hard for me to guess what you really should have or if it's broken.
On Thu, Mar 23, 2017 at 12:23 PM, srilinux <srilinux09@gmail.com> wrote:
Jay
could you brief me what to do ?
Thanks
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data- folder-postgres9-4- tp5951044p5951559.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
John Scalia wrote: > At a > minimum, every mounted filesystem contains a directory in it called > "lost+found", so if you don't see that, it may not be a proper > filesystem, or the mount is broken. Without knowing what you're using > for the disks, or the O/S, it's hard for me to guess what you really > should have or if it's broken. Bind mounts are closer to "hard link across filesystems". The mounted directory may or may not actually be at the root of the physical filesystem it lives on. So, for instance, if I have /dev/bigdisk mounted to /mnt/bigdisk, I can then bind mount /mnt/bigdisk/kdeugau-media to /home/kdeugau/media, and I will not see a lost+found in /home/kdeugau/media. Personally, the main use case I've found for bind mounts is to fool programs that refuse to follow symlinks into effectively doing so anyway. srilinux wrote: > All Thank you very much for providing your inputs > > Now after reboot I can see the pgsql data > > I am trying to bind mount to new storage allocated > > when I do so it is empty again > > any suggestions ? > > echo "/ProdD/NusAp1/pgsql /var/lib/pgsql bind bind 0 0" >> /etc/fstab > > mount --bind /ProdD/NusAp1/pgsql /var/lib/pgsql > > cd /ProdD/NusAp1/pgsql is empty and /var/lib/pgsql is also empty This reads to me like you've been using whatever filesystem /var/lib/pgsql is on, and now you need to expand, but you've just gone and mounted the new filesystem space over top of /var/lib/pgsql without copying the files into the new space. In this respect, a bind mount acts just like any other filesystem mount, and not a symlink or hard link. You need to copy or move the files from the target (eg, /var/lib/pgsql) into the new location before mounting the new filesystem to the old location. Otherwise you end up with both locations (apparently) empty. Your files are still safe on the old filesystem, but you won't be able to access them. Make sure to stop Postgres before copying the files, and I'd suggest copying instead of moving to make sure things work before arranging to actually delete the originals. -kgd
Thank you will give a try and let you know. -- View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951605.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.