Hello all,
I know that I am WAY behind the times here, but I am just now getting to
upgrade to 8.3. As I was reading through all of the installations I
realized that in order to install postgis now, you have to use the
Application Stack Builder and that this application has to access the
-Original Message-
You can grab the installer manually from
http://pgfoundry.org/frs/?group_id=1000256release_id=1266 and copy
that around in whatever way you need.
Thanks Dave! I will do that. I just wasn't sure if installing outside
of Application Stack Builder was going to cause
I should be looking at
(especially if not in the list above) that I should be changing to get
this full vacuum to perform?
Thanks in advance,
Lee Keel
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Lee Keel [EMAIL PROTECTED] writes:
I have 15 or so databases that I am deleting all the data in them and
re-importing on a nightly basis. (Long story here, but basically I
found using the copy command was the fastest way
your free space map settings
[Lee Keel]
What if the page file exceeds the shared_buffers, but you can't increase the
shared buffers to a larger amount? For example, page file is set to be
between 500MB and 10GB, but you can't set the shared_buffers to more than
1200MB. If set to 1300MB or higher
.
//Magnus
[Lee Keel]
I can't do any benchmarks because I keep getting errors. But I have dropped
this value down and I am not getting the out of memory errors any more. I
was trying to solve other problems by bumping this way up but it seemed to
just cause more problems. I found several
column's datatypes do not
match
[Lee Keel]
Would this not have to do with the 'order by' you added to the end of the
statement? If you remove the order by clause, then it works for me...
-LK
This email and any files transmitted with it are confidential and intended
solely for the use
-Original Message-
From: Merlin Moncure [mailto:[EMAIL PROTECTED]
Sent: Monday, October 15, 2007 8:22 PM
To: Lee Keel
Cc: Scott Marlowe; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Convert bytea to Float8
This is sounding more and more like a question for the postgis
from cnt for 8)::float8;
The error that I get is:
ERROR: 42846: cannot cast type bytea to double precision
I have also tried get_byte, but that seems to only be returning the single
byte and not all 8bytes for the float. Thanks in advance.
Lee Keel
This email and any files transmitted
I am sorry to push this issue, but I have clients waiting on a solution for
this. So, does the lack of response mean that I am going to have to find
another approach? Or can this conversion be done in ppgsql\perl?
Thanks in advance,
Lee Keel
_
From: [EMAIL PROTECTED]
[mailto
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Monday, October 15, 2007 3:54 PM
To: Lee Keel
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Convert bytea to Float8
Does something like:
select encode('12346758'::bytea,'escape')::float
work
-Original Message-
From: Merlin Moncure [mailto:[EMAIL PROTECTED]
Sent: Monday, October 15, 2007 3:26 PM
To: Lee Keel
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Convert bytea to Float8
On 10/15/07, Lee Keel [EMAIL PROTECTED] wrote:
I am sorry to push this issue
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Friday, August 24, 2007 10:09 AM
To: Lee Keel
Cc: Josh Trutwin; pgsql-general@postgresql.org
Subject: Re: [GENERAL] [OT - sorta] How to extract a substring using Regex
Woah! That is great. Now to find
Is there no way to do this without doing an insert into another table?
_
From: paddy carroll [mailto:[EMAIL PROTECTED]
Sent: Monday, July 30, 2007 3:24 PM
To: Lee Keel
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] tables not in list
put all your tables in a new table
-Original Message-
From: Viatcheslav Kalinin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 31, 2007 9:16 AM
To: Lee Keel
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] tables not in list
I usually resolve this as:
-- this function lets you select from an array
CREATE
Hi List,
I have a list of table names and I am trying to confirm that they are all in
my postgres db. But what I want returned is a list/array of ones that are
in my list but not in the db. So for example:
CREATE TABLE test
(
somecol integer
) WITHOUT OIDS;
CREATE TABLE bar
(
barcol
costly is, but I find
it very reasonable for the time it saves me. It does do Postgres and MANY
more database formats. You can find more information at
http://www.datanamic.com/dezign/index.html
Regards,
Lee Keel
This email and any files transmitted with it are confidential and intended
solely
to only the rows that end in 2 digits as well as
return those digits for you.
Hope that helps,
Lee Keel
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you have received this email in error
The first thing you have to do is disable the User Access Control.
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of dfx
Sent: Thursday, June 21, 2007 12:58 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to install
Thanks to everyone for their input on this. After reading all the emails
and some of the documentation (section 23.3), I think this is all a little
more than what I need. My database is basically read-only and all I was
looking to do is to be able to take snap-shots of it and be able to restore
Keel
Cc: Michael Nolan; Ron Johnson; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Large Database Restore
Lee Keel wrote:
Thanks to everyone for their input on this. After reading all the emails
and some of the documentation (section 23.3), I think this is all a little
more than what I need
I am restoring a 51GB backup file that has been running for almost 26 hours.
There have been no errors and things are still working. I have turned fsync
off, but that still did not speed things up. Can anyone provide me with the
optimal settings for restoring a large database?
Thanks in
22 matches
Mail list logo