On Mon, 25 Nov 2013, Tree wrote:
TLDR: We want to be able to use streaming replication, WAL archiving, and
have the ability to restore from a backup made before a failover using the
WAL archive.
(cutting rest of long description)
So, is it possible to use a "long-term WAL archive area
TLDR: We want to be able to use streaming replication, WAL archiving, and
have the ability to restore from a backup made before a failover using the
WAL archive.
Setup:
We use postgresql 9.1 with streaming replication between a pair of nodes.
The nodes are identical, and can fail over and fa
t
check time can be altered with the *SET
CONSTRAINTS*<http://www.postgresql.org/docs/8.3/static/sql-set-constraints.html>command.
On Tue, Feb 23, 2010 at 12:50 PM, Net Tree Inc. wrote:
> Hi all,
>
> I am dumping both schema and data from old database to new one. The new
>
ble definitions, everything will go
> well. However if you have to modify table definitions, you will probably not
> be able to import data in that new schema and it will be necesary to look
> for a new strategy.
>
>
>
> *De:* Net Tree Inc. [mailto:nettree...@gmail.com]
> *
e data disabling triggers
> pg_restore -h server_destination -U username -d database --disable-triggers
> -a data.dmp
>
>
>
> -Original Message-
> *From*: Net Tree Inc.
>
> >
> *To*: pgsql-ad...@postgresql.org, pgsql-general@postgresql.org
> *Subject*: [ADMIN]
arget machine IP) -U postgres -d (target
db) mydb.dump
Steven
On Tue, Feb 23, 2010 at 10:31 PM, Richard Huxton 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
bably 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 wrote:
> 2010/2/23 Net Tree Inc. :
> >>>I am keep getting error of mismatch of pg_dump version. how should one
> dea
>>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
23, 2010 at 1:02 PM, Kevin Grittner 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 s
, John R Pierce 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
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 constra
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.
Problem
12 matches
Mail list logo
