From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Postgres 12 backup in 32 bit windows client |
Date: | 2020-03-28 18:09:59 |
Message-ID: | bca21367-ae30-5289-1503-a514526160d1@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 3/28/20 12:57 PM, Andrus wrote:
> 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')
What about you make the backup on the db server with cron and then have her
copy the file to her computer using WinSCP?
--
Angular momentum makes the world go 'round.
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2020-03-28 18:29:41 | Re: PG12 autovac issues |
Previous Message | Andrus | 2020-03-28 17:57:12 | Re: Postgres 12 backup in 32 bit windows client |