Regarding parallel running of 9.1 and 9.2beta2

On Fri, Jun 29, 2012 at 1:47 PM, Atri Sharma <atri.jiit@gmail.com> wrote:

Hi,

I am running PostgreSQL 9.1 currently and I want to run 9.2beta2
simultaneously with it.Is it possible?

Yes, You can have multiple PostgreSQL versions on same host.

I downloaded the 9.2beta2 sources,untared them and ran

./configure,make and make install without uninstalling 9.1.

./configure --prefix=<new location of PostgreSQL 9.2 beta2 binaries>

make

make install

<new location of PostgreSQL 9.2 beta2 binaries>/bin/initdb -D <new data
directory location of 9.2beta2>

modify "Port" number in postgresql.conf file located under <new data
directory location of 9.2beta2>

<new location of PostgreSQL 9.2 beta2 binaries>/bin/pg_ctl -D <new data
directory location of 9.2beta2> start

Now,when I am running pg_ctl start,I am getting the following error:

pg_ctl start
server starting
gitc@ubuntu:~/Downloads$ FATAL: database files are incompatible with
server
DETAIL: The data directory was initialized by PostgreSQL version 9.1,
which is not compatible with this version 9.2beta2.

Please help me.What should I be doing to recover from this error and
get back to 9.1?

Suspecting for this error message is, binaries upgraded upto 9.2beta2 &
PostgreSQL instance running with PostgreSQL 9.1 binaries and again you are
trying to start instance with pg_ctl of 9.2beta2 binary.

--

Thanks & Regards,

Raghu Ram

On Fri, Jun 29, 2012 at 2:02 PM, raghu ram <raghuchennuru@gmail.com> wrote:

On Fri, Jun 29, 2012 at 1:47 PM, Atri Sharma <atri.jiit@gmail.com> wrote:

Hi,

I am running PostgreSQL 9.1 currently and I want to run 9.2beta2
simultaneously with it.Is it possible?

Yes, You can have multiple  PostgreSQL versions on same host.

I downloaded the 9.2beta2 sources,untared them and ran
./configure,make and make install without uninstalling 9.1.

./configure --prefix=<new location of PostgreSQL 9.2 beta2 binaries>

make

make install

<new location of PostgreSQL 9.2 beta2 binaries>/bin/initdb -D <new data
directory location of 9.2beta2>

modify "Port" number in postgresql.conf file located under  <new data
directory location of 9.2beta2>

<new location of PostgreSQL 9.2 beta2 binaries>/bin/pg_ctl -D <new data
directory location of 9.2beta2> start

Now,when I am running pg_ctl start,I am getting the following error:

 pg_ctl start
server starting
gitc@ubuntu:~/Downloads$ FATAL:  database files are incompatible with
server
DETAIL:  The data directory was initialized by PostgreSQL version 9.1,
which is not compatible with this version 9.2beta2.

Please help me.What should I be doing to recover from this error and
get back to 9.1?

Suspecting for this error message is, binaries upgraded upto 9.2beta2 &
PostgreSQL instance running with PostgreSQL 9.1 binaries and again you are
trying to start instance with pg_ctl of 9.2beta2 binary.

--

Thanks & Regards,

Raghu Ram

Hi Raghu,

Thanks for your reply.

I ran make install in my 9.1 directory again,and this time,the server
started but is giving errors in running the code which was running
earlier.Could you tell me a way in which I could remove both 9.1 and
9.2beta2 and build both from scratch and install them independently
this time?

Atri
--
Regards,

Atri
l'apprenant

Hi Raghu,

Thanks for your reply.

I ran make install in my 9.1 directory again,and this time,the server
started but is giving errors in running the code which was running
earlier.Could you tell me a way in which I could remove both 9.1 and
9.2beta2 and build both from scratch and install them independently
this time?

cd <PostgreSQL 9.1/PostgreSQL 9.2beta2 source directory>

./configure

make distclean

Remove "pgsql" directory from /usr/local

and then you can build both from scratch and install them independently

--

Thanks & Regards,

Raghu Ram

On 06/29/12 1:43 AM, raghu ram wrote:

and then you can build both from scratch and install them independently

