472,102 Members | 2,092 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,102 software developers and data experts.

pg_start_backup throws warning:could not read symbolic link

While executing pg_start_backup function in postgres 9.6 DB I am getting below warning

select pg_start_backup(to_char(now(), 'yyyy-mm-dd hh24:mi:ss'));
Expand|Select|Wrap|Line Numbers
  1. WARNING:  could not read symbolic link "pg_tblspc/oth_data_tbs": Invalid argument
  2. WARNING:  could not read symbolic link "pg_tblspc/str_index": Invalid argument
  3. WARNING:  could not read symbolic link "pg_tblspc/tbs_temp_default": Invalid argument
  4. WARNING:  could not read symbolic link "pg_tblspc/oth_indx_tbs": Invalid argument
  5. WARNING:  could not read symbolic link "pg_tblspc/str_data_ids": Invalid argument
  6. WARNING:  could not read symbolic link "pg_tblspc/tbs_default": Invalid argument
  7.  pg_start_backup
  8. -----------------
  9.  5/E0000028
  10. (1 row)
Dec 22 '20 #1
1 1950
9,065 Expert Mod 8TB
A quick Google suggests your data directory is corrupt and that you should rebuild your database cleanly; full answer here
Dec 22 '20 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by chris kittell | last post: by
3 posts views Thread by Conrad | last post: by
3 posts views Thread by TK | last post: by
2 posts views Thread by Pabc | last post: by
1 post views Thread by amygrant1701 | last post: by
11 posts views Thread by mosscliffe | last post: by
1 post views Thread by pradeepjain | last post: by
2 posts views Thread by jennphp | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.