Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mkdirs.sh contains incorrect path if $PGDATA and pg_wal are symbolic links #266

Open
pgexplorer opened this issue Mar 26, 2024 · 1 comment

Comments

@pgexplorer
Copy link

mkdirs.sh contains incorrect path if $PGDATA and pg_wal are symbolic links.

The situation is as follows.
OS : Red Hat Enterprise Linux release 9.3 (Plow)
Package : postgresql16-server
Architecture : x86_64
Version : 16.2-1PGDG.rhel9
pg_rman : pg_rman-1.3.16-1.pg16.rhel9.x86_64.rpm

PGDATA=/var/lib/pgsql/16/data

$ ls -l $PGDATA
lrwxrwxrwx. 1 postgres postgres 26 Mar 21 22:02 data -> /pgsql-data/dbcluster/data
$ ls -l $PGDATA/pg_wal
lrwxrwxrwx. 1 postgres postgres 31 Mar 25 00:05 pg_wal -> /pgsql-backup/online-wal/pg_wal

$ cat mkdirs.sh
mkdir -m 700 -p /pgsql-backup/online-wal/pg_wal
mkdir -m 700 -p /pgsql-backup/online-wal/pg_wal/archive_status
mkdir -m 700 -p /pgsql-data/dbcluster/data
mkdir -m 700 -p /pgsql-data/dbcluster/data/base
mkdir -m 700 -p /pgsql-data/dbcluster/data/base/1
mkdir -m 700 -p /pgsql-data/dbcluster/data/base/16388
mkdir -m 700 -p /pgsql-data/dbcluster/data/base/4
mkdir -m 700 -p /pgsql-data/dbcluster/data/base/5
mkdir -m 700 -p /pgsql-data/dbcluster/data/base/pgsql_tmp
mkdir -m 700 -p /pgsql-data/dbcluster/data/global
mkdir -m 700 -p /pgsql-data/dbcluster/data/log
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_commit_ts
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_dynshmem
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_logical
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_logical/mappings
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_logical/snapshots
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_multixact
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_multixact/members
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_multixact/offsets
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_notify
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_replslot
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_serial
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_snapshots
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_stat
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_stat_tmp
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_subtrans
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_tblspc
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_twophase
mkdir -m 700 -p /pgsql-data/dbcluster/data/pg_xact

rm -f ata/pg_wal
ln -s /pgsql-backup/online-wal/pg_wal ata/pg_wal

======================================
[correct path]
rm -f /var/lib/pgsql/16/data/pg_wal
ln -s /pgsql-backup/online-wal/pg_wal /var/lib/pgsql/16/data/pg_wal

@zwyan0
Copy link
Contributor

zwyan0 commented Apr 12, 2024

@pgexplorer
Hi, Thank you for your issue.
pg_rman is not supput when $PGDATA is symbolic link.
but wher pg_wal is symbolic link pg_rman can do backup and restore.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants