[GENERAL] the installer of postgresql 9.4.1208 and 8.4-703 doesn't start

2016-07-16 Thread Stefania Miravalle
Hi there!
I am new here around, so please don't laugh at my question.

I dowloaded the installer but if I double click on that... nothing happens
:(. what am I doing wrong? I also turned off the antivirus, just in case
but nothing changed.

Any suggestion?
thank yo

-- 
Stefania


Re: [GENERAL] the installer of postgresql 9.4.1208 and 8.4-703 doesn't start

2016-07-16 Thread John R Pierce

On 7/16/2016 12:20 PM, Stefania Miravalle wrote:

Hi there!
I am new here around, so please don't laugh at my question.

I dowloaded the installer but if I double click on that... nothing 
happens :(. what am I doing wrong? I also turned off the antivirus, 
just in case but nothing changed.


Any suggestion?
thank yo


what operating system are you running?


--
john r pierce, recycling bits in santa cruz



Re: [GENERAL] the installer of postgresql 9.4.1208 and 8.4-703 doesn't start

2016-07-16 Thread Adrian Klaver

On 07/16/2016 12:20 PM, Stefania Miravalle wrote:

Hi there!
I am new here around, so please don't laugh at my question.

I dowloaded the installer but if I double click on that... nothing
happens :(. what am I doing wrong? I also turned off the antivirus, just
in case but nothing changed.

Any suggestion?
thank yo


Where did you get the installer?



--
Stefania



--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] the installer of postgresql 9.4.1208 and 8.4-703 doesn't start

2016-07-16 Thread John R Pierce

On 7/16/2016 12:20 PM, Stefania Miravalle wrote:


I dowloaded the installer but if I double click on that... nothing 
happens :(. what am I doing wrong? I also turned off the antivirus, 
just in case but nothing changed.


the Win x86-32 or win x86-64 links from here 
http://www.enterprisedb.com/products-services-training/pgdownload#windows ?


the version numbers you give above don't match any I see there. 8.4 
isn't even supported anymore, hasn't been for a long time.





--
john r pierce, recycling bits in santa cruz



Re: [GENERAL] the installer of postgresql 9.4.1208 and 8.4-703 doesn't start

2016-07-16 Thread Chris Mair

I dowloaded the installer


The strings "9.4-1208" and "8.4-703" look suspiciously like the PostgreSQL JDBC 
drivers
(drivers for the Java Programming Language). Perhaps that's not what you wanted?

To install PostgreSQL itself start here:

https://www.postgresql.org/download/

Bye,
Chris.





--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] the installer of postgresql 9.4.1208 and 8.4-703 doesn't start

2016-07-16 Thread Adrian Klaver

On 07/16/2016 12:51 PM, Stefania Miravalle wrote:

Please reply to list also.
Ccing list


from here :)
https://jdbc.postgresql.org/download.html#current


Well that is the JDBC driver.

Are you trying to install it?

Or are you trying to install the Postgres server?




2016-07-16 20:49 GMT+01:00 Adrian Klaver mailto:adrian.kla...@aklaver.com>>:

On 07/16/2016 12:20 PM, Stefania Miravalle wrote:

Hi there!
I am new here around, so please don't laugh at my question.

I dowloaded the installer but if I double click on that... nothing
happens :(. what am I doing wrong? I also turned off the
antivirus, just
in case but nothing changed.

Any suggestion?
thank yo


Where did you get the installer?


--
Stefania



--
Adrian Klaver
adrian.kla...@aklaver.com 




--
Stefania Miravalle
www.stefaniamiravalle.it 



--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] the installer of postgresql 9.4.1208 and 8.4-703 doesn't start

2016-07-16 Thread Stefania Miravalle
Oooops, sorry, I will reply to main list too.

So I just downloaded and instelled SQL Workbench/J as my it department
said, to help me with sql queries.
they also told me "Download a JDBC driver that will enable SQL Workbench/J
to connect to your cluster. Currently we recommends this version 8 JDBC
driver: http://jdbc.postgresql.org/download/postgresql-8.4-703.jdbc4.jar

I did it but I am not an expert, therefore I supposed I had to install it.
Am I wrong?

thank you!



2016-07-16 20:55 GMT+01:00 Adrian Klaver :

> On 07/16/2016 12:51 PM, Stefania Miravalle wrote:
>
> Please reply to list also.
> Ccing list
>
> from here :)
>> https://jdbc.postgresql.org/download.html#current
>>
>
> Well that is the JDBC driver.
>
> Are you trying to install it?
>
> Or are you trying to install the Postgres server?
>
>
>
>> 2016-07-16 20:49 GMT+01:00 Adrian Klaver > >:
>>
>> On 07/16/2016 12:20 PM, Stefania Miravalle wrote:
>>
>> Hi there!
>> I am new here around, so please don't laugh at my question.
>>
>> I dowloaded the installer but if I double click on that... nothing
>> happens :(. what am I doing wrong? I also turned off the
>> antivirus, just
>> in case but nothing changed.
>>
>> Any suggestion?
>> thank yo
>>
>>
>> Where did you get the installer?
>>
>>
>> --
>> Stefania
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian.kla...@aklaver.com 
>>
>>
>>
>>
>> --
>> Stefania Miravalle
>> www.stefaniamiravalle.it 
>>
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>



-- 
Stefania Miravalle
www.stefaniamiravalle.it


Re: [GENERAL] the installer of postgresql 9.4.1208 and 8.4-703 doesn't start

2016-07-16 Thread Adrian Klaver

On 07/16/2016 01:03 PM, Stefania Miravalle wrote:

Oooops, sorry, I will reply to main list too.

So I just downloaded and instelled SQL Workbench/J as my it department
said, to help me with sql queries.
they also told me "Download a JDBC driver that will enable SQL
Workbench/J to connect to your cluster. Currently we recommends this
version 8 JDBC driver:
http://jdbc.postgresql.org/download/postgresql-8.4-703.jdbc4.jar

I did it but I am not an expert, therefore I supposed I had to install
it. Am I wrong?


No, you are not wrong. You will need the jar file for SQL Workbench/J.

To  install see here:
http://www.sql-workbench.net/getting-started.html

Configuring the database (JDBC) drivers




thank you!




--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] the installer of postgresql 9.4.1208 and 8.4-703 doesn't start

