Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Duplicate
-
None
-
None
Description
Can not get any data when the network is connected again after a while disconnected.
1. Psql postgres, run "\d" and find relations in database.
psql postgres psql (8.2.15) Type "help" for help. postgres=# \d List of relations Schema | Name | Type | Owner | Storage --------+----------------+-------+--------------+------------- public | sales1 | table | wangchunling | append only public | sales1_1_prt_1 | table | wangchunling | append only public | sales1_1_prt_2 | table | wangchunling | append only public | t | table | wangchunling | append only public | tv | view | wangchunling | none (5 rows)
2. Quit the session and disconnect the network. Then psql postgres, run "\d" and get expected error.
$ psql postgres psql (8.2.15) Type "help" for help. postgres=# \d WARNING: curl_easy_perform() failed: Couldn't connect to server LINE 1: select version() ^ WARNING: curl_easy_perform() failed: Couldn't connect to server ERROR: permission denied for function version WARNING: curl_easy_perform() failed: Couldn't connect to server ERROR: permission denied for function version WARNING: curl_easy_perform() failed: Couldn't connect to server LINE 5: FROM pg_catalog.pg_class c ^ ERROR: permission denied for schema pg_catalog LINE 5: FROM pg_catalog.pg_class c ^
3. Connect the network and run "\d", but find no relations.
postgres=# \d No relations found.
4. Quit the session again. Then psql postgres, run "\d" and find relations correctly.
$ psql postgres psql (8.2.15) Type "help" for help. postgres=# \d List of relations Schema | Name | Type | Owner | Storage --------+----------------+-------+--------------+------------- public | sales1 | table | wangchunling | append only public | sales1_1_prt_1 | table | wangchunling | append only public | sales1_1_prt_2 | table | wangchunling | append only public | t | table | wangchunling | append only public | tv | view | wangchunling | none (5 rows)