Re: problems with pg_restore and java

From: Miguel Angel Hernandez Moreno <miguel(dot)hdz(dot)mrn(at)gmail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problems with pg_restore and java
Date: 2011-09-08 16:25:35
Message-ID: CAGYOd3pFb=V1Ja6dmMPWseXbE8yG7NeLP=POGK997UN=L0ez8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry

This is the error that sends me

pg_restore: connecting to database for restore
pg_restore: [archiver (db)] connection to database "postgres" failed: could
not create socket: Unknown socket error (0x0000277A/10106)
pg_restore: *** aborted because of error

And this is the value of my variables

comando=: "C:\Program Files\pgAdmin III\1.12\pg_restore.exe" -h 192.170.1.89
-d postgres -U postgres -v -1 "C:\Users\Miguel\Documents\NetBeansProjects\
env[0]=PGPASSWORD=postgres

2011/9/8 Merlin Moncure <mmoncure(at)gmail(dot)com>

> On Thu, Sep 8, 2011 at 10:45 AM, Miguel Angel Hernandez Moreno
> <miguel(dot)hdz(dot)mrn(at)gmail(dot)com> wrote:
> > Hello
> >
> > I have a program in java to make a backup running pg_restore, If you use
> > linux give a successful outcome.
> > but if you use windows I mark an error generating the socket. I think
> that
> > it could be the environment variables in Windows.
> > My java code is as follows.
> >
> > String comando="";
> > String env[]={ "PGPASSWORD="+String.valueOf( jPPass.getPassword() ) };
> > comando=directorioBinario+" -h "+jTxIP.getText()+" -d
> > "+jTxNombreTabla.getText()+" -U "+jTxNombreUsuario.getText()+" -v -1
> > "+archivoRespaldo;
> >
> > try {
> > p = Runtime.getRuntime().exec(comando,env); <-------Error in
> windows
> > InputStream es = p.getErrorStream();
> > arch.muestraSalidaDeError(es);
> > } catch (IOException ex) {
> > Logger.getLogger(gPrincipal.class.getName()).log(Level.SEVERE, null,
> > ex);
> > }
> >
> > I use my env variable to enter the password of postgres
>
> The error string would be helpful.
>
> merlin
>

--
ISC Miguel Angel Hernandez Moreno

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Miguel Angel Hernandez Moreno 2011-09-08 16:41:59 Re: problems with pg_restore and java
Previous Message Merlin Moncure 2011-09-08 16:22:09 Re: feature request - update nowait