Обсуждение: Postgres 12 backup in 32 bit windows client

Hi!

Postgres 12 is installed in Debian 10 server.
Client computer is running 32 bit windows.

pg_dump.exe which can downloaded as part of Postgres 12 windows installation 
is only 64 bit version.

How to make backup from Postgres 12  in 32 bit Microsoft windows computer ?
psqlodbc is used for data access.
Maybe there is 32 -bit version of pg_dump.exe.

Andrus. 

On 3/28/20 8:18 AM, Andrus wrote:
> Hi!
> 
> Postgres 12 is installed in Debian 10 server.
> Client computer is running 32 bit windows.
> 
> pg_dump.exe which can downloaded as part of Postgres 12 windows 
> installation is only 64 bit version.
> 
> How to make backup from Postgres 12  in 32 bit Microsoft windows computer ?
> psqlodbc is used for data access.
> Maybe there is 32 -bit version of pg_dump.exe.

The newest I can see is for 10.12:

https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

and you would not want to use that to dump a version 12 database.

What are you going to do with this backup?

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

> 
> Andrus.
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

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 

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.