The database name is "a" and the "system_data" appears within the Schemas.
When I list the database from psql, I get following report
Name | Owner | Encoding | Collate | Ctype | Access
privileg
es
-----------+----------+----------+-------------+-------------+------------------
-----
a | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
+
| | | | |
postgres=CTc/post
gres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres=CTc/post
gres+
| | | | | =c/postgres
Also, You are correct , the database name should have been "a" rather than
"a\system_data" in the query shown in the logs. system_data is the schema
within database "a".
There is no empty space put in, I verified.
Also,so far I have unable to find out which process is invoking this query.
I do see the process id in the logs but I am unable to see this process id
in pg_stat_activity table..
Neither can I see any data with datname a\system_data in pg_stat_activity..
Is there any way , I can deduce which process is invoking this query,
Thanks much! Your inputs have been useful to help dig further into this
issue.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/FATAL-database-a-system-data-does-not-exist-tp5754839p5755577.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
