pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedunable to find data folder postgres9.4
34+ messages / 7 participants
[nested] [flat]
* unable to find data folder postgres9.4
@ 2017-03-21 22:03 srilinux <srilinux09@gmail.com>
0 siblings, 1 reply; 34+ messages in thread
From: srilinux @ 2017-03-21 22:03 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 08:08 Santiago DIEZ <santiago.diez@caoba.fr>
parent: srilinux <srilinux09@gmail.com>
0 siblings, 1 reply; 34+ messages in thread
From: Santiago DIEZ @ 2017-03-22 08:08 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; +Cc: pgsql-admin
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/bin/postgres -D /var/lib/postgresql/aGNay
postgres: writer process
postgres: wal writer process
/usr/local/postgresql-8.4.7/bin/postgres -D /var/lib/postgresql/aGNay
postgres: writer process
postgres: wal writer process
postgres: autovacuum launcher process
postgres: stats collector process
In my case, the data folders are /var/lib/postgresql/aGNay and
/var/lib/postgresql/aGNay.
Regards
-------------------------
*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
>
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 14:35 srilinux <srilinux09@gmail.com>
parent: Santiago DIEZ <santiago.diez@caoba.fr>
0 siblings, 2 replies; 34+ messages in thread
From: srilinux @ 2017-03-22 14:35 UTC (permalink / raw)
To: 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 14:38 Scott Whitney <scott@journyx.com>
parent: srilinux <srilinux09@gmail.com>
1 sibling, 2 replies; 34+ messages in thread
From: Scott Whitney @ 2017-03-22 14:38 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; pgsql-admin
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
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
PostgreSQL - admin - unable to find data folder postgres9.4<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
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/
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 14:46 Tom Lane <tgl@sss.pgh.pa.us>
parent: Scott Whitney <scott@journyx.com>
1 sibling, 1 reply; 34+ messages in thread
From: Tom Lane @ 2017-03-22 14:46 UTC (permalink / raw)
To: Scott Whitney <scott@journyx.com>; +Cc: srilinux <srilinux09@gmail.com>; pgsql-admin
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 14:47 John Scalia <jayknowsunix@gmail.com>
parent: srilinux <srilinux09@gmail.com>
1 sibling, 1 reply; 34+ messages in thread
From: John Scalia @ 2017-03-22 14:47 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 16:06 srilinux <srilinux09@gmail.com>
parent: Scott Whitney <scott@journyx.com>
1 sibling, 1 reply; 34+ messages in thread
From: srilinux @ 2017-03-22 16:06 UTC (permalink / raw)
To: 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 16:07 srilinux <srilinux09@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 34+ messages in thread
From: srilinux @ 2017-03-22 16:07 UTC (permalink / raw)
To: pgsql-admin
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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 16:08 srilinux <srilinux09@gmail.com>
parent: John Scalia <jayknowsunix@gmail.com>
0 siblings, 0 replies; 34+ messages in thread
From: srilinux @ 2017-03-22 16:08 UTC (permalink / raw)
To: pgsql-admin
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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 16:10 Scott Whitney <scott@journyx.com>
parent: srilinux <srilinux09@gmail.com>
0 siblings, 1 reply; 34+ messages in thread
From: Scott Whitney @ 2017-03-22 16:10 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; pgsql-admin
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
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
PostgreSQL - admin - unable to find data folder postgres9.4<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
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/
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 16:15 srilinux <srilinux09@gmail.com>
parent: Scott Whitney <scott@journyx.com>
0 siblings, 3 replies; 34+ messages in thread
From: srilinux @ 2017-03-22 16:15 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 16:18 Yuri Leme <yuripl@gmail.com>
parent: srilinux <srilinux09@gmail.com>
2 siblings, 2 replies; 34+ messages in thread
From: Yuri Leme @ 2017-03-22 16:18 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; pgsql-admin
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
>
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 16:21 srilinux <srilinux09@gmail.com>
parent: Yuri Leme <yuripl@gmail.com>
1 sibling, 0 replies; 34+ messages in thread
From: srilinux @ 2017-03-22 16:21 UTC (permalink / raw)
To: 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 16:23 John Scalia <jayknowsunix@gmail.com>
parent: srilinux <srilinux09@gmail.com>
2 siblings, 0 replies; 34+ messages in thread
From: John Scalia @ 2017-03-22 16:23 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 16:24 Scott Whitney <scott@journyx.com>
parent: srilinux <srilinux09@gmail.com>
2 siblings, 0 replies; 34+ messages in thread
From: Scott Whitney @ 2017-03-22 16:24 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; 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
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
PostgreSQL - admin - unable to find data folder postgres9.4<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
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/
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 16:26 srilinux <srilinux09@gmail.com>
parent: Yuri Leme <yuripl@gmail.com>
1 sibling, 1 reply; 34+ messages in thread
From: srilinux @ 2017-03-22 16:26 UTC (permalink / raw)
To: pgsql-admin
/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
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 17:17 John Scalia <jayknowsunix@gmail.com>
parent: srilinux <srilinux09@gmail.com>
0 siblings, 3 replies; 34+ messages in thread
From: John Scalia @ 2017-03-22 17:17 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 17:36 srilinux <srilinux09@gmail.com>
parent: John Scalia <jayknowsunix@gmail.com>
2 siblings, 0 replies; 34+ messages in thread
From: srilinux @ 2017-03-22 17:36 UTC (permalink / raw)
To: 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 17:36 srilinux <srilinux09@gmail.com>
parent: John Scalia <jayknowsunix@gmail.com>
2 siblings, 2 replies; 34+ messages in thread
From: srilinux @ 2017-03-22 17:36 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 17:43 Yuri Leme <yuripl@gmail.com>
parent: srilinux <srilinux09@gmail.com>
1 sibling, 1 reply; 34+ messages in thread
From: Yuri Leme @ 2017-03-22 17:43 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; pgsql-admin
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
>
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 17:44 John Scalia <jayknowsunix@gmail.com>
parent: srilinux <srilinux09@gmail.com>
1 sibling, 1 reply; 34+ messages in thread
From: John Scalia @ 2017-03-22 17:44 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; +Cc: 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
>
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 17:50 srilinux <srilinux09@gmail.com>
parent: Yuri Leme <yuripl@gmail.com>
0 siblings, 1 reply; 34+ messages in thread
From: srilinux @ 2017-03-22 17:50 UTC (permalink / raw)
To: 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 17:53 srilinux <srilinux09@gmail.com>
parent: John Scalia <jayknowsunix@gmail.com>
0 siblings, 0 replies; 34+ messages in thread
From: srilinux @ 2017-03-22 17:53 UTC (permalink / raw)
To: pgsql-admin
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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 17:54 John Scalia <jayknowsunix@gmail.com>
parent: srilinux <srilinux09@gmail.com>
0 siblings, 1 reply; 34+ messages in thread
From: John Scalia @ 2017-03-22 17:54 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 18:28 srilinux <srilinux09@gmail.com>
parent: John Scalia <jayknowsunix@gmail.com>
0 siblings, 1 reply; 34+ messages in thread
From: srilinux @ 2017-03-22 18:28 UTC (permalink / raw)
To: 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 18:39 John Scalia <jayknowsunix@gmail.com>
parent: srilinux <srilinux09@gmail.com>
0 siblings, 0 replies; 34+ messages in thread
From: John Scalia @ 2017-03-22 18:39 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 18:45 Scott Whitney <scott@journyx.com>
0 siblings, 0 replies; 34+ messages in thread
From: Scott Whitney @ 2017-03-22 18:45 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; +Cc: 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
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/
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-22 18:46 Scott Whitney <scott@journyx.com>
0 siblings, 0 replies; 34+ messages in thread
From: Scott Whitney @ 2017-03-22 18:46 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-admin; srilinux <srilinux09@gmail.com>
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<mailto: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<mailto: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
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/
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-23 14:37 srilinux <srilinux09@gmail.com>
parent: John Scalia <jayknowsunix@gmail.com>
2 siblings, 1 reply; 34+ messages in thread
From: srilinux @ 2017-03-23 14:37 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-23 14:44 John Scalia <jayknowsunix@gmail.com>
parent: srilinux <srilinux09@gmail.com>
0 siblings, 1 reply; 34+ messages in thread
From: John Scalia @ 2017-03-23 14:44 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-23 16:23 srilinux <srilinux09@gmail.com>
parent: John Scalia <jayknowsunix@gmail.com>
0 siblings, 1 reply; 34+ messages in thread
From: srilinux @ 2017-03-23 16:23 UTC (permalink / raw)
To: 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-23 16:51 John Scalia <jayknowsunix@gmail.com>
parent: srilinux <srilinux09@gmail.com>
0 siblings, 1 reply; 34+ messages in thread
From: John Scalia @ 2017-03-23 16:51 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-23 18:30 Kris Deugau <kdeugau@vianet.ca>
parent: John Scalia <jayknowsunix@gmail.com>
0 siblings, 1 reply; 34+ messages in thread
From: Kris Deugau @ 2017-03-23 18:30 UTC (permalink / raw)
To: 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 34+ messages in thread
* Re: unable to find data folder postgres9.4
@ 2017-03-23 19:26 srilinux <srilinux09@gmail.com>
parent: Kris Deugau <kdeugau@vianet.ca>
0 siblings, 0 replies; 34+ messages in thread
From: srilinux @ 2017-03-23 19:26 UTC (permalink / raw)
To: pgsql-admin
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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 34+ messages in thread
end of thread, other threads:[~2017-03-23 19:26 UTC | newest]
Thread overview: 34+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-03-21 22:03 unable to find data folder postgres9.4 srilinux <srilinux09@gmail.com>
2017-03-22 08:08 ` Santiago DIEZ <santiago.diez@caoba.fr>
2017-03-22 14:35 ` srilinux <srilinux09@gmail.com>
2017-03-22 14:38 ` Scott Whitney <scott@journyx.com>
2017-03-22 14:46 ` Tom Lane <tgl@sss.pgh.pa.us>
2017-03-22 16:07 ` srilinux <srilinux09@gmail.com>
2017-03-22 16:06 ` srilinux <srilinux09@gmail.com>
2017-03-22 16:10 ` Scott Whitney <scott@journyx.com>
2017-03-22 16:15 ` srilinux <srilinux09@gmail.com>
2017-03-22 16:18 ` Yuri Leme <yuripl@gmail.com>
2017-03-22 16:21 ` srilinux <srilinux09@gmail.com>
2017-03-22 16:26 ` srilinux <srilinux09@gmail.com>
2017-03-22 17:17 ` John Scalia <jayknowsunix@gmail.com>
2017-03-22 17:36 ` srilinux <srilinux09@gmail.com>
2017-03-22 17:36 ` srilinux <srilinux09@gmail.com>
2017-03-22 17:43 ` Yuri Leme <yuripl@gmail.com>
2017-03-22 17:50 ` srilinux <srilinux09@gmail.com>
2017-03-22 17:54 ` John Scalia <jayknowsunix@gmail.com>
2017-03-22 18:28 ` srilinux <srilinux09@gmail.com>
2017-03-22 18:39 ` John Scalia <jayknowsunix@gmail.com>
2017-03-22 17:44 ` John Scalia <jayknowsunix@gmail.com>
2017-03-22 17:53 ` srilinux <srilinux09@gmail.com>
2017-03-23 14:37 ` srilinux <srilinux09@gmail.com>
2017-03-23 14:44 ` John Scalia <jayknowsunix@gmail.com>
2017-03-23 16:23 ` srilinux <srilinux09@gmail.com>
2017-03-23 16:51 ` John Scalia <jayknowsunix@gmail.com>
2017-03-23 18:30 ` Kris Deugau <kdeugau@vianet.ca>
2017-03-23 19:26 ` srilinux <srilinux09@gmail.com>
2017-03-22 16:23 ` John Scalia <jayknowsunix@gmail.com>
2017-03-22 16:24 ` Scott Whitney <scott@journyx.com>
2017-03-22 14:47 ` John Scalia <jayknowsunix@gmail.com>
2017-03-22 16:08 ` srilinux <srilinux09@gmail.com>
2017-03-22 18:45 Re: unable to find data folder postgres9.4 Scott Whitney <scott@journyx.com>
2017-03-22 18:46 Re: unable to find data folder postgres9.4 Scott Whitney <scott@journyx.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox