Thank you Scot. I will try
Sent from my HTC
- Reply message -
From: "Scott Marlowe"
To: "whas...@gmail.com"
Cc: "Adrian Klaver" , "pgsql-general@postgresql.org"
Subject: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12
Date: Tue, Feb 12, 2013 3:27 pm
second line should be
sudo
Thank you @
Sent from my HTC
- Reply message -
From: "Scott Marlowe"
To: "whas...@gmail.com"
Cc: "Adrian Klaver" , "pgsql-general@postgresql.org"
Subject: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12
Date: Tue, Feb 12, 2013 3:27 pm
second line should be
sudo apt-get install
On 2/11/2013 11:26 PM, Scott Marlowe wrote:
./configure --prefix=/opt/postgres# or wherever you want pg to install
and depending on your application's requirements, you may want to enable
perl, python or whatever and whatever other optional stuff you may need..
--
john r pierce
second line should be
sudo apt-get install libreadline-dev
of course. unless you're logged in as root.
On Tue, Feb 12, 2013 at 12:26 AM, Scott Marlowe wrote:
> Not from a package. I don't think any recent distros have a repo with
> 8.0 in it, so you'll have to build from source. HOWEVER, bui
Not from a package. I don't think any recent distros have a repo with
8.0 in it, so you'll have to build from source. HOWEVER, building
from source is REAL easy with postgresql.
sudo apt-get install build-essential # ubuntu build tools
apt-get install libreadline-dev # used by pgsql to have an
I believe the software can work with any postgresql 8.0.* . It is possible to
install pg 8.0 in current release of linux?
Sent from my HTC
- Reply message -
From: "Scott Marlowe"
To: "Wan Hashim"
Cc: "Adrian Klaver" ,
Subject: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12
Date
On Mon, Feb 11, 2013 at 6:36 AM, Andrew Taylor wrote:
> Here's what I did to fix this in Ubuntu 12.10.
>
> Now I cannot explain (a) why this problem came into being or (b) what the
> science is behind my fix. This was my first dive into Linux logs and there
> being seemingly an array of ways logg
This may not be the best place to ask these questions and you could
have considered using postgres-xc-general mailing list from the
Postgres-XC project site. Anyways, see my comments below.
On Tue, Feb 12, 2013 at 11:06 AM, Zenaan Harkness wrote:
> Does somone know the object overlap likely betwe
Does somone know the object overlap likely between pg and pgxc repositories?
I ask because I could just git clone pgxc, or I could add a remote for
pgxc to my pg git clone, and make sure the branches are added, and
fetch that remote.
And in this way, common files/ objects are properly shared in on
On Mon, Feb 11, 2013 at 5:29 PM, Wan Hashim wrote:
> our legacy system required postgresql 8.0 to run. we are in the
> process of upgrading the application and database.
> we must have postgresql 8.8 to keep the system running at this moment .
> if possible , we want to run in Ubuntu 12. we can co
On 02/11/2013 06:59 PM, Scott Marlowe wrote:
Wait I think it was 8.2 wasn't it?
http://www.postgresql.org/docs/8.3/interactive/release-8-3.html
E.24.2.1. General
Non-character data types are no longer automatically cast to TEXT
(Peter, Tom)
Previously, if a non-character value was supplied
Scott Marlowe writes:
> The change from 8.0 to 8.1 that removed implicit casts broke a LOT of
> poorly written software.
That was 8.3, not 8.1.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Wait I think it was 8.2 wasn't it?
On Mon, Feb 11, 2013 at 7:58 PM, Tom Lane wrote:
> Scott Marlowe writes:
>> The change from 8.0 to 8.1 that removed implicit casts broke a LOT of
>> poorly written software.
>
> That was 8.3, not 8.1.
>
> regards, tom lane
--
To unde
The change from 8.0 to 8.1 that removed implicit casts broke a LOT of
poorly written software.
For OP: Install from source, if you don't need EXACTLY the old 8.0.5
version at least look at the bug fixed version 8.0.latest (28 or so?)
On Mon, Feb 11, 2013 at 6:17 PM, John R Pierce wrote:
> On 2/1
Hi,
On Mon, 2013-02-11 at 22:22 +, Gauthier, Dave wrote:
> Can PG V9.1* support a DB that's on an NFS disk?
http://www.postgresql.org/message-id/25517.1191038...@sss.pgh.pa.us
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışm
On Mon, Feb 11, 2013 at 5:22 PM, Gauthier, Dave wrote:
> Can PG V9.1* support a DB that's on an NFS disk?
>
> I googled around, but nothing popped out.
>
> Also, would you happen to know the answer to this for MySQL v5.5*?
>
> Thanks in Advance.
>
I've done this before, and I reall
On 2/11/2013 4:29 PM, Wan Hashim wrote:
our legacy system required postgresql 8.0 to run.
are you sure it requires this old version? most software works with
newer versions with little or no changes.
--
john r pierce 37N 122W
somewhere on the middle
On 02/11/2013 04:29 PM, Wan Hashim wrote:
our legacy system required postgresql 8.0 to run. we are in the
process of upgrading the application and database.
we must have postgresql 8.8 to keep the system running at this moment .
if possible , we want to run in Ubuntu 12. we can consider older
ver
our legacy system required postgresql 8.0 to run. we are in the
process of upgrading the application and database.
we must have postgresql 8.8 to keep the system running at this moment .
if possible , we want to run in Ubuntu 12. we can consider older
version of OS if it can help .
tq
On Tue, Feb
On 02/11/2013 03:40 PM, Wan Hashim wrote:
Hi all;
Im looking for in information and resources to setup postgresql 8.0.5
in Ubuntu server . tq
Is there a reason you want to install a version that is no longer supported?
Also I believe you mean Ubuntu 12.10, correct?
--
Adrian Klaver
ad
Hi all;
Im looking for in information and resources to setup postgresql 8.0.5
in Ubuntu server . tq
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 2/11/2013 11:17 AM, Daniel Verite wrote:
I happen to collect these messages in a database since mid-2005. As a point
of comparison, the numbers I get until today for pgsql-general are 3348
messages that appear to be outside of any thread (no "In-Reply-To" field or
"References" field that point
On 02/11/2013 08:18 AM, Carlo Stonebanks wrote:
I had seen that thread, and that's how I came in contact with L J Bayuk (the
person who owns the pgtclng sourceforge project and who answered the
questions) and followed his advice, which is how I came to create the 64 bit
build. I am still experien
On 02/11/2013 03:02 PM, Scott Marlowe wrote:
Welcome to the perception of the outsider. I am in infrequent poster here, but in my
6 years of doing PostgreSQL for Mac, I get 3-4 emails a week asking for help on
PostgreSQL issues that contain some variation of the phrase 'I posted to a Postgr
On Mon, Feb 11, 2013 at 12:35 PM, Andrew Satori wrote:
>
> On Feb 11, 2013, at 2:17 PM, "Daniel Verite" wrote:
>
>> Vincent Veyron wrote:
>>
>>> I find it strange that
>>>
>>> 'Probability that a new thread gets a response'
>>>
>>> sits below 60% for the 'general' list
>>
>> This seems inde
On 2/11/2013 4:22 PM, Gauthier, Dave wrote:
>
> Can PG V9.1* support a DB that's on an NFS disk?
>
> I googled around, but nothing popped out.
>
> Also, would you happen to know the answer to this for MySQL v5.5*?
>
> Thanks in Advance.
>
That would be (IMHO) very ill-advised. In the event of a d
Can PG V9.1* support a DB that's on an NFS disk?
I googled around, but nothing popped out.
Also, would you happen to know the answer to this for MySQL v5.5*?
Thanks in Advance.
Thank you, Tom!
Recently, as I wanted to drop a schema (PG 8.2), I had to wade through a
number of such messages and keep dropping rows in the pg_dependency table
with the OID specified in the messages. When I was finally able to drop the
schema, I wanted to drop the user (who previously owned the
What's the canonical way of doing this? Various failed attempts include:
select array_length(%%'a=>1'::hstore - 'a=>1'::hstore, 1)
select array_length(%%('a=>1'::hstore - 'a=>1'::hstore), 1)
select array_length(avals('a=>1'::hstore - 'a=>1'::hstore), 1);
select array_length(akeys('a=>1'::hst
On Feb 11, 2013, at 2:17 PM, "Daniel Verite" wrote:
> Vincent Veyron wrote:
>
>> I find it strange that
>>
>> 'Probability that a new thread gets a response'
>>
>> sits below 60% for the 'general' list
>
> This seems indeed too low.
>
> I happen to collect these messages in a databa
Vincent Veyron wrote:
> I find it strange that
>
> 'Probability that a new thread gets a response'
>
> sits below 60% for the 'general' list
This seems indeed too low.
I happen to collect these messages in a database since mid-2005. As a point
of comparison, the numbers I get until t
David Clymer wrote:
> The SERIALIZABLE isolation mode is being used in 9.0, and
> REPEATABLE READ in 9.2, which should be the same thing, correct
> (eg. 9.0 serializable ~ 9.2 repeatable read)?
Correct.
In 9.0 SERIALIZABLE and REPEATABLE READ are exactly same. In 9.1
and later REPEATABLE READ
2013/2/11 David Clymer
> On Mon, Feb 11, 2013 at 1:13 PM, David Clymer > wrote:
>
>> On Mon, Feb 11, 2013 at 12:47 PM, Pavel Stehule
>> wrote:
>>
>>> 2013/2/11 Tom Lane :
>>> > David Clymer writes:
>>> >> I've been seeing the following error in one database of ours:
>>> >> "cache lookup fail
On Mon, Feb 11, 2013 at 1:13 PM, David Clymer
wrote:
> On Mon, Feb 11, 2013 at 12:47 PM, Pavel Stehule
> wrote:
>
>> 2013/2/11 Tom Lane :
>> > David Clymer writes:
>> >> I've been seeing the following error in one database of ours:
>> >> "cache lookup failed for relation 7640518"
>> >
>> > Alw
On Mon, Feb 11, 2013 at 12:47 PM, Pavel Stehule wrote:
> 2013/2/11 Tom Lane :
> > David Clymer writes:
> >> I've been seeing the following error in one database of ours:
> >> "cache lookup failed for relation 7640518"
> >
> > Always the same OID, or does it change?
> >
> >> The SQL that apparen
On Mon, Feb 11, 2013 at 12:20 PM, Tom Lane wrote:
> David Clymer writes:
> > I've been seeing the following error in one database of ours:
> > "cache lookup failed for relation 7640518"
>
> Always the same OID, or does it change?
>
It appears that almost all instances reference a different OI
> I'm looking for some good visual query builder which can be used by
> non-tech people for some ETL tasks. Do you have any recommendation?
Libreoffice Base?
I know it has a visual query builder and it does support PostgreSQL, but
I have no clue what it is worth, since I tend to use SQL instead.
=?UTF-8?B?UMOpdGVyIEtvdsOhY3M=?= writes:
> I'm confused by the error message. Is a cache miss an error condition?
Well, this isn't a "cache miss", it's more of a "there's no such OID in
the pg_class catalog" condition. Normally you see something more
user-friendly; but in the case of going to re
2013/2/11 Tom Lane :
> David Clymer writes:
>> I've been seeing the following error in one database of ours:
>> "cache lookup failed for relation 7640518"
>
> Always the same OID, or does it change?
>
>> The SQL that apparently triggers this is:
>>drop table if exists ns_e5461ae570429d0b7863
I'm confused by the error message. Is a cache miss an error condition?
Thanks
Peter
On Feb 11, 2013 6:22 PM, "Tom Lane" wrote:
> David Clymer writes:
> > I've been seeing the following error in one database of ours:
> > "cache lookup failed for relation 7640518"
>
> Always the same OID, or do
David Clymer writes:
> I've been seeing the following error in one database of ours:
> "cache lookup failed for relation 7640518"
Always the same OID, or does it change?
> The SQL that apparently triggers this is:
>drop table if exists ns_e5461ae570429d0b7863cce9ef4d4ead;
> Unfortunately,
I've been seeing the following error in one database of ours:
"cache lookup failed for relation 7640518"
The SQL that apparently triggers this is:
drop table if exists ns_e5461ae570429d0b7863cce9ef4d4ead;
Unfortunately, manual attempts to reproduce the issue have failed. In
normal operatio
2013/2/11 Roger Niederland :
>
> On 2/11/2013 6:47 AM, Tom Lane wrote:
>>
>> Roger Niederland writes:
>>>
>>> I am getting the following error when trying to execute a plpgsql
>>> funtion:
>>> PSTERROR: could not load library "/usr/pgsql-9.2/lib/plpgsql.so":
>>> /usr/pgsql-9.2/lib/plpgsql.so: und
Le lundi 11 février 2013 à 17:20 +0100, Vincent Veyron a écrit :
> Le lundi 11 février 2013 à 08:03 -0600, Merlin Moncure a écrit :
> > http://citusdata.com/blog/57-postgresql-full-text-search
> >
>
> I find it strange that
>
> 'Probability that a new thread gets a response'
>
> sits below 60
Le lundi 11 février 2013 à 08:03 -0600, Merlin Moncure a écrit :
> http://citusdata.com/blog/57-postgresql-full-text-search
>
I find it strange that
'Probability that a new thread gets a response'
sits below 60% for the 'general' list
In my mailbox, which holds the last 2628 messages from th
I had seen that thread, and that's how I came in contact with L J Bayuk (the
person who owns the pgtclng sourceforge project and who answered the
questions) and followed his advice, which is how I came to create the 64 bit
build. I am still experiencing problems.
It's possible that I have missed s
On 2/11/2013 6:47 AM, Tom Lane wrote:
Roger Niederland writes:
I am getting the following error when trying to execute a plpgsql funtion:
PSTERROR: could not load library "/usr/pgsql-9.2/lib/plpgsql.so":
/usr/pgsql-9.2/lib/plpgsql.so: undefined symbol: SPI_plan_get_cached_plan
This is on a SL
Hi,
On Mon, 2013-02-11 at 09:47 -0500, Tom Lane wrote:
> > After restarting the postgres service, the error went away.
>
> So you had upgraded, but not actually restarted the server ...
> just for future reference, SLES apparently doesn't do a service
> restart automatically during package upgra
Roger Niederland writes:
> I am getting the following error when trying to execute a plpgsql funtion:
> PSTERROR: could not load library "/usr/pgsql-9.2/lib/plpgsql.so":
> /usr/pgsql-9.2/lib/plpgsql.so: undefined symbol: SPI_plan_get_cached_plan
> This is on a SL6.3 system running postgres 9.2
Merlin Moncure escribió:
> http://citusdata.com/blog/57-postgresql-full-text-search
http://www.postgresql.org/message-id/511164ef.8010...@dalibo.info
--
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-genera
On 02/11/2013 02:33 AM, P. Broennimann wrote:
Hi there
I have installed 9.2.2 on a Debian Squeeze VM.
I am trying to install a third party extension.
1) For the extension I did "make" & "make install".
2) I now see the extension files in
/usr/share/postgresql/9.2/extension/... (files .sql and
>
>
> I read it that he has multiple sales from the same person? In which case
> pretending that the two sales were from different people isn't the correct
> result at all.
Actually it turns out that both cases exist.
>
> I may be missing the point of the query, but wasn't it to add an entry for
On 11 February 2013 07:47, Alban Hertroys wrote:
> On Feb 11, 2013, at 2:23, Tim Uckun wrote:
>
> > This works pretty good except for when the top 100 records have
> > duplicated email address (two sales for the same email address).
> >
> > I am wondering what the best strategy is for dealing wi
Hi there
I have installed 9.2.2 on a Debian Squeeze VM.
I am trying to install a third party extension.
1) For the extension I did "make" & "make install".
2) I now see the extension files in /usr/share/postgresql/9.2/extension/...
(files .sql and .control)
3) When I issue CREATE EXTENSION ...
> The best strategy is fixing your data-model so that you have a unique key. As
> you found out already, e-mail addresses aren't very suitable as unique keys
> for people. For this particular case I'd suggest adding a surrogate key.
>
> Alternatively, you might try using (first_name, email) as yo
I am getting the following error when trying to execute a plpgsql funtion:
PSTERROR: could not load library "/usr/pgsql-9.2/lib/plpgsql.so":
/usr/pgsql-9.2/lib/plpgsql.so: undefined symbol: SPI_plan_get_cached_plan
This is on a SL6.3 system running postgres 9.2.2
We set this server up about
56 matches
Mail list logo