in case noone has made this clear, use different --prefix= paths on the
./configure line, and when you're running initdb and starting the
database server, specify different $PGPORT and $PGDATA values.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

On Fri, Jun 29, 2012 at 2:37 PM, John R Pierce <pierce@hogranch.com> wrote:

On 06/29/12 1:43 AM, raghu ram wrote:

and then you can build both from scratch and install them independently

in case noone has made this clear, use different --prefix= paths on the
./configure line, and when you're running initdb and starting the database
server, specify different $PGPORT and $PGDATA values.

--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

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

Hi John,

What values should I be setting in PGDATA and PGPORT?

Atri
--
Regards,

Atri
l'apprenant

On Fri, Jun 29, 2012 at 3:14 PM, Atri Sharma <atri.jiit@gmail.com> wrote:

On Fri, Jun 29, 2012 at 2:37 PM, John R Pierce <pierce@hogranch.com> wrote:

On 06/29/12 1:43 AM, raghu ram wrote:

and then you can build both from scratch and install them independently

in case noone has made this clear, use different --prefix= paths on the
./configure line, and when you're running initdb and starting the database
server, specify different $PGPORT and $PGDATA values.

--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

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

Hi John,

What values should I be setting in PGDATA and PGPORT?

Atri
--
Regards,

Atri
l'apprenant

Another thing,I am using the PGXN build in my project but I want the
additional flag '-ljvm' also when gcc compiles my project.

I added these lines to my makefile:

export CFLAGS="$CFLAGS -ljvm"
export CXXFLAGS="$CXXFLAGS -ljvm"export CFLAGS="$CFLAGS -ljvm"
export CXXFLAGS="$CXXFLAGS -ljvm"

This was working before,but now,when I have reinstalled PostgreSQL
9.1.3 from source,I am not able to see the -ljvm flag in my project's
compilation and I am getting an error when I am runnning it.How can I
include the flag?

Atri

--
Regards,

Atri
l'apprenant

Hi John,

What values should I be setting in PGDATA and PGPORT?

Below URL provides more information on this:

http://www.postgresql.org/docs/9.1/static/libpq-envars.html

--

Thanks & Regards,

Raghu Ram

On Fri, Jun 29, 2012 at 3:36 PM, raghu ram <raghuchennuru@gmail.com> wrote:

Hi John,

What values should I be setting in PGDATA and PGPORT?

Below URL provides more information on this:

http://www.postgresql.org/docs/9.1/static/libpq-envars.html

--

Thanks & Regards,

Raghu Ram

Thanks Raghu.

BTW,could you solve my other(makefile) issue please?

Atri

--
Regards,

Atri
l'apprenant

Thanks Raghu.

BTW,could you solve my other(makefile) issue please?

Atri

Sorry about Makefile issue, someone would have better solution on it..

-Raghu Ram

On Fri, Jun 29, 2012 at 4:20 PM, raghu ram <raghuchennuru@gmail.com> wrote:

Thanks Raghu.

BTW,could you solve my other(makefile) issue please?

Atri

Sorry about Makefile issue, someone would have better solution on it..

-Raghu Ram

No problem,thanks a lot for your help!

Atri

--
Regards,

Atri
l'apprenant

On Fri, Jun 29, 2012 at 4:21 PM, Atri Sharma <atri.jiit@gmail.com> wrote:

On Fri, Jun 29, 2012 at 4:20 PM, raghu ram <raghuchennuru@gmail.com> wrote:

Thanks Raghu.

BTW,could you solve my other(makefile) issue please?

Atri

Sorry about Makefile issue, someone would have better solution on it..

-Raghu Ram

No problem,thanks a lot for your help!

Atri

--
Regards,

Atri
l'apprenant

Hi Raghu,

After I did what you told me to uninstall,I compiled and installed
only 9.2beta2.I am getting this output when I run pg_ctl start:

pg_ctl start
pg_ctl: another server might be running; trying to start server anyway
server starting
gitc@ubuntu:~/Downloads/postgresql-9.2beta2$ FATAL: database files
are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 9.1,
which is not compatible with this version 9.2beta2.

Please help.

Atri

--
Regards,

Atri
l'apprenant

Atri Sharma wrote:

I am running PostgreSQL 9.1 currently and I want to run 9.2beta2
simultaneously with it.Is it possible?