2016-07-16 Thread Stefania Miravalle
oh I see!! thank you so much!!

you ROCK!!! thank you again,

Stefania

2016-07-16 21:06 GMT+01:00 Adrian Klaver :

> On 07/16/2016 01:03 PM, Stefania Miravalle wrote:
>
>> Oooops, sorry, I will reply to main list too.
>>
>> So I just downloaded and instelled SQL Workbench/J as my it department
>> said, to help me with sql queries.
>> they also told me "Download a JDBC driver that will enable SQL
>> Workbench/J to connect to your cluster. Currently we recommends this
>> version 8 JDBC driver:
>> http://jdbc.postgresql.org/download/postgresql-8.4-703.jdbc4.jar
>>
>> I did it but I am not an expert, therefore I supposed I had to install
>> it. Am I wrong?
>>
>
> No, you are not wrong. You will need the jar file for SQL Workbench/J.
>
> To  install see here:
> http://www.sql-workbench.net/getting-started.html
>
> Configuring the database (JDBC) drivers
>
>
>
>> thank you!
>>
>>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>



-- 
Stefania Miravalle
www.stefaniamiravalle.it


Re: [GENERAL] the installer of postgresql 9.4.1208 and 8.4-703 doesn't start

2016-07-16 Thread John R Pierce

On 7/16/2016 1:03 PM, Stefania Miravalle wrote:
So I just downloaded and instelled SQL Workbench/J as my it department 
said, to help me with sql queries.
they also told me "Download a JDBC driver that will enable SQL 
Workbench/J to connect to your cluster. Currently we recommends this 
version 8 JDBC driver: 
http://jdbc.postgresql.org/download/postgresql-8.4-703.jdbc4.jar


I did it but I am not an expert, therefore I supposed I had to install 
it. Am I wrong?


a .jar file is a java package, they are used as-is, most typically by 
specifying them in the CLASSPATH when you start a Java program.   As 
Adrian said, in this case, you configure sql workbench/j to use it, 
rather than installing it in your OS like regular programs.



--
john r pierce, recycling bits in santa cruz



Re: [GENERAL] the installer of postgresql 9.4.1208 and 8.4-703 doesn't start

2016-07-16 Thread Stefania Miravalle
Nice :). Thank you a lot for your time and sorry for the dumb question!!:)

have a good evening,
Stef



2016-07-16 21:15 GMT+01:00 John R Pierce :

> On 7/16/2016 1:03 PM, Stefania Miravalle wrote:
>
> So I just downloaded and instelled SQL Workbench/J as my it department
> said, to help me with sql queries.
> they also told me "Download a JDBC driver that will enable SQL Workbench/J
> to connect to your cluster. Currently we recommends this version 8 JDBC
> driver: http://jdbc.postgresql.org/download/postgresql-8.4-703.jdbc4.jar
>
> I did it but I am not an expert, therefore I supposed I had to install it.
> Am I wrong?
>
>
> a .jar file is a java package, they are used as-is, most typically by
> specifying them in the CLASSPATH when you start a Java program.   As Adrian
> said, in this case, you configure sql workbench/j to use it, rather than
> installing it in your OS like regular programs.
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>


-- 
Stefania Miravalle
www.stefaniamiravalle.it


Re: [GENERAL] Slony error please help

2016-07-16 Thread Jan Wieck
On Thu, Jun 16, 2016 at 3:36 PM, avi Singh 
wrote:

> /usr/pgsql-9.5/bin/pg_upgrade -b /usr/pgsql-9.4/bin/ -B
> /usr/pgsql-9.5/bin/ -d /var/lib/pgsql/cmates1/data/ -D
> /var/lib/pgsql/cmates1/data/9.5/ -p 5432 -P 5433 -c
>
>
> it throws this error
>
> Could not load library "$libdir/slony1_funcs.2.2.2"
> ERROR:  could not access file "$libdir/slony1_funcs.2.2.2": No such file
> or directory
>
>
Using git clones of everything on CentOS 7.1 I cannot reproduce this
problem.
Even the actual pg_upgrade without -c works, the cluster starts up and
replicates
just fine. I went through installing a 9.4 with 2.2.2, then upgrading to
2.2.4 (via
UPDATE FUNCTIONS) and last upgrading to 9.5 with pg_upgrade.

The only thing I can imagine would be that there is another slony cluster
(or
remnants of it) hanging around in the 9.4 installation, possibly in another
database.

Can you provide a list of all databases and all schemas in them from the
9.4 install?


Regards, Jan







>
>
> Not sure why it is still looking for slony1_funcs.2.2.2 even though the
> version is upgraded to 2.2.4 and it is running fine. i do see
> slony1_funcs.2.2.4.so files in lib directory which is how it should be
> since i have upgraded it to 2.2.4
>
>
> Any suggestions?
>
>
> Thanks
> Avi
>
>


-- 
Jan Wieck
Senior Postgres Architect