Postgres 12 backup in 32 bit windows client

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Postgres 12 backup in 32 bit windows client

Andrus Moor
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.



Reply | Threaded
Open this post in threaded view
|

Re: Postgres 12 backup in 32 bit windows client

Adrian Klaver-4
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
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: Postgres 12 backup in 32 bit windows client

Andrus Moor
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
[hidden email]



Reply | Threaded
Open this post in threaded view
|

Re: Postgres 12 backup in 32 bit windows client

Ron-2
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.