469,950 Members | 1,693 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

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 1703
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
By using this site, you agree to our Privacy Policy and Terms of Use.