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
lt;mag...@hagander.netgt; wrote
On Fri, Feb 15, 2013 at 6:25 PM, Claire
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
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 Suite 201
Sunnyvale, CA 94087
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 McLister [EMAIL
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 PROTECTED] writes
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)---
TIP 6
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 integer column
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 issue the create
or delete)
can anyone show me the example or tell me the function name i
should use ..
regards
--
-
There is no e-mail anymore .. There is Gmail :)
--
Claire McLister
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 been working fine
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
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-733-2737(fax)
http
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 PROTECTED
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 delete the old value when
:
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 the Javascript request.
Unless the mirrors can each send their own keys
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:
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
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
(zooming, panning, JS popups, satellite/map views
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
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
---(end
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
October
2, 2005 2 pm (EST) through October 14th, 9 am (EST
21 matches
Mail list logo