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:41:59
Message-ID: CAGYOd3qor8UJN6eCiuaFDBxzXOTYfvEp6dBFGd46qdNSLSwkcg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

sorry

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\file.backup"

2011/9/8 Miguel Angel Hernandez Moreno <miguel(dot)hdz(dot)mrn(at)gmail(dot)com>

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

--
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 17:15:14 Re: problems with pg_restore and java
Previous Message Miguel Angel Hernandez Moreno 2011-09-08 16:25:35 Re: problems with pg_restore and java