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

List:       postgresql-sql
Subject:    [SQL] Linked Databases
From:       "Ezequias Rodrigues da Rocha" <ezequias.rocha () gmail ! com>
Date:       2007-01-30 15:36:21
Message-ID: 55c095e90701300736o387af5a6k2c1af5905d904385 () mail ! gmail ! com
[Download RAW message or body]

Hi list,

I don't know how it occurs but in some way my work and test databases
are connected.

If I drop my work database the test database is dropped and vice
versa. I suppose it occurs becouse I am mantaining this two databases
making the following.

-  Backup the main database (work)

-  Restore all data on test (I already criated before)

Other times I just need to create the test database to it appears
identically the main database (work).

Could anybody tell me what to do ?

I am using pgAdmin and COMPRESS method to make my backup (I don't know
if pgAdmin has already capability to work with plain backups today).

any help would be welcomed.

I think if I didn't do a COMPRESS option and change all work names to
test it wouldn't happens.


 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


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