Thanks. I checked and hard links are not supported by the NAS.
Will look into getting another disk.
Yes, should upgrade out of 8.3.
Thanks again.
Claire
On Mon, 18 Feb 2013 08:21:19 -0800 Magnus Hagander
<mag...@hagander.net> wrote
On Fri, Feb 15, 2013 at 6:25 PM,
Hi there,
We recently copied over our 8.3 database cluster files from a local disk to a
network attached storage drive.
Everything seemed to work okay for a while until we got this error:
ERROR: could not link file "pg_xlog/000100AA0030" to
"pg_xlog/000100AA0096"
lpgsql' because postgis needs it. Then again the dump
fails as it tries to createlang plpgsql again.
Would appreciate any pointers. This is with Postgresql 7.4.8 and
Postgis 1.1.2
Claire
--
Claire McLister[EMAIL PROTECTED]
1684 Nightingale Avenue Suit
Thanks. I'll look into this next time it happens.
For now, I tried the create index commands again, and they worked in
a split-second. So, it must have been the lock contention, and not
the VACUUM'ng.
On Jul 21, 2006, at 6:45 AM, Tom Lane wrote:
Claire McLister <[EMAIL PROTE
Yes, that could be the case. We have a python function that imports
CSV files, which can take a long time, and that may have been running
during that time. I didn't look at the pg_lock file. What should I be
looking for?
On Jul 20, 2006, at 3:13 PM, Tom Lane wrote:
Claire McL
No, this is a brand new index, so no drops.
On Jul 20, 2006, at 2:03 PM, Ian Harding wrote:
On 7/20/06, Claire McLister <[EMAIL PROTECTED]> wrote:
Hi,
We have a couple of tables (40,000 and 600,000 rows each) that I am
trying to build an index on an integer column.
When I iss
C the PSQL command for create index, it shouldn't cause a
problem, right?
On Jul 20, 2006, at 1:48 PM, Will Glynn wrote:
On Jul 20, 2006, at 4:11 PM, Claire McLister wrote:
Hi,
We have a couple of tables (40,000 and 600,000 rows each) that I
am trying to build an index on an inte
t mode.
Will appreciate any suggestions.
Thanks
Claire
--
Claire McLister[EMAIL PROTECTED]
1684 Nightingale Avenue Suite 201
Sunnyvale, CA 94087408-733-2737(fax)
http://www.zeemaps.com
---(end of broadcast)-
any element in that array ?
i want to perform some dml operations about each one like (delete,
update or delete)
can anyone show me the example or tell me the function name i
should use ..
regards
--
Thanks. So, the hack we did is okay then? Does using the substring
function de-TOAST it?
On Feb 4, 2006, at 11:24 AM, Tom Lane wrote:
Claire McLister <[EMAIL PROTECTED]> writes:
This was all working fine until E.Value became some large strings
with some occasional funny characters.
wrote:
Read the FAQ.
--
-
Claire McLister wrote:
Hi,
I'm using a pgsql function that begins by creating a temporary
table, does some processing, and then drops the temporary table just
before exiting. It has bee
This is for Postgresql version 7.4.8
Can someone tell me what I'm doing wrong? Should I try to use 'ON
COMMIT DROP' instead?
Thanks
Claire
--
Claire McLister[EMAIL PROTECTED]
1684 Nightingale Avenue Suite 201
Sunnyvale, CA 94087408-
nd
if we can do that.
Claire
On Jan 12, 2006, at 10:23 AM, Tom Lane wrote:
Claire McLister <[EMAIL PROTECTED]> writes:
We have a database with a bunch of large objects, who's ids we
reference in a table. There is a trigger associated with inserts and
updates on the table to dele
Has anyone seen this behavior before? Am I doing something wrong?
Is there a workaround for this?
Thanks for your help.
Claire
PS. The dump command was pg_dump --b -Ft -o db > db.tar
Restore command: pg_restore -O -d db db.tar
--
Claire McLister[EMAIL P
Developer means postgresql developer (contributes code to postresql
code base), otherwise the person is a 'User'.
I've changed the legend to say 'PG Developer' to make this clearer.
Let me know if you have alternate legend title suggestions.
On Dec 7, 2005, at 1:46 PM, Reid Thompson wrote:
can add more knobs on how to get the coordinates.
Best, Arnulf.
Arnulf Christl wrote:
Claire McLister wrote:
Good point. This might actually be a problem. Google Maps API
requires
each server that is serving the map to be registered with
Google, and
send the corresponding key when making
n end users with too much data.
(I've noticed large numbers of points tend to do that)
Robert Treat
On Tue, 2005-10-25 at 12:11, Claire McLister wrote:
Thanks.
I looked at the Mapserver maps, and at first glance it seems Google
Maps API provides better map images and more interactive features
Hi Joshua,
No, you should not need a plugin. Can you open the Firefox Javascript
console and see if you get errors in Javascript? The mapping relies
heavily on Javascript and sometimes that gives errors. I just tried it
on Firefox 1.0 and it showed up okay.
Let me know if the problem persi
Thanks.
I looked at the Mapserver maps, and at first glance it seems Google
Maps API provides better map images and more interactive features
(zooming, panning, JS popups, satellite/map views, etc.)
So, what would be the advantage of Mapserver apart from it being based
on Open Source?
We u
,
Pretty neat: I'm glad I'm not on that map!
Regards,
Arthur
On 10/24/05, Claire McLister <[EMAIL PROTECTED]> wrote:
Hi,
We've developed an automatic email mapping capability from Google
Maps
API.
To try it out, we mapped origins of emails to this group from
Oct
p=456
Would like to hear what you think of it.
Best wishes
Claire
--
Claire McLister [EMAIL PROTECTED]
1684 Nightingale Avenue Suite 201
Sunnyvale, CA 94087 408-733-2737(fax)
http://www.zeesource.net
---(e
21 matches
Mail list logo
