From: | sumita <suday(at)avaya(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: FATAL: database "a/system_data" does not exist |
Date: | 2013-05-15 12:45:33 |
Message-ID: | 1368621933337-5755577.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-05-15 13:08:37 | Re: dblink does not resolve DNS, but works with IP |
Previous Message | Kevin Grittner | 2013-05-15 12:13:19 | Re: Large amount of serialization errors in transactions |