I have 9.1 and 9.2 installed, and I am trying to build the PLR extension:
http://www.joeconway.com/plr/doc/plr-install.html
I'm using the USE_PGXS=1 method. But it's building for 9.1:
gcc -I/usr/include/postgresql/9.1/server ...
I want to build for 9.2. How can I do this?
--
Wells Olive
On Thu, Jul 11, 2013 at 11:14 PM, Wells Oliver wrote:
> I have 9.1 and 9.2 installed, and I am trying to build the PLR extension:
>
> http://www.joeconway.com/plr/doc/plr-install.html
>
> I'm using the USE_PGXS=1 method. But it's building for 9.1:
>
> gcc -I/usr/include/postgresql/9.1/server
What is the proper way to repoint pg_config? I'm on Ubuntu Server, so it's
in /usr/bin/pg_config, which references 9.1.
On Thu, Jul 11, 2013 at 10:52 AM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> On Thu, Jul 11, 2013 at 11:14 PM, Wells Oliver wrote:
>
>> I have 9.1 and 9.2 install
Hi,
On Thu, 2013-07-11 at 10:44 -0700, Wells Oliver wrote:
> I have 9.1 and 9.2 installed, and I am trying to build the PLR extension:
>
> http://www.joeconway.com/plr/doc/plr-install.html
>
> I'm using the USE_PGXS=1 method. But it's building for 9.1:
>
> gcc -I/usr/include/postgresql/9
All: it would take ~4 hours to pg_restore a backup. I want to quickly
create a duplicate cluster (for testing). My idea:
1. pg_ctlcreatecluster 9.1 test
2. rm /var/lib/postgresql/9.1/test/*
2. cp /var/lib/postgresql/9.1/main /var/lib/postgresql/9.1/test
3. pg_ctlcluster 9.1 test start
Is this via
> All: it would take ~4 hours to pg_restore a backup. I want to quickly
> create a duplicate cluster (for testing). My idea:
>
> 1. pg_ctlcreatecluster 9.1 test
> 2. rm /var/lib/postgresql/9.1/test/*
> 2. cp /var/lib/postgresql/9.1/main /var/lib/postgresql/9.1/test
> 3. pg_ctlcluster 9.1 test sta
So it's safe to copy the files in /var/lib/postgresql/9.1/main to
/var/lib/postgresql/9.1/test while main is running?
On Thu, Jul 11, 2013 at 1:41 PM, Gilberto Castillo <
gilberto.casti...@etecsa.cu> wrote:
>
>
> > All: it would take ~4 hours to pg_restore a backup. I want to quickly
> > create
Wells Oliver wrote:
> So it's safe to copy the files in /var/lib/postgresql/9.1/main to
> /var/lib/postgresql/9.1/test while main is running?
As long as you copy the whole $PGDATA tree while the source cluster
is stopped, or use PITR recovery techniques:
http://www.postgresql.org/docs/9.2/inter
> So it's safe to copy the files in /var/lib/postgresql/9.1/main to
> /var/lib/postgresql/9.1/test while main is running?
>
Yes, but the server where copy is stop.
Saludos,
Gilberto Castillo
La Habana, Cuba
---
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at
ho
Wells Oliver writes:
> So it's safe to copy the files in /var/lib/postgresql/9.1/main to
> /var/lib/postgresql/9.1/test while main is running?
Yes, provided that you put main in backup mode and then do a PITR when
you bring up this new test instance.
If your main DB is running but absolutely
Hmm, is it feasible to create a new cluster by using pg_basebackup, e.g:
1. pg_createcluster 9.1 test
2. pg_basebackup --pgdata=/var/lib/postgresql/9.1/test -h localhost -p 5432
3. pg_ctlcluster 9.1 test start
Would that work?
On Thu, Jul 11, 2013 at 1:54 PM, Jerry Sievers wrote:
> Wells Olive
Thanks Alvaro, that works. Appreciate the help.
Kevin Struckhoff, TDWI
Sr. IT Mgr, LA DR Operations
kstruckh...@ebay.comebayenterprise.com
o: 818.686.4719 | c: 818.968.0634 |
The information contained in this electronic mail transmission is intended only
for the use of the individual o
I already did that. In fact, it works fine for pgAdmin III access from my
laptop to my db server.
Kevin Struckhoff, TDWI
Sr. IT Mgr, LA DR Operations
kstruckh...@ebay.comebayenterprise.com
o: 818.686.4719 | c: 818.968.0634 |
The information contained in this electronic mail transmissio
I ran:
pg_ctlcluster 9.1 main start
Received:
The PostgreSQL server failed to start. Please check the log output.
But, hey, in /var/log/postgresql, there was absolutely no logging. Nothing.
After some googling, I tried:
usr/lib/postgresql/9.1/bin/postgres -D /data/postgresql/9.1/main -c
config
I have this error in a pg_upgrade:
psql:pg_upgrade_dump_db.sql:88725: ERROR: UNION could not convert type
text[] to integer[]
Command executed:
time \
/usr/lib/postgresql/9.2/bin/pg_upgrade -k \
-b /usr/lib/postgresql/9.1/bin \
-B /usr/lib/postgresql/9.2/bin \
-d /data/postgresql/9.
Wells Oliver escribió:
> I have this error in a pg_upgrade:
>
> psql:pg_upgrade_dump_db.sql:88725: ERROR: UNION could not convert type
> text[] to integer[]
Have a look at the file and see what's in the mentioned line. My guess
is that this is a view definition, or similar, that no longer works
16 matches
Mail list logo
