> 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.
>> 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
> 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?