Ivan Sergio Borgonovo writes:
> It seems that you have to actually restore the 2 backup separately.
>
> pg_restore -1 -d mydb < nearly_full.bak
> pg_restore -1 -d mydb < schema_only.bak
>
> I can't think of any other way to restore both in one transaction
> unless I backup in plain text. But that
On Mon, 28 Dec 2009 21:20:17 +0100
Ivan Sergio Borgonovo wrote:
> pg_dump -Fc -Z9 -s -t *.cache* -d mydb > schema_only.bak
> pg_dump -Fc -Z9 -T *.cache* -d mydb > nearly_full.bak
> cat nearly_full.bak schema_only.bak | pg_restore -1 -d mydb
> It seems it is working... I'll test if everything is
On 28/12/2009 20:20, Ivan Sergio Borgonovo wrote:
> On Mon, 28 Dec 2009 19:39:36 +
> Raymond O'Donnell wrote:
>
>> On 28/12/2009 18:41, Ivan Sergio Borgonovo wrote:
>>
>>> I'd like to just dump the table schema without dumping the table
>>> contend.
>
>> pg_dump -s -t
>
> My fault. I was
On Mon, 28 Dec 2009 19:39:36 +
Raymond O'Donnell wrote:
> On 28/12/2009 18:41, Ivan Sergio Borgonovo wrote:
>
> > I'd like to just dump the table schema without dumping the table
> > contend.
> pg_dump -s -t
My fault. I was not clear enough.
I'd like to make a "mostly" full backup, exclu
On 28/12/2009 18:41, Ivan Sergio Borgonovo wrote:
> I'd like to just dump the table schema without dumping the table
> contend.
pg_dump -s -t
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
I've some tables that are just cache.
I'd like to just dump the table schema without dumping the table
contend.
I think I could do it in 2 steps but I'd like to avoid it.
Is there a way?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgs
