Re: Postgres 12 backup in 32 bit windows client - Mailing list pgsql-general

From Andrus
Subject Re: Postgres 12 backup in 32 bit windows client
Date
Msg-id 7706A89605D041E0A7B81CE1E24BF361@dell2
Whole thread Raw
In response to Re: Postgres 12 backup in 32 bit windows client  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Postgres 12 backup in 32 bit windows client
List pgsql-general
Hi!

>What are you going to do with this backup?

If server disk crashes, it can used to restore data.

>Do you have shell access to the Debian machine in order to do the backup 
>there?

I have but my application user in 32bit windows does not have.
I want to allow 32 bit windows user to make backup from 5432 port directly 
to her computer C: drive.

If Postgres 12 32bit pg_dump is not available maybe it is possible to create 
stored procedure which invokes pg_dump in server and returns .backup file as 
bytea value to client:

select run('pg_dump mydatabase')

Andrus.


-- 
Adrian Klaver
adrian.klaver@aklaver.com 




pgsql-general by date:

Previous
From: Enrico Pirozzi
Date:
Subject: Re: PostegreSQL 9.2 to 9.6
Next
From: Ron
Date:
Subject: Re: Postgres 12 backup in 32 bit windows client