Re: Change connection (IP, or Databasename) - Mailing list pgsql-odbc

From E. Zorn (RDG-rational) postsql
Subject Re: Change connection (IP, or Databasename)
Date
Msg-id CEEKJLBCODIHNDAAIKNHOEABCBAA.postsql@rdg-rational.de
Whole thread Raw
In response to Re: Change connection (IP, or Databasename)  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Responses Re: Change connection (IP, or Databasename)
Re: Change connection (IP, or Databasename)
List pgsql-odbc
hi again,
I do so, but exact the relinking of the database is the problem.

I the new result of the frontend is ready for using in production
environment, I always have to relink / reconnect the frontend to the
"on air" database.
In my frontend I use the tables without the header "public_" witch
is provided from the server. I now have to relink all the tables and
after that I have to rename the tables (erase the "public_"). This takes a
long time (lot's of tables :-) ), isn't there a shorter method ?

thanks

-----Ursprungliche Nachricht-----
Von: Jeff Eckermann [mailto:jeff_eckermann@yahoo.com]
Gesendet: Donnerstag, 4. September 2003 22:41
An: edv@rdg-rational.de; pgsql-odbc@postgresql.org
Betreff: Re: [ODBC] Change connection (IP, or Databasename)


Not sure what you are asking...  If you want to create
a copy of your production database for
development/testing purposes, the easiest way is:

CREATE DATABASE myseconddatabase WITH TEMPLATE
myfirstdatabase;

Then just create a new DSN pointing to the new
database (or change your code, if you are not using a
DSN).  You would need to relink your tables also.

--- "E. Zorn (RDG-rational)" <edv@rdg-rational.de>
wrote:
> hi,
> I am using Access as a front-end for postgresql via
> ODBC.
>
> The postgresql-server is hosted on a separate
> linux-computer.
>
> I like to change the database on the SQL-server for
> developing or
> change the IP of the connected SQL-server so that
> the original data wouldnt
> be changed.
>
> Does anybody know a quick and comfortable way to do
> this. I know the
> possibility of importing the whole tables once again
> but they all have a
> header like "public_" which I have than manually to
> change.
>
> Elmar Zorn
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com




pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: ODBC Connection Pooling (Windows 2000 MDAC 2.7 patched,
Next
From: "Henry Alfke"
Date:
Subject: Re: Change connection (IP, or Databasename)