On Mon, Aug 12, 2013 at 8:28 AM, David F. Skoll wrote:
>
> 3) Our current workload peaks at about 5000 transactions per second;
> you can assume about one-third to one-half of those are writes. Do
> you think we can get away with 16 10Krpm SATA drives instead of the
> SSDs?
>
pgbench peaks out a
On Wed, Jun 19, 2013 at 2:35 AM, Rural Hunter wrote:
> I really hate the error "permission denied for sequence x" when I
> grant on a table but forget to grant additionally on the related sequence
> to users. Can the permission of table and related sequences be merged?
>
You asked this quest
On Mon, May 20, 2013 at 3:57 PM, Kasia Tuszynska wrote:
> Hi Everybody,
>
> Has anyone ran into issues running pg_restore?
>
> It seems that between 8.3.8 and 9.0.5, 9.1.3 the behavior of pg_restore
> has changed.
>
> ** **
>
> Previously I was able to have several data owners with
On Thu, May 16, 2013 at 11:04 AM, Oscar Calderon <
ocalde...@solucionesaplicativas.com> wrote:
> Hi everybody, this is my first message in this list. The company where i
> work is bringing maintenance service of PostgreSQL to another company,
> and currently they have installed PostgreSQL 9.1.1, a
On Thu, May 9, 2013 at 5:01 PM, Miu, Monica wrote:
> Hi all,
>
> ** **
>
> My name is Monica Miu and I work in Talent Acquisition for Asurion Mobile
> Applications
>
>
>
Basically you just pissed everyone off that you're trying to recruit. This
is a highly technical discussion group, and po
Regarding top posting versus bottom posting, pretty almost everyone who has
commented agrees that top versus bottom posting isn't the problem. It's
laziness about editing, perhaps exacerbated by certain email systems that
encourage that laziness.
So how about this: instead of demanding "PLEASE DO
On Mon, May 6, 2013 at 11:25 AM, Szymon Guz wrote:
> On 6 May 2013 20:15, Craig James wrote:
>
>> Just out of curiousity, I see comments like this all the time:
>>
>> > (*please* stop top-posting).
>>
>
> We are reading from top to bottom. That's why
Just out of curiousity, I see comments like this all the time:
> (*please* stop top-posting).
I've been participating in newsgroups since UUCP days, and I've never
encountered a group before that encouraged bottom posting. Bottom posting
has traditionally been considered rude -- it forces reader
On Fri, Apr 19, 2013 at 5:12 PM, Rodrigo Barboza wrote:
> Hi guys.
> I created a database with default encoding (SQL_ASCII) and default collate
> (C).
> I created a table test like this:
> create table test (a varchar (10));
> Then i executed "insert into teste (a) values ('áéç&ã','Æ','ß');
>
> Af
Hmmm the subselect is invalid, but not rejected. The outer select
returns every row in the customer_order_matches table. This seems pretty
wrong. This is PG 9.2.1 running on Ubuntu.
db=> select count(1) from customer_order_matches where
customer_order_item_id in (select customer_order_item_
On Wed, Apr 10, 2013 at 4:59 PM, Armin Resch wrote:
> Not sure this is the right list to vent about this but here you go:
>
> I) select regexp_replace('BEFORE.AFTER','(.*)\..*','\1','g') "Substring"
> II) select regexp_replace('BEFORE.AFTER','(.*)\\..*','\\1','g') "Substring"
>
> Executing (II) a
On Thu, Mar 28, 2013 at 10:56 PM, Rural Hunter wrote:
> Hi,
>
> I encounter the same issue often: Granted update/insert to an user but
> forgot to grant it on the related sequence. It's hard to understand that an
> user has write access on table but not on necessary sequences. I think the
> grant
On Thu, Mar 28, 2013 at 10:51 AM, Marc Fromm wrote:
> Is there a way to create a select statement that will select a record if
> the exact term is found in a field that contains the text to describe
> something?
>
> ** **
>
> If I create a select statement using WHERE description LIKE ‘art’
On Thu, Feb 14, 2013 at 11:09 AM, Campbell, Lance wrote:
> PostgreSQL 9.2
>
> When creating a table or altering a column of a table, is there a way to
> add notes on a column?
>
> ** **
>
> If not:
>
> I have a new enhancement request. When creating a table or altering a
> column, it
ponsibility for the
potential data corruption that their policy will cause. Vendors that work
with Postgres need to understand that "minor releases" won't break their
applications, and that they should encourage their customers to keep their
Postgres software up to date.
If, on the oth
tunity to upgrade to a new version of
Postgres, although that might require changes to your app that you're not
willing to make. Even if you don't upgrade the version (you should at
least upgrade to the latest 8.4.x release), dump/restore will fix your
problem.
Craig James
On Wed, Nov 21, 2012 at 1:21 AM, Gnanakumar wrote:
> Hi,
>
> Our application requirement demands archiving of records, so that
> performance/speed of the application is not compromised. So, am looking
> out/evaluating on various techniques/solutions available for database
> archiving, in general
On Thu, Nov 15, 2012 at 1:32 AM, Lukasz Brodziak
wrote:
> 2012/11/15 Craig Ringer
> > Another option would be to monitor syslog or the csvlog and lock the
> > user out by changing their password or revoking CONNECT rights if they
> > trip the threshold. It wouldn't be as responsive to high-rate b
On Thu, Oct 18, 2012 at 2:54 PM, Tom Lane wrote:
> Craig James writes:
> > I installed 9.2 on our new server and am seeing something odd that
> doesn't
> > happen in 8.4:
>
> > postgres=# select datname, pid, usename, query from pg_stat_activity
> where
> &
I installed 9.2 on our new server and am seeing something odd that doesn't
happen in 8.4:
postgres=# select datname, pid, usename, query from pg_stat_activity where
query != '';
datname | pid | usename |
query
+---+--+-
On Wed, Oct 10, 2012 at 10:08 PM, Craig Ringer wrote:
> On 10/11/2012 02:22 AM, Craig James wrote:
>
>> I have a C-language function I've been using on 8.4 for a long time. On
>> 9.2 it won't load:
>>
>> test=# set search_path = public;
>
I have a C-language function I've been using on 8.4 for a long time. On
9.2 it won't load:
test=# set search_path = public;
SET
test=# CREATE OR REPLACE FUNCTION chmoogle_session_id() RETURNS integer
AS '/usr/local/pgsql/lib/libchmoogle.so', 'chmoogle_session_id'
LANGUAGE c VOLATILE;
ERROR: coul
Is it OK to mix 9.2.x and 8.4.x clients and servers? Can they talk to each
other? In other words, if I install 9.2 on a new server alongside older
servers running 8.4.x, can clients on the 8.4 systems talk to 9.2 servers,
and can the 9.2 clients talk to 8.4 servers?
Thanks,
Craig
On Wed, Oct 3, 2012 at 10:58 AM, Babay Adi, Hava wrote:
> Thanks Craig for the useful information.
>
> ** **
>
> On the same regard – Some of the mentioned modules in the mentioned
> application use a set of tables which is logically separate (there are no
> join statements with tables of ot
On Tue, Oct 2, 2012 at 11:54 AM, Babay Adi, Hava wrote:
> Dear list,
>
> ** **
>
> I’m new to PostgreSQL, planning now a migration to PostgreSQL and would
> appreciate your help.
>
> ** **
>
> One aspect of the migration is re-thinking our DB structure.
>
> ** **
>
> The application
On Thu, Sep 27, 2012 at 2:23 AM, Gary Stainburn
wrote:
> Hi folks.
>
> I'm planning on extending a field in one of my main tables using:
>
> alter table stock alter column type varchar(255);
Why not just do
alter table stock alter column type text;
That is, do you really need a limit? The
On Thu, Sep 20, 2012 at 7:56 PM, Haifeng Liu wrote:
>
> On Sep 20, 2012, at 10:34 PM, Craig James wrote:
>
>
>
> On Thu, Sep 20, 2012 at 1:55 AM, Haifeng Liu wrote:
>
>> I want to write a hash function which acts as String.hashCode() in java:
>> hash = has
On Thu, Sep 20, 2012 at 1:55 AM, Haifeng Liu wrote:
> I want to write a hash function which acts as String.hashCode() in java:
> hash = hash * 31 + s.charAt(i)... but I got integer out of range error. How
> can I avoid this? I saw java do not care overflow of int, it just make the
> result negati
On Mon, Sep 10, 2012 at 10:17 AM, Antoine Guidi wrote:
> Another question, when I get a reply from the list, to which email
> should I then reply?
> To all? the User posting, or pgsql-admin@?
>
Either reply-to-all or reply to the pgsql-admin address. Either way,
everyone gets it who participated
On Sat, Sep 8, 2012 at 1:26 PM, Sergey Konoplev wrote:
> On Fri, Sep 7, 2012 at 3:20 AM, Bruce Momjian wrote:
>> On Thu, Sep 6, 2012 at 05:55:05PM -0500, Antoine Guidi wrote:
>>> Is it possible to do a pg_upgrade from 9.1.2 to 9.1.5 just using pg_upgrade?
>>> For what I could read, the only exce
On Tue, Sep 4, 2012 at 9:48 PM, Sergey Konoplev wrote:
> On Tue, Sep 4, 2012 at 8:35 PM, Craig James wrote:
>> Can anyone recommend a good tool for producing a good drawing of an existing
>> database schema? I don't need a design tool, but rather one that can take
>&
On Wed, Sep 5, 2012 at 2:21 AM, Mathias Breuninger
> I wasn't aware of the binary problem with replication.
> Maybe the PostgreSQL docs should emphasize the architecture restriction.
That's sort of what "binary file" means -- a raw,
architecture-specific representation of data that's optimized for
Can anyone recommend a good tool for producing a good drawing of an
existing database schema? I don't need a design tool, but rather one that
can take an existing schema and produce a nice diagram that can be further
edited and "beautified." I want something I can print and hang on the wall
as a
On Fri, Aug 24, 2012 at 7:08 AM, Kevin Grittner
wrote:
> CS DBA wrote:
>
>> I've fired up 2 CentOS 6.2 VM's via vmware fusion 5 (on a mac).
>
>> psql -h 192.168.91.145
>> psql: could not connect to server: No route to host
>
> That problem has nothing to do with PostgreSQL; you might have
> bette
On Fri, Aug 10, 2012 at 7:19 AM, Tom Lane wrote:
> Haifeng Liu writes:
> > I have a program running like a daemon, which analyze data and write to
> postgresql 9.1 on centos 5.8. There is only one connection between my
> program and the postgresql database, and I hope the connection may keep
> a
On Mon, Jul 30, 2012 at 4:06 AM, Amit Kumar wrote:
> All,
>
> I am facing a weired issue in PG 9.0.3. Sometime via application UPDATES
> are not changing data in the database but in postgres logs its also not
> raising any error. It is happening 2-3 times in a week. I have tried but
> not able t
On Wed, Jul 11, 2012 at 10:47 AM, Arnold, Sandra wrote:
> Tablelog would be ok for keeping up with transactions for tables.
> However, we also need to audit who connects successfully and
> unsuccessfully. As far as I am aware, if a user fails to log in
> successfully, say three times, PostgreSQ
On Wed, May 30, 2012 at 8:14 AM, Igor Shmain wrote:
> Thank you, Liu, for your suggestion.
>
> ** **
>
> I might be missing something (I am new to postgres), but it seems that
> your suggestion will not help much in my case. Since the number of db
> requests will grow with time (more users
I recently recompiled our Postgres extension functions and re-encountered a
problem that I thought was solved. When I call our function, the code just
hangs ... it sit there not executing, not using any CPU cycles. Forever.
The process is still running, but seems to be waiting for ... what?
I or
On Wed, Feb 1, 2012 at 3:27 PM, wrote:
> Hello,
>
> So I am not very advanced in SQL, and after a week of wild SQL
> experimenting have finally reduced my thought process to a complete blank
> on this query...
>
> I have a list of organizations in table:organization and a one to many
> list of o
2012/1/17 Mindaugas Žakšauskas
> On Tue, Jan 17, 2012 at 7:23 PM, Tom Lane wrote:
> > <..> Mindaugas, are you using SSL,
> > and if so can you turn it off and see whether things change?
> > (It should be safe to do so at least on the "localhost" connection,
> > even if you feel your network is
On 12/21/11 12:34 PM, Elliot Voris wrote:
Hi, everyone
I've got 32,404 rows of data in a staging table (marcxml_import) that I'm
trying to get into my production table (biblio.record_entry) in my database
(evergreen). When trying to do so, I'm getting the following error:
evergreen=# INSERT
On 12/19/11 10:04 AM, Mario Splivalo wrote:
I need to have postgres role to be able to cancel queries run by that
same role.
I know that I can kill the client connection that started the query, but
I also need to have that role connect to postgres and kill some of it's
running queries.
It's on
On 11/29/11 10:36 AM, Scott Marlowe wrote:
On Tue, Nov 29, 2011 at 11:15 AM, Craig James
wrote:
Several times recently one of our databases has gotten stuck with the
following situation:
postgres=# select datname, procpid, usename, current_query from
pg_stat_activity where current_query
Several times recently one of our databases has gotten stuck with the
following situation:
postgres=# select datname, procpid, usename, current_query from
pg_stat_activity where current_query != '';
datname | procpid | usename |
current_query
+-+--+
On 10/24/11 3:10 PM, Krishnamurthy Radhakrishnan wrote:
Hi,
I am new to PostgreSQL. We are using PostgreSQL 9.0.2 on our linux server. We
have an instance of PostgreSQL 9.0 running using the primary partition on the
server.
We want to use the pg_dump and psql programs to migrate the data duri
On 8/19/11 1:40 AM, Marko Kreen wrote:
On Fri, Aug 19, 2011 at 2:44 AM, Craig James wrote:
We had to temporarily assign two IP addresses to our servers. After doing
so and rebooting, Londiste will start, but it just sits there doing nothing.
The logfile has zero bytes, and it doesn't
On 8/19/11 1:40 AM, Marko Kreen wrote:
On Fri, Aug 19, 2011 at 2:44 AM, Craig James wrote:
We had to temporarily assign two IP addresses to our servers. After doing
so and rebooting, Londiste will start, but it just sits there doing nothing.
The logfile has zero bytes, and it doesn't
We had to temporarily assign two IP addresses to our servers. After doing so
and rebooting, Londiste will start, but it just sits there doing nothing. The
logfile has zero bytes, and it doesn't seem to connect to either the master or
the slave database.
We reconfigured Postgres to listen on
On 8/16/11 10:24 AM, Chris Travers wrote:
I can't let this slide :-D
On Tue, Aug 16, 2011 at 9:27 AM, Evan Rempel wrote:
Technically it can be done, but just because we can do something does not
mean we should do something. Having said that...
We have been using a middleware product that shal
On 8/7/11 10:30 AM, antismarmy wrote:
Hello community,
I need to execute pgsql2shp from the command line, but I am not interested
in the other functionalities offered by postgresql on this machine. I have
been told that installing an instance of a spatial database on the machine
in question just
On 8/7/11 10:30 AM, antismarmy wrote:
Hello community,
I need to execute pgsql2shp from the command line, but I am not interested
in the other functionalities offered by postgresql on this machine. I have
been told that installing an instance of a spatial database on the machine
in question just
On 6/17/11 11:51 AM, Shianmiin wrote:
Tom Lane-2 wrote:
What's not apparent however is why the stats collector is writing disk
so much. 8.4 does have the logic change to not write stats out unless
something is asking to see them. So either it's really pre-8.4, or you
have a monitoring task tha
On 6/14/11 1:42 PM, Tim wrote:
So I ran this test:
unzip -p text.docx word/document.xml | perl -p -e 's/<.+?>/\n/g;s/[^a-z0-9\n]/\n/ig;'|grep
".." > text.txt
ls -hal ./text.*
#-rwxrwxrwx 1 postgres postgres 15M 2011-06-14 15:12 ./text.docx
#-rwxrwxrwx 1 postgres postgres 29M 2011-06-14 15:17 ./t
On 6/8/11 12:39 PM, Maria L. Wilson wrote:
Interested in using Londiste to set up replication of only one column in a
particular database to another database on a remote Postgres server. I've
installed and configured londiste on the servers - that was no problem. I just
don't see anything in
On 5/21/11 8:11 AM, Tom Lane wrote:
Craig James writes:
On 5/20/11 4:25 PM, Scott Marlowe wrote:
On Fri, May 20, 2011 at 3:14 PM, Craig James
wrote:
Our development server (PG 8.4.4 on Ubuntu server) is constantly doing
something, and I can't figure out what. The two production se
On 5/20/11 4:25 PM, Scott Marlowe wrote:
On Fri, May 20, 2011 at 3:14 PM, Craig James wrote:
Our development server (PG 8.4.4 on Ubuntu server) is constantly doing
something, and I can't figure out what. The two production servers, which
are essentially identical, don't show thes
On 5/20/11 3:38 PM, Joshua D. Drake wrote:
The other two servers are configured identically. If I diff the
configuration files, the only difference is the IP addresses for the
"listen" section.
Can anyone tell me what's going on? Why is pgstat.stat being rewritten
on this server constantly and
Our development server (PG 8.4.4 on Ubuntu server) is constantly doing
something, and I can't figure out what. The two production servers, which are
essentially identical, don't show these symptoms. In a nutshell, it's showing
10K blocks per second of data going out, all the time, and essenti
On 4/22/11 8:17 PM, Tom Lane wrote:
Craig James writes:
On 4/22/11 1:58 PM, Tom Lane wrote:
Craig James writes:
select objectid from archive where db_id is null limit 1 for update
The interaction between LIMIT and FOR UPDATE changed in 9.0 ... what
PG version are you using?
8.4.4
Well
On 4/22/11 1:58 PM, Tom Lane wrote:
Craig James writes:
select objectid from archive where db_id is null limit 1 for update
The interaction between LIMIT and FOR UPDATE changed in 9.0 ... what
PG version are you using?
8.4.4
thanks,
Craig
regards, tom lane
I thought I understood "select ... for update," but maybe not.
We have a number of separate databases and a unique integer identifier that's supposed to
be global across all databases. A single "archive" database is used to issue
the next available ID when a process wants to create a new objec
On 4/9/11 9:24 AM, H S wrote:
Dear Sirs,
I would like to include SELINUX MLS to my postgres DBMS,
I have just install mls package on my fedora 14 and mcstrans
But after relabelling my whole file system, I do not have any graphical user
interface , and must login to my system in text mode (
On Thu, Jan 20, 2011 at 10:42 AM, Bradley Holbrook
wrote:
Thanks Scott... a couple comments.
Our developers never decide what goes to where... they just happily
plumb away on the development db until we're ready to take
our product
to testing (at regular intervals), once QA is passed, we
wi
Josh wrote:
I am looking for suggestions on how best to secure a server that
is accessible via the internet. Even account creation for the
database is open to the world. Does anybody have any extra changes
they would make to postgresql.conf or OS changes they would
suggest? Perhaps some default
On 12/11/10 7:47 PM, David Underhill wrote:
I have two tables. One has a foreign key referencing a serial
field in the other table. I've given INSERT privilege to a role
other than the owner, but I still can't insert into the table
containing the foreign key unless I grant the /owner/ of the
On 12/1/10 7:54 AM, Kevin Grittner wrote:
"Lello, Nick" wrote:
What is considered the best filesystem to use for postgres data
stores ?
I held off for a bit to see if someone else would jump in with a
comparison of filesystems, but so far nobody has taken the bait.
The reason I held off is t
On 11/22/10 10:42 AM, James Cloos wrote:
"TL" == Tom Lane writes:
TL> It *is* configurable: make pg_xlog a symlink.
I notice that everyone suggests using a symlink, but I never see anyone
suggest just mounting a filesystem there.
Is there a (technical) reason for that? Or is a symlink just
On 11/15/10 11:42 AM, Chris Ruprecht wrote:
I was wondering if there is a way to pre-allocate tablespace on disk before
adding data and indexes.
My understanding is:
PG writes data into files sequentially. If more space is needed, disk space
is requested from the OS and if there is space, the OS
On 10/14/10 3:59 AM, Sebastien wrote:
Hello!
I'm writting to get some clues about PostgreSQL administration, and more
precisely SSL connection from one server to another with certificate
identification. I must underline than I'm new to postgreSQL and server
administration.
Here is the story:
On 10/5/10 11:08 AM, Dinesh Bhandary wrote:
Hi All,
Is there an easy way to restore to a new table where the column name have been
changed but data remains the same?
For example I am trying to restore from existing system, table1(col1) to
table1(col2) and it is erroring out on the new column n
On 10/4/10 10:36 AM, Lou Picciano wrote:
(Think I've seen the answer to this already, but:) is there any 'innate', or
'default' session timeout function built in to PG?
We have certain clients who seem to timeout pretty frequently, while
others seem to never time out at all; before we start di
oes
wrong and the transaction is rolled back. But given what you have told us
about your application, it is probably not very important if a few ORDER ID
numbers are missing.
Craig
On Thu, Sep 16, 2010 at 4:06 PM, Craig James mailto:craig_ja...@emolecules.com>> wrote:
On 9/16/
On 9/16/10 3:54 PM, Aras Angelo wrote:
Hello All
I have a column in my table which is incrementally updated.
Try to give us more details...
Does the column need have contiguous values or are "gaps" ok? That is, does it
have to be 1,2,3,4,...,N-1,N or is it ok to have something like 1,3,4,7,
On 9/7/10 12:06 PM, Jesper Krogh wrote:
On 2010-09-07 20:42, Scott Marlowe wrote:
With the right supplier, you can plug in literally 100 hard drives to
a regular server with DAS and for a fraction of the cost of a SAN.
Ok, recently I have compared prices a NexSan SASBeast with 42 15K SAS drives
On 8/27/10 10:09 AM, Lukasz Brodziak wrote:
What do You mean by history table? Creating such table is out of the question.
You asked for "actual versions of row data" and a "data change history." How
can you expect to get a history without the history being stored somewhere? The previous ans
On 8/27/10 9:48 AM, £ukasz Brodziak wrote:
I'm looking for actual versions of row data. What I want to achieve as a final
result is a kind of data change history.
What about a before-update trigger and an history table?
Craig
> Date: Fri, 27 Aug 2010 08:25:26 -0500
> From: kevin.gritt...@
On 8/9/10 5:14 PM, Bruce Momjian wrote:
ENGEMANN, DAYSE wrote:
Hi Kevin,
Sorry to disturb you.. But I am really new in it...
Let me see if I understood...
pg_dump -h sourcemachine -U sourceuser source_dbname | psql target_dbname
Has anyone done any measurement of whether it is faster to do
On 8/5/10 12:58 PM, Mark Steben wrote:
I would like to set up a facility that enforces password changes for roles
After a predefined period (30 days for instance) when logging into psql
Or, at the very least, send an email out to notify that your current
Password period is about to expire. Prefe
On 7/30/10 10:37 AM, Kevin Grittner wrote:
Craig James wrote:
Well, the "if it ain't broke, don't fix it" rule might come into
play here.
I should have given one more detail here: We've been the victim
of persistent "CPU spikes" that were discussed extens
On 7/30/10 8:57 AM, Kevin Grittner wrote:
Craig James wrote:
We create a bunch of high-performance lightweight Postgres clients
that serve up images (via mod_perl and Apache::DBI). We have
roughly ten web sites, with ten mod_perl instances each, so we
always have around 100 Postgres backends
I have a question that may be related to connection pooling.
We create a bunch of high-performance lightweight Postgres clients that serve
up images (via mod_perl and Apache::DBI). We have roughly ten web sites, with
ten mod_perl instances each, so we always have around 100 Postgres backends
On 7/27/10 3:37 AM, Lazarin Toni wrote:
I am Oracle DBA and i will be maybe work on a project where postgresql
database will be used.
So i would be greatful if you could please advise me on the folowing :
· Estimated time for postgresql latest RDBMS software instalation and
configuration (does
On 7/16/10 3:31 PM, Patric Michael wrote:
Hi all...
I joined this list in an effort to solve a puzzle I fail to understand.
Thank you in advance for taking the time to read.
I've been managing a domain for the last eight years as an erstwhile
administrator. Erstwhile meaning it is largely a ma
Kris,
[Replying to list, too.]
On 7/16/10 10:14 AM, Kris Deugau wrote:
Craig James wrote:
This isn't exactly a Postgres question, but I hope someone in the
community has solved it.
I want to encrypt some data in Postgres that arrives from Apache. How
do you store an encryption key in s
This isn't exactly a Postgres question, but I hope someone in the community has
solved it.
I want to encrypt some data in Postgres that arrives from Apache. How do you
store an encryption key in such a way that Apache CGIs can get it, but a hacker
or rogue employee who manages to access the m
On 7/15/10 2:14 PM, Tom Lane wrote:
Craig James writes:
On 8.3.10 and earlier, Postgres would ONLY load this library if we put it in
/usr/local/pgsql/lib, so I figured it was a security restriction, that Postgres
altered the LD_LIBRARY_PATH to ensure that only legitimate, admin-approved
On 7/15/10 12:52 PM, Tom Lane wrote:
Craig James writes:
On the Postgres 8.3 system, I simply put libopenbabel.so into the
/usr/local/pgsql/lib directory, and everything worked well. On 8.4, I can't
seem to get it to load libopenbabel.so. Other programs that use this library
ha
I'm migrating from Postgres 8.3.10 to 8.4.4, and also from Fedora 9 to Ubuntu
10.04.
On 8.3.10, I have a C extension that worked on 8.3, but now refuses to load on
8.4:
CREATE OR REPLACE FUNCTION chmoogle_session_id() RETURNS integer
AS '/usr/local/pgsql/lib/libchmoogle.so', 'chmoogle_session_
89 matches
Mail list logo
