Thread: problems with pg_restore and java

On Thu, Sep 8, 2011 at 10:45 AM, Miguel Angel Hernandez Moreno
<miguel.hdz.mrn@gmail.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

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@gmail.com>

On Thu, Sep 8, 2011 at 10:45 AM, Miguel Angel Hernandez Moreno
<miguel.hdz.mrn@gmail.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

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.hdz.mrn@gmail.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@gmail.com>

On Thu, Sep 8, 2011 at 10:45 AM, Miguel Angel Hernandez Moreno
<miguel.hdz.mrn@gmail.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