Обсуждение: 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.