[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    [BUGS] BUG #8182: Database name duplicate in one postgres instance
From:       sachinthana.anuradha () yahoo ! com
Date:       2013-05-28 5:10:08
Message-ID: E1UhCAi-0003J8-T0 () wrigleys ! postgresql ! org
[Download RAW message or body]

The following bug has been logged on the website:

Bug reference:      8182
Logged by:          Sachinthana Rajapaksha
Email address:      sachinthana.anuradha@yahoo.com
PostgreSQL version: Unsupported/Unknown
Operating system:   redhat
Description:        

Hi,

We are having a problem with postgres database version 8.0.14. This is a
production data base and suddenly it has created a database under the same
name in one postgres instance.

            List of databases
        Name        |  Owner   | Encoding 
--------------------+----------+----------
 monitor_cacti      | Monitor  | UNICODE
 template0          | postgres | UNICODE
 template1          | postgres | UNICODE
 *_live 	    | xxx      | UNICODE
 *_live 	    | xxx      | UNICODE
(5 rows)

once we checked the datfrozenxid and datvacuumxid it show like this. 

    oid    |      datname       | datdba | encoding | datistemplate |
datallowconn | datlastsysoid | datvacuumxid | datfrozenxid | dattablespace |
datconfig |         datacl         
-----------+--------------------+--------+----------+---------------+--------------+-- \
-------------+--------------+--------------+---------------+-----------+------------------------
  18580764 | *_live 	    |    100 	 |        6 | f             | t          
 |         17228 |          482 |          482 |          1663 |           |

  95000657 | monitor_cacti      |    101 |        6 | f             | t     
      |         17228 |          482 |          482 |          1663 |       
   | 
         1 | template1          |      1 |        6 | t             | t     
      |         17228 |          482 |     482 |          1663 |           |
{postgres=CT/postgres}
     17229 | template0          |      1 |        6 | t             | f     
      |         17228 |          482 |          482 |          1663 |       
   | {postgres=CT/postgres}
 116382901 |*_live 	    |        100 |        6 | f             | t         
  |         17228 |   3261314675 |   3261314675 |          1663 |          
> 
(5 rows)
 

one of the duplicated database show very large value and other shoe 482.

We cannot take the backups since it duplicate the databases.

I need to know about these.

1. If I get the data folder copied and paste that to a other postgres
instance  can I restore the database?

2. why this kind of duplicate happens and is there workaround to solve this
issue?

3. why datfrozenxid and datvacuumxid shows large valuse?

Since this is a production database appriciate early feedback.

Thanks
Sachinthana



-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


[prev in list] [next in list] [prev in thread] [next in thread]