-Original Message-
>> You can grab the installer manually from
>> http://pgfoundry.org/frs/?group_id=1000256&release_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
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
inter
>-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
h settings 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
> you are, you're seeing something new, and we definitely need to find out
> why.
>
>
> //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 mo
gt;
>
> ---(end of broadcast)---
> TIP 5: don't forget to increase 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 examp
---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>choose an index scan if your joining column's datatypes do not
>match
[Lee Keel]
Would this not have to do with the 'order by'
> -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 m
> -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]>
> -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(
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
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 with it
> -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
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Josh Trutwin
> Sent: Friday, August 24, 2007 7:58 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] [OT - sorta] How to extract a substring using Regex
>
> On Fri, 24 Aug 200
> -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 le
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
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 inte
-(end of broadcast)---
> TIP 2: Don't 'kill -9' the postmaster
We are currently using DeZign for Database. This is not a freeware tool,
but is VERY useful. I am not sure how much "not so costly" is, but I find
it very reasonable for th
ield8) from E'\\d{2}$') from TABLENAME
where texticregexeq(trim(both ' ' from field8), E'\\d{2}$')
This will limit the query 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 w
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 Post
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 th
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
o
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 advan
23 matches
Mail list logo
