23, 2010 at 1:02 PM, Kevin Grittner kevin.gritt...@wicourts.gov
wrote:
Net Tree Inc. wrote:
When I do restore it shown alot errors related with constraints.
How can I dump and to restore from old to new without dealing with
constraint and just forces data dump to where it suppose to belong
I am keep getting error of mismatch of pg_dump version. how should one
dealing with different version of pg_dump normally?
C:\Program Files\pgAdmin III\1.8\pg_dump.exe -h 192.168.222.129 -p 5433 -U
postgres -F c -b -v -f C:\Documents and
Settings\steven\Desktop\template.backup template_postgis
won't
work the other way around? Definitely impossible? then what is '-i' use
for.?
Steven
On Tue, Feb 23, 2010 at 5:55 PM, Magnus Hagander mag...@hagander.netwrote:
2010/2/23 Net Tree Inc. nettree...@gmail.com:
I am keep getting error of mismatch of pg_dump version. how should one
dealing
machine IP) -U postgres -d (target
db) mydb.dump
Steven
On Tue, Feb 23, 2010 at 10:31 PM, Richard Huxton d...@archonet.com wrote:
On 23/02/10 09:17, Net Tree Inc. wrote:
Why am I keep getting error with version issues I am trying to restore
a
backup file from a 8.4 postgresql server
--disable-triggers
-a data.dmp
-Original Message-
*From*: Net Tree Inc.
nettree...@gmail.com%22net%20tree%20inc.%22%20%3cnettree...@gmail.com%3e
*To*: pgsql-ad...@postgresql.org, pgsql-general@postgresql.org
*Subject*: [ADMIN] how do I do dump and restore without bugging
.
*De:* Net Tree Inc. [mailto:nettree...@gmail.com]
*Enviado el:* martes, 23 de febrero de 2010 17:36
*Para:* IƱigo Martinez Lasala
*CC:* pgsql-ad...@postgresql.org; pgsql-general@postgresql.org
*Asunto:* Re: [ADMIN] how do I do dump and restore without bugging with
constraint?
Thanks
be altered with the *SET
CONSTRAINTS*http://www.postgresql.org/docs/8.3/static/sql-set-constraints.htmlcommand.
On Tue, Feb 23, 2010 at 12:50 PM, Net Tree Inc. nettree...@gmail.comwrote:
Hi all,
I am dumping both schema and data from old database to new one. The new
database schema is somehow
Hi all,
I am dumping both schema and data from old database to new one. The new
database schema is somehow contain slightly different schema then the old
one. When I do restore it shown alot errors related with constraints. How
can I dump and to restore from old to new without dealing with
pie...@hogranch.com wrote:
Net Tree Inc. wrote:
Hi all,
I am dumping both schema and data from old database to new one. The new
database schema is somehow contain slightly different schema then the old
one. When I do restore it shown alot errors related with constraints. How
can I dump
If this e-mail address is not intend use for asking questions using e-mail
suscription, please ignore it. I could not find any official PostgreSQL
support forum for me to post ask questions. Appreciated if you could you
refer me a few good PostgreSQL support forum for me to ask questions.
10 matches
Mail list logo