I downloaded the 9.2beta2 sources,untared them and ran
./configure,make and make install without uninstalling 9.1.

Now,when I am running pg_ctl start,I am getting the following error:

pg_ctl start
server starting
gitc@ubuntu:~/Downloads$ FATAL: database files are incompatible with

server

DETAIL: The data directory was initialized by PostgreSQL version 9.1,
which is not compatible with this version 9.2beta2.

Please help me.What should I be doing to recover from this error and
get back to 9.1?

Did you overwrite your 9.1 installation (i.e. --prefix was the same
for both installations)?

If yes, then rebuild and reinstall 9.1, and everything should work.

If you did not overwrite 9.1, simply use the 9.1 binaries to start
the server.

Yours,
Laurenz Albe

On Fri, Jun 29, 2012 at 5:12 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:

Atri Sharma wrote:

I am running PostgreSQL 9.1 currently and I want to run 9.2beta2
simultaneously with it.Is it possible?

I downloaded the 9.2beta2 sources,untared them and ran
./configure,make and make install without uninstalling 9.1.

Now,when I am running pg_ctl start,I am getting the following error:

 pg_ctl start
server starting
gitc@ubuntu:~/Downloads$ FATAL:  database files are incompatible with

server

DETAIL:  The data directory was initialized by PostgreSQL version 9.1,
which is not compatible with this version 9.2beta2.

Please help me.What should I be doing to recover from this error and
get back to 9.1?

Did you overwrite your 9.1 installation (i.e. --prefix was the same
for both installations)?

If yes, then rebuild and reinstall 9.1, and everything should work.

If you did not overwrite 9.1, simply use the 9.1 binaries to start
the server.

Yours,
Laurenz Albe

Hi Laurenz,

Actually,I did not specify --prefix option at all in either case.

I rebuilt and reinstalled 9.1,but now,as mentioned earlier,my project
is not running successfully on it(I need the -ljvm flag in gcc for
compilation.I am using PGXN and I added EXPORT CXXFLAG=$CXXFLAG
"-ljvm" and EXPORT CFLAG=$CFLAG "-ljvm" to the makefile of my
project.This was working till today morning,when I stupidly installed
9.2beta2 without specifying a new --prefix.)

What should I do?

Atri
--
Regards,

Atri
l'apprenant

On Fri, Jun 29, 2012 at 6:57 AM, Atri Sharma <atri.jiit@gmail.com> wrote:

On Fri, Jun 29, 2012 at 5:12 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:

Atri Sharma wrote:

I am running PostgreSQL 9.1 currently and I want to run 9.2beta2
simultaneously with it.Is it possible?

I downloaded the 9.2beta2 sources,untared them and ran
./configure,make and make install without uninstalling 9.1.

Now,when I am running pg_ctl start,I am getting the following error:

 pg_ctl start
server starting
gitc@ubuntu:~/Downloads$ FATAL:  database files are incompatible with

server

DETAIL:  The data directory was initialized by PostgreSQL version 9.1,
which is not compatible with this version 9.2beta2.

Please help me.What should I be doing to recover from this error and
get back to 9.1?

Did you overwrite your 9.1 installation (i.e. --prefix was the same
for both installations)?

If yes, then rebuild and reinstall 9.1, and everything should work.

If you did not overwrite 9.1, simply use the 9.1 binaries to start
the server.

Yours,
Laurenz Albe

Hi Laurenz,

Actually,I did not specify --prefix option at all in either case.

I rebuilt and reinstalled 9.1,but now,as mentioned earlier,my project
is not running successfully on it(I need the -ljvm flag in gcc for
compilation.I am using PGXN and I added EXPORT CXXFLAG=$CXXFLAG
"-ljvm" and EXPORT CFLAG=$CFLAG "-ljvm" to the makefile of my
project.This was working till today morning,when I stupidly installed
9.2beta2 without specifying a new --prefix.)

What should I do?

when in doubt, look at the other contrib projects. they use
SHLIB_LINK. This was in your old makefile at some point but it was
reverted out.

merlin

On Fri, Jun 29, 2012 at 7:01 PM, Merlin Moncure <mmoncure@gmail.com> wrote:

On Fri, Jun 29, 2012 at 6:57 AM, Atri Sharma <atri.jiit@gmail.com> wrote:

On Fri, Jun 29, 2012 at 5:12 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:

Atri Sharma wrote:

I am running PostgreSQL 9.1 currently and I want to run 9.2beta2
simultaneously with it.Is it possible?

I downloaded the 9.2beta2 sources,untared them and ran
./configure,make and make install without uninstalling 9.1.

Now,when I am running pg_ctl start,I am getting the following error:

 pg_ctl start
server starting
gitc@ubuntu:~/Downloads$ FATAL:  database files are incompatible with

server

DETAIL:  The data directory was initialized by PostgreSQL version 9.1,
which is not compatible with this version 9.2beta2.

Please help me.What should I be doing to recover from this error and
get back to 9.1?

Did you overwrite your 9.1 installation (i.e. --prefix was the same
for both installations)?

If yes, then rebuild and reinstall 9.1, and everything should work.

If you did not overwrite 9.1, simply use the 9.1 binaries to start
the server.

Yours,
Laurenz Albe

Hi Laurenz,

Actually,I did not specify --prefix option at all in either case.

I rebuilt and reinstalled 9.1,but now,as mentioned earlier,my project
is not running successfully on it(I need the -ljvm flag in gcc for
compilation.I am using PGXN and I added EXPORT CXXFLAG=$CXXFLAG
"-ljvm" and EXPORT CFLAG=$CFLAG "-ljvm" to the makefile of my
project.This was working till today morning,when I stupidly installed
9.2beta2 without specifying a new --prefix.)

What should I do?

when in doubt, look at the other contrib projects.   they use
SHLIB_LINK.  This was in your old makefile at some point but it was
reverted out.

merlin

I was only doing export CFLAGS="CFLAGS -ljvm" before...

--
Regards,

Atri
l'apprenant

On Fri, Jun 29, 2012 at 7:05 PM, Atri Sharma <atri.jiit@gmail.com> wrote:

On Fri, Jun 29, 2012 at 7:01 PM, Merlin Moncure <mmoncure@gmail.com> wrote:

On Fri, Jun 29, 2012 at 6:57 AM, Atri Sharma <atri.jiit@gmail.com> wrote:

On Fri, Jun 29, 2012 at 5:12 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:

Atri Sharma wrote:

I am running PostgreSQL 9.1 currently and I want to run 9.2beta2
simultaneously with it.Is it possible?

I downloaded the 9.2beta2 sources,untared them and ran
./configure,make and make install without uninstalling 9.1.

Now,when I am running pg_ctl start,I am getting the following error:

 pg_ctl start
server starting
gitc@ubuntu:~/Downloads$ FATAL:  database files are incompatible with

server

DETAIL:  The data directory was initialized by PostgreSQL version 9.1,
which is not compatible with this version 9.2beta2.

Please help me.What should I be doing to recover from this error and
get back to 9.1?

Did you overwrite your 9.1 installation (i.e. --prefix was the same
for both installations)?

If yes, then rebuild and reinstall 9.1, and everything should work.

If you did not overwrite 9.1, simply use the 9.1 binaries to start
the server.

Yours,
Laurenz Albe

Hi Laurenz,

Actually,I did not specify --prefix option at all in either case.

I rebuilt and reinstalled 9.1,but now,as mentioned earlier,my project
is not running successfully on it(I need the -ljvm flag in gcc for
compilation.I am using PGXN and I added EXPORT CXXFLAG=$CXXFLAG
"-ljvm" and EXPORT CFLAG=$CFLAG "-ljvm" to the makefile of my
project.This was working till today morning,when I stupidly installed
9.2beta2 without specifying a new --prefix.)

What should I do?

when in doubt, look at the other contrib projects.   they use
SHLIB_LINK.  This was in your old makefile at some point but it was
reverted out.

merlin

I was only doing export CFLAGS="CFLAGS -ljvm" before...

--
Regards,

Atri
l'apprenant

SHLIB_LINK worked like a charm.Thanks to my mentor for coming to my
rescue(yet again)!

Thanks to everybody who assisted me(Laurenz,Raghu,John).

Atri

Atri

--
Regards,

Atri
l'apprenant