[GENERAL] GiST or GIN, I feel like I am doing something wrong

'SELECT content FROM profile_images_fulltext'); count 241071 (1 row) CREATE INDEX profile_images_fulltext_gin ON profile_images_fulltext USING gin(content); CREATE INDEX profile_images_fulltext_gist ON profile_images_fulltext USING gist(content); Any and all thoughts would be greatl

Re: [GENERAL] GiST or GIN, I feel like I am doing something wrong

Tom, Our maintenance_work_mem is 1024MB so there should have been plenty of memory for INDEX creation. I happened to be watching top when we created the GiN INDEX and the process used about 500MB of non-shared memory. Aaron Thul http://www.chasingnuts.com On Wed, Jun 17, 2009 at 11:30 AM

Re: [GENERAL] What filesystem to use for postgres?

Some more current numbers can be found here: http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide Aaron Thul http://www.chasingnuts.com On Tue, Sep 14, 2010 at 4:00 AM, A B wrote: > Hello. > > Is there any doc or wiki page that describes what filesystems that are > r

Re: [GENERAL] Storing questionnaire data

You may want to look at this article for some ideas: http://www.varlena.com/GeneralBits/110.php The article talks about doing dynamic schema design for online surveys... it's pretty interesting. Aaron Thul http://www.chasingnuts.com On Wed, Oct 22, 2008 at 10:59 AM, Thom Brown &l

Re: [GENERAL] Storage location of temporary files

I too have used a symlink for some time (years) to put temp onto dedicated disks without any problems. I am not sure if 8.3 is different but I symlink the directory: base/pgsql_tmp Aaron Thul http://www.chasingnuts.com On Fri, Oct 31, 2008 at 8:11 AM, Sam Mason <[EMAIL PROTECTED]>

Re: [GENERAL] Creation of tablespaces

Ubuntu never shipped with selinux, it is available by installing the "selinux" meta-package. Ubuntu does ship with AppArmor and loaded by default in Hardy 8.04 and beyond but I don't believe there are any PotgreSQL profiles. Aaron Thul http://www.chasingnuts.com On Fri, Jan 15

[GENERAL] Connect RDF to PostgreSQL?

only interface to the open source jena technology, which fails to scale to larger data sets as it tries to read huge chunks of data into memory. We would prefer to go with an open source option, but can't. Do you know of a software package that can efficiently connect RDF to PostgreSQL?"

Re: [GENERAL] Questions of the privileges to use the pg_cancel_backend and pg_terminate_backend function. Thanks.

Using the security definer Think if is like sudo for a db. Aaron Thul http://www.chasingnuts.com On Wed, Apr 4, 2012 at 8:39 AM, leaf_yxj wrote: > Hi Guys. I got one problem. I need to give some of the non-super users( kind > of dba) to get the privileges > to can cancel other users

[GENERAL] iSCSI SAN Suggestions

anyone like to suggest other options? Has anyone had any problems with those vendors? Anyone like to share a glowing review or success story? Aaron Thul http://www.chasingnuts.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] Unable to read data from the transport connection.

I am attempting to connect to a PostgreSQL database via C# or VB.net using the Npgsql .Net data provider, but I get the following error when I attempt to open the connection: *** An unhandled exception of type 'System.IO.IOException' occurred in npgsql.dll Additional information: Unable to

[GENERAL] web hosting postgres

Hi, Can anyone out there point me to an inexpensive web hosting solution that offers postgres database support??? Thanks Aaron ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] web hosting postgres

HI, how much storage space etc. Thanks Aaron On Wed, 2003-09-03 at 02:44, Richard Welty wrote: > On 03 Sep 2003 00:26:04 +0300 Aaron <[EMAIL PROTECTED]> wrote: > > Can anyone out there point me to an inexpensive web hosting solution > > that offers postgres database support??

[GENERAL] Upgrading hot standbys

correctly? Thanking you in advance, Aaron dunnhumby limited is a limited company registered in England and Wales with registered number 02388853 and VAT registered number 927 5871 83. Our registered office is at Aurora House, 71-75 Uxbridge Road, London W5 5SL. The contents of this messa

[GENERAL] Why is this query not using GIN index?

onfig, (title)::text) @@ '''abc'' | ''def'''::tsquery) Rows Removed by Filter: 10221 Planning time: 0.176 ms Execution time: 75.564 ms (6 rows) Any ideas? -- Best Regards, Aaron Lewis - PGP: 0x13714D33 - http://pgp.mit.edu/ Finger Print

[GENERAL] Trigram is slow when 10m rows

ws) Any ideas to speed things up? -- Best Regards, Aaron Lewis - PGP: 0x13714D33 - http://pgp.mit.edu/ Finger Print: 9F67 391B B770 8FF6 99DC D92D 87F6 2602 1371 4D33 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Trigram is slow when 10m rows

lanning time: 1.168 ms Execution time: 1755.944 ms On Sun, Nov 13, 2016 at 10:04 PM, Oleg Bartunov wrote: > > > On Sun, Nov 13, 2016 at 2:54 PM, Aaron Lewis > wrote: >> >> I have a simple table with Trigram index, >> >> create table mytable(hash char(4

Re: [GENERAL] Why is this query not using GIN index?

Hi Oleg, Can you elaborate on the title column? I don't get it. On Sun, Nov 13, 2016 at 10:10 PM, Oleg Bartunov wrote: > > > On Sun, Nov 13, 2016 at 2:50 PM, Aaron Lewis > wrote: >> >> I have a simple table, and a gin index, >> >> create table

Re: [GENERAL] Why is this query not using GIN index?

x27;'::tsquery) Planning time: 0.144 ms Execution time: 537.212 ms (9 rows) On Sun, Nov 13, 2016 at 10:33 PM, Julien Rouhaud wrote: > On 13/11/2016 15:26, Aaron Lewis wrote: >> Hi Oleg, >> >> Can you elaborate on the title column? I don't get it. >> > >&

Re: [GENERAL] Why is this query not using GIN index?

m running PG 9.6.1, built from source. On Mon, Nov 14, 2016 at 2:51 AM, Tom Lane wrote: > Oleg Bartunov writes: >> On Sun, Nov 13, 2016 at 6:05 PM, Aaron Lewis >>> It takes 500ms with 10m rows, could it be faster? > >> sure. Recheck with function call is pretty exp

[GENERAL] Designing tables based on user input and defined values

nal because table Final is supposed to serve as a lookup or reference table (I am not sure of the correct terminology). Please advise if I am on the right track or if I should follow a different design. I intend to have a few other lookup/reference tables that will serve a similar purpose. Tha

Re: [GENERAL] Designing tables based on user input and defined values

Hi Adrian, Thank you for responding with the SQL code. However, outcome cannot be a primary key because outcome values will be duplicates in some instances. I am not sure how else to have a lookup table that stores static values. Thanks! Aaron On Sat, Feb 27, 2016 at 5:15 PM, Adrian Klaver

Re: [GENERAL] Designing tables based on user input and defined values

f goal and size which will be foreign keyed to table User. How exactly does the user submit/store his goal/size and be assigned an outcome if the User table is using FKs for goal/size? It seems backwards to me. On Feb 27, 2016 7:04 PM, "Adrian Klaver" wrote: > On 02/27/2016 03:12

Re: [GENERAL] Designing tables based on user input and defined values

On Sun, Feb 28, 2016 at 12:36 AM, Adrian Klaver wrote: > On 02/27/2016 09:19 PM, Aaron Christensen wrote: > >> There is somewhat a method to this madness :). There isn't a formula >> that determines outcome. They will just be arbitrary values that I >> assign. &g

Re: [GENERAL] Designing tables based on user input and defined values

On Sun, Feb 28, 2016 at 1:15 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Sat, Feb 27, 2016 at 10:36 PM, Adrian Klaver > wrote: > >> On 02/27/2016 09:19 PM, Aaron Christensen wrote: >> >>> There is somewhat a method to this madness

Re: [GENERAL] How can I avoid PGPool as a single point of failure?

On Jan 29, 2008 6:30 PM, Chander Ganesan <[EMAIL PROTECTED]> wrote: > > > Is it possible to point two servers running PGPool at the same two > > database servers? If so, I seem to recall reading about being able to > > use some kind of virtual IP address to split the traffic to both. > CARP...I've

Re: [GENERAL] Why are stored procedures looked on so negatively?

al mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general> > -- ** Aaron Abreu, Systems Consultant Bay District Schools, Panama City, FL Office

Re: [GENERAL] In the belly of the beast (MySQLCon)

On Thu, Apr 17, 2008 at 11:29 AM, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > Hello, > > I am currently chilling at MySQLCon. If any other Elephant riders who > are doing a little Dolphin hunting are about... I am in Ballroom E > about to give a talk on what Mysql can learn from PostgreSQL. is

Re: [GENERAL] [lapug] LAPUG Social - Tuesday Evening July 14

Depending on the details, I'd love to attend. Any more specifics, by chance? On 7/11/09, Richard Broersma wrote: > Josh Berkus and David Fetter will be in West Los Angeles area the > beginning of next week. This would be a good opportunity to get > together to enjoy dinner and drinks with Postg

[GENERAL] Question About Serializable

The documentation states that "concurrent execution of a set of Serializable transactions is guaranteed to produce the same effect as running them one at a time in some order." I'm not sure how the following behavior fits that definition. (Note that this is just an experiment, not a use case. Pure

Re: [GENERAL] Question About Serializable

No particular effort; I saw a talk on the topic. I said it's academic because I can't think of any real world example where this would matter (the other definition of the word "academic"). On Thu, Sep 19, 2013 at 12:44 AM, Kevin Grittner wrote: > Aaron Carlisle wrote:

[GENERAL] question on writing a function

function? I hope that¹s clear. Thanking you in advance for any help. Aaron The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error you should delete it from your system immediately and advise the sender

[GENERAL] Some insight on the proper SQL would be appreciated

Greetings, I hope this is the proper list for this, but I am a loss on how to achieve one particular set of results. I have a table which is a list of users who entered a contest. They can enter as many times as they want, but only 5 will count. So some users have one entry, some have as many as

[GENERAL] Assistance with SQL

Hi, I¹m hoping someone can help me out on this one. Two tables table1 has 25 columns table2 is a subset of table1 (create table2 as select id,field1,field2,field3,field4,field5,field6 from table1) with just 7 columns There is a primary key on ID table2 was exported to a CSV, truncated, then th

Re: [GENERAL] Assistance with SQL

Thank you. I was making it way too over-complicated. Works perfectly On 9/1/08 3:39 AM, "hubert depesz lubaczewski" <[EMAIL PROTECTED]> wrote: > On Sun, Aug 31, 2008 at 11:31:32PM -0400, Aaron Burnett wrote: >> table1 has 25 columns >> table2 is a subset of

[GENERAL] large inserts and fsync

restart fsync once the insert is complete. Am I opening myself up to any dangers that aren¹t obvious by doing this? Any advice to the contrary? And of course, if I am out of my mind for doing this, please let me know. Thanks in advance Aaron

Re: [GENERAL] large inserts and fsync

Yes, the developer already made sure of that and I verified. On 9/5/08 11:10 AM, "Sam Mason" <[EMAIL PROTECTED]> wrote: > On Fri, Sep 05, 2008 at 09:16:41AM -0400, Aaron Burnett wrote: >> For an upcoming release there is a 16 million row insert that on our test >>

Re: [GENERAL] large inserts and fsync

--Original Message- From: Greg Smith [mailto:[EMAIL PROTECTED] Sent: Sat 9/6/2008 4:45 AM To: Tom Lane Cc: Aaron Burnett; Sam Mason; pgsql-general@postgresql.org Subject: Re: [GENERAL] large inserts and fsync On Fri, 5 Sep 2008, Tom Lane wrote: > The trouble with turning fsync off is that a

Re: [GENERAL] Updating column on row update

this is how I do it if this helps: column_name timestamp without time zone NOT NULL DEFAULT ('now'::text)::timestamp(6) without time zone -Original Message- From: pgsql-general-ow...@postgresql.org on behalf of Thom Brown Sent: Sun 11/22/2009 2:50 PM To: PGSQL Mailing List Subject: [G

[GENERAL] Pg 9.1.3 pg_crypto question

rkMRWpnnbjaFoHyLmCD/bg== (1 row) 9.1.3# select decrypt_iv(decode('rkMRWpnnbjaFoHyLmCD/bg==', 'base64'), decode('bcRJvbqeWMPDXMtIP8pPOQ==', 'base64'), '', 'aes-cbc'); decrypt_iv -- \x48656c6c6f205468657265 (1 row) Thanking you in advance, Aaron -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Pg 9.1.3 pg_crypto question

Thanks, Tom. That was exactly it. Best Regards On 4/10/12 2:50 PM, "Tom Lane" wrote: >Aaron Burnett writes: >> 9.1.3 is just not decrypting nor throwing errors. > >> 9.1.3# select decrypt_iv(decode('rkMRWpnnbjaFoHyLmCD/bg==', 'base64'

[GENERAL] odd intermittent query hanging issue

Greetings, I run a handful of queries overnight when traffic is at it's lowest on our system. One particular query will run perfectly fine (around 5 seconds) for several weeks, then suddenly decide to hang indefinitely and never finish. It needs to be killed manually after several hours (I've int

Re: [GENERAL] odd intermittent query hanging issue

Thanks Steve, Answers are inserted below: On 5/18/12 11:09 AM, "Steve Crawford" wrote: >On 05/18/2012 09:17 AM, Aaron Burnett wrote: >> Greetings, >> >> I run a handful of queries overnight when traffic is at it's lowest on >>our >> system. One

[GENERAL] getting elapsed query times

Hi, I think I am experiencing the "forest through the trees" type of scenario here. In a nightly cron I have a shell script that executes a couple of things for our data warehouse. I call it like this from the cron: /home/postgres/DB1/sys/createDB1.sh >> /home/postgres/DB1/logs/createDB1.log 2

[GENERAL] question on viewing dependencies

: BEGIN; drop table table_foo CASCADE; DROP TABLE ROLLBACK; Am I overlooking a step to actually seeing the dependant objects? Thanking you in advance, Aaron -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] question on viewing dependencies

Thanks Tom, It was not supressed for notice, so I changed it to 'debug1' and it gave me the answers I was looking for. On 2/22/09 6:07 PM, "Tom Lane" wrote: > Aaron Burnett writes: >> Hopefully a quick answer. Went to drop a table: > >> drop table t

[GENERAL] postmaster never finishes starting up, silent to boot

Greetings, I've gotten myself in a pickle and had a postgresql (8.2) instance fill its disk completely and shutdown itself down. I've moved the entire data directory to a new, larger slice however postmaster never finishes "starting". Despite configuring postgresql.conf for excessive 'verboseness'

Re: [GENERAL] postmaster never finishes starting up, silent to boot

ut itself down -- if there is one? apologies for the admittedly amateur questions but I haven't been able to find much for the situation I'm in. thanks, aaron - Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] custom stemming in full text search

ce they are meaningless search terms. Is there an easy way to accomplish this? I read through the text search sections of the documentation and this website: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/custom-dict.html Is there an easier way? Thanks in advance. -- Aaron Pat

Re: [GENERAL] PostgreSQL as a filesystem

On 4/18/05, Christopher Nelson <[EMAIL PROTECTED]> wrote: > > This isn't a high-priority question. > and if I can latch on to this non-priority question with another in a similar vain: what sort of RDBMS do huge transactional systems like Tandy's use? I've read that everything is a database, s

[GENERAL] Strange interaction of union and expressions

; "woof" (2 rows) Is this a known issue? Has it been fixed? Thanks, -- Aaron Bingham Software Engineer Cenix BioScience GmbH ---(end of broadcast)---

Re: [GENERAL] Strange interaction of union and expressions

Kevin Murphy <[EMAIL PROTECTED]> writes: > On Apr 20, 2005, at 1:24 PM, Aaron Bingham wrote: >> create table a (foo varchar); >> insert into a (foo) values ('baz'); >> create table b (foo varchar); >> insert into b (foo) values ('woof'); >&

Re: [GENERAL] remote tcp connection problem PG 8.0.1

i'm having the same problem running pg8.0.1 on redhat enterprise linux AS 3 (2.4.21-27.0.4.ELsmp). shutting off my firewall via 'service iptables stop' solves the problem... what needs to be modified in the iptables to allow remote pg connections? Richard Huxton wrote: Michael Korotun wrote: H

[GENERAL] inherit with foreign key reference

"pagesrc" !--! thoughts? thanks, aaron ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[GENERAL] oids and pg_class_oid_index constraint violations

oes it seem reasonable that oid reuse could cause the constraint violations? Does it seem likely that this would fix the problem? Is there an easier way to solve the problem? Thanks in advance -- Aaron Harsh [EMAIL PROTECTED] 503-284-7581 x347 ---(end of broadca

Re: [GENERAL] oids and pg_class_oid_index constraint

> Tom Lane <[EMAIL PROTECTED]> 08/03/05 1:33 PM >>> > "Aaron Harsh" <[EMAIL PROTECTED]> writes: > > We've just recently started seeing sporadic constraint violations on system > > tables. For example: > > duplicate key violates unique

[GENERAL] License question

. Aaron ---(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

Re: [GENERAL] License question[VASCL:A1077160A86]

On 10/4/05, Richmond Dyes <[EMAIL PROTECTED]> wrote: > From my understanding of the license for Postgresql, there is no > licensing fees as long as you are not selling it yourself for a profit. Completely incorrect. You can do whatever you like with PostgreSQL; you just can't sue anyone when thin

Re: [GENERAL] License question

we were completely sunk until we moved everything over to .Net. Thanks again! Aaron ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] License question[VASCL:A1077160A86]

On 10/4/05, Welty, Richard <[EMAIL PROTECTED]> wrote: > Aaron Glenn wrote: > >Completely incorrect. You can do whatever you like with PostgreSQL; > >you just can't sue anyone when things go south. > > _and_ you need to preserve the cop

Re: [GENERAL] PostgreSQL on Slash Dot

On 10/5/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Check it out. > http://developers.slashdot.org/developers/05/10/05/1344254.shtml?tid=221&tid=218 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

Re: [GENERAL] pg_dump with low priority?

On 10/24/05, CSN <[EMAIL PROTECTED]> wrote: > > nice comes to mind: > > nice pg_dump ... > as mentioned earlier...nice isn't going to do anything for I/O. PITR (point in time recovery) would be, in my opinion, the best solution to this problem. aaron.glenn ---(end of broa

[GENERAL] lo_import()

hi, i would like to use lo_import() on the client side to insert images into postgresql version 8.0.1 on a remote server using psql as follows: psql -h my.db.host.com -U user -c "insert into binblob (binary_blob) values(lo_import('/path/on/client/machine/ks.jpg'))" -d mydb i'm getting the

Re: [GENERAL] [Fwd: Sun backs open-source database PostgreSQL | Topic: "everything" | ZDNet News Alerts]

> > *Sun backs open-source database PostgreSQL* > This is going to make PostgreSQL a much easier sell to PHB's (at least, in my experience) aaron.glenn ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Experiences with 3PAR

I'm curious if anyone on the list has any hands on performance experience with running PostgreSQL on 3PAR appliances (big and small). If you do, please contact me offlist - I'll be happy to summarize for the list archives. Thanks, Aaron ---(end of

Re: [GENERAL] sql formatter/beautifier

n SQL beautifier? I wasn't able to find a reference to this feature in the documentation. Thanks, -- ---- Aaron Bingham Senior Software Engineer Cenix BioSc

Re: [GENERAL] [ADMIN] Kill a Long Running Query

ql.org/pgsql-hackers-win32/2004-12/msg00039.php -- ====== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ==

[GENERAL] Need software infrastructure advice

Note: The meat and potatoes of my request is in the "What I would like" section. Everything else is just explanation. Currently my company is using software that really isn't meeting our needs. We have tried to get the 3rd party to allow us to help with their source, but they won't allow us to h

Re: [GENERAL] clustering

Google "slony" Regards, aaron.glenn On Thu, 14 Oct 2004 10:29:11 +0530, Nageshwar Rao <[EMAIL PROTECTED]> wrote: > > > > Hi, > > We would like use Postgresql as our database. For high availability is it > possible to cluster DB in Postgresql. Appreciate if you can let me know how > this c

Re: [GENERAL] download postgreql problem

On Tue, 19 Oct 2004 16:24:06 -0400, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Internet explorer. > That would be your problem right there. IE's handling of FTP sessions is notoriously quirky. Do yourself a favor and download a shareware FTP program, or open up a DOS prompt. Regards, a

[GENERAL] Free PostgreSQL Training, Philadelphia, Oct 30

ning Registration is required, and space is limited. The location is Malvern, PA (suburb of Philadelphia) and it's on Saturday Oct 30. For more information or to register, see http://chariotsolutions.com/postgresql.jsp Thanks, Aaron P.S. If you're planning to take the train (from Ph

[GENERAL] warning: pg_query(): Query failed

l.last_comment_timestamp DESC LIMIT 1 OFFSET 0 in /Library/WebServer/Documents/dmap/includes/database.pgsql.inc on line 121. any ideas? here's my system: - drupal v4.5.1 - mac os x server v10.3.5 - postgresql v7.4.2 - php v4.3.6 thanks, aaron ---(end of broadcast)

Re: [GENERAL] warning: pg_query(): Query failed

hi bruno, would it be useful to see the IF PLSQL function, or would you recommend a modification to the database.pgsql.inc file? On Jan 5, 2005, at 10:52 AM, Bruno Wolff III wrote: On Wed, Jan 05, 2005 at 10:17:39 -0800, Aaron Steele <[EMAIL PROTECTED]> wrote: hi, warning: pg_query():

Re: [GENERAL] warning: pg_query(): Query failed

hi steven, here's another file where the actual SQL query (the one in the error message) is defined. it's in the forum_get_forums() function. bruno noticed that the IF (via pl/pgsql) might not like the boolean casting to "2" since 7.4 is more strict about casting? does this help? /** * @file

Re: [GENERAL] warning: pg_query(): Query failed

hi bruno, turns out that l.last_comment_uid and l.last_comment_name are integer and char var respectively. since i'm using 7.4.1 with strict boolean casting, is there a better alternative to instantiating a different version of pgsql on my server? In the php code you showed the following fragme

[GENERAL] warning: pg_query(): Query failed

.uid AND n.nid = l.nid AND " . node_access_where_sql() . ' ORDER BY l.last_comment_timestamp DESC', $forum->tid, 0, 1)); thanks for all the support! aaron On Jan 6, 2005, at 10:25 PM, Bruno Wolff III wrote: On Thu, Jan 06, 2005 at 17:32:30 -0800, Aaron Steele <[EMAIL PROTECTED]> wrote:

[GENERAL] Database "template1" does not exist in the system catalog.

wing: # ./pg_filedump data-corrupt/base/1/1259 (See results below) Am I headed in the right direction? Any chance of recovering some/all of the data? Thanks, Aaron * * PostgreSQL File/Block Formatted Dump Utility - Version 1.1

[GENERAL] Database "template1" does not exist in the system catalog

he ordinary. Can't say that I know what I was looking for, though. Any ideas on what I can try to potentially fix this problem and/or recover any of this data? Thanks, Aaron _ Express yourself instantly with MSN

Re: [GENERAL] Database "template1" does not exist in the system catalog.

Unfortunately, I can't seem to connect to any other database. I only had one non-system database so I tried that, and that I was thinking there was a template0, so I tried that as well. Thanks in advance for any help you can provide! Aaron From: Tom Lane <[EMAIL PROTECTED]> To:

Re: [GENERAL] Duplicate counting

nt_price(retail, discount) AS price, tax FROM foo) AS bar; -- ---- Aaron Bingham Application Developer Cenix BioScience GmbH ---(end of bro

Re: [GENERAL] What talk would get you to go to OSCon?

On Tue, 8 Feb 2005 14:29:08 -0500, Robert Treat <[EMAIL PROTECTED]> wrote: > Slony Yes. > High Availability Yes. > If you have other ideas please feel free to chime in, we'd really like to see > an uptick in postgresql attendees. Will Bruce and Tom be attending this year like they did in 2002?

Re: [GENERAL] is there any way of specifying "i want x GB of space to be avaialble for my database"

If you are using a Linux system then you can make a partition of xGB and place PGDATA there. This may work for other OS as well.   Aaron  On 12/5/05, surabhi.ahuja <[EMAIL PROTECTED]> wrote:  here is a question   say i have a database and all the files(data files) indexes etc must be go

Re: [GENERAL] Multi-row update w. plpgsql function

This might be easier to use this SQL: UPDATE message_table SET status = 'A' WHERE mid IN (1,2,3); The following might work for Cocoon (never used it): UPDATE message_table SET status = 'A' WHERE mid IN (); Aaron On 12/13/05, Daniel Hertz <[EMAIL PROTECTED]

Re: [GENERAL] Best Data type for Binary Data?

BYTEA is the easiest from my point of view. I like being able to treat my binary data more like any other field (e.g. date, text, etc). Heres some light reading on the BLOB/BYTEA debate:   http://search.postgresql.org/www.search?cs=utf-8&fm=on&st=20&dt=back&q=blob+bytea AaronOn 1/5/06, Ketema Harr

Re: [GENERAL] Adding another primary key to a populated table

Are you trying to create a primary key composed of 6 fields? What is the result you want to achieve with the constraint? If you just want UNIQUE, NOT NULL values in a field, you can achieve that without creating a primary key. AaronOn 1/5/06, Daniel Kunkel <[EMAIL PROTECTED]> wrote: HiIt makes sen

[GENERAL] Allowing Custom Fields

required me to know what the field names were to generate the final query anyway, so they don't really gain me anything. Thanks, Aaron C. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

Re: [GENERAL] Allowing Custom Fields

Bruno Wolff III wrote: On Fri, Jan 27, 2006 at 10:25:00 -0600, Aaron Colflesh <[EMAIL PROTECTED]> wrote: #2 would seem to be the simplest except I'm really not too keen on the idea of manipulating a table like that on the fly (even though I did proof of concept it a

[GENERAL] address matching and verification

I have two large databases of addresses (street name and number, postal code and municipality).  I need to match the addresses to varify that they actually do exist.  has anyone done this before with pgAdmin?   Sincerely,   Aaron Griffin GIS Data Acquisition Technician   DMTI Spatial Inc

[GENERAL] [Slightly OT] data model books/resources?

Anyone care to share the great books, articles, manifestos, notes, leaflets, etc on data modelling they've come across? Ideally I'd like to find a great college level book on data models, but I haven't come across one that even slightly holds "definitive resource"-type status. Feel free to reply o

Re: [GENERAL] how to document database

with the 'comment on' statement. It can also generate graphical representations of your schema using various tools, including Graphviz. Regards, -- ---- Aaron Bingham Senior Software Engineer Cenix BioScience GmbH Tatzberg 47

[GENERAL] Meaning of "loops" in EXPLAIN ANALYSE output

is causing the execution time to balloon. Thanks, -- ---- Aaron Bingham Senior Software Engineer Cenix BioScience GmbH ---(e

[GENERAL] plpgsql replication stored procedure

in select slaveid from replicationslaves loop insert into replicationentries values(default, slaves.slaveid, TG_OP, TG_RELNAME , NEW.oid, default); end loop; return NULL; end;$$ language 'plpgsql'; Aaron ---(end of broadcast)

Re: [GENERAL] Having problems with a 25 million row table on 8.1.3

try: select tax_code from warehouse.sec_trans group by tax_code there was a discussion about this on the pgsql-performance a while back: http://archives.postgresql.org/pgsql-performance/2004-10/msg00053.php -ae On Apr 25, 2006, at 4:10 PM, Tony Caduto wrote: select DISTINCT tax_code from war

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully implementing

of these but you have to be careful to avoid them, and sometimes you can't). One feature of RM PostgreSQL lacks are nested relations (a bad idea for base table design but useful in query results). Regards, -- ---- Aaron Bing

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully implementing

David Fetter wrote: On Fri, Jun 09, 2006 at 03:55:04PM +0200, Aaron Bingham wrote: [EMAIL PROTECTED] wrote: I'm reading, and enjoying immensely, Fabial Pascal's book "Practical Issues in Database Management." If you're interested in the theory of R

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully implementing

Aaron Bingham wrote: David Fetter wrote: In SQL, you can do this (this example condensed from Libkin's "Expressive Power of SQL" on the page above): SELECT (SELECT count(*) FROM table_1) < (SELECT count(*) FROM table_2) AS "Can't compare cardinalities

Re: [GENERAL] Exporting data from view

27;kill -9' the postmaster-- +----|  Aaron Koning|  Information Technologist|  Prince George, BC, Canada. +|  http://datashare.gis.unbc.ca/fist/|  http://datashare.gis.unbc.ca/gctp-js/ +

Re: [GENERAL] Exporting data from view

CREATE TABLE sometable AS SELECT * FROM someview; pg_dump -t sometable dbname DROP TABLE sometable Que? Si!On 6/20/06, Worky Workerson <[EMAIL PROTECTED]> wrote: On 6/20/06, Aaron Koning <[EMAIL PROTECTED]> wrote:> google pg_dumpReally?  What command do you use? 

Re: [GENERAL] Exporting data from view

copyable, importable... into Excel or another postgres db?On 6/20/06, Martijn van Oosterhout <kleptog@svana.org > wrote:On Tue, Jun 20, 2006 at 10:29:21AM -0700, Aaron Koning wrote:> CREATE TABLE sometable AS SELECT * FROM someview; > pg_dump -t sometable dbname> DROP TABLE sometab

Re: [GENERAL] join on next row

sorry to nitpick, but I think that to get this query to do exactly what you want you'll need to add ordering over EventTime on your sub- selects to assure that you get the next event and not just some event later event on the given day. -ae On Jun 20, 2006, at 11:12 AM, Gurjeet Singh wrot

Re: [GENERAL] Database corruption with Postgre 7.4.2 on FreeBSD 6.1?

On 7/26/06, aurora <[EMAIL PROTECTED]> wrote: From your experience do you expect the database would run into this from time to time that requires DBA's interventions? Is so it would become a problem for our customers because our product is a standalone system. We don't intend to expose the Postg

  1   2   >