Re: [GENERAL] Cannot restart postgresql when increasing max_connections

Joshua D. Drake spaketh: > On Thu, 2009-01-08 at 12:51 -0700, Gregory Williamson wrote: > > Thom Brown wrote: > > <...> > > > I actually mentioned pgPool II to my boss earlier, and it's > > something we > > > will have to seriously con

Re: [GENERAL] Cannot restart postgresql when increasing max_connections

Thom Brown wrote: <...> > I actually mentioned pgPool II to my boss earlier, and it's something we > will have to seriously consider, but will have to do some research first. We had an application ported from Informix which initially required 1000+ connections to handle peak load (one of 4 server

Re: [GENERAL] create table as vs. create table like

Andreas K. wrote: > > In response to Ivan Sergio Borgonovo : > > I just noticed something I found "unexpected". > > > > CREATE TABLE LIKE let you specify DEFAULT and Co. > > CREATE TABLE AS doesn't. > > > > Is there a one step way to clone a table? > > with or without data? > > create table ne

Re: [GENERAL] serial

The esteemed Scott Marlowe said: > > On Thu, Dec 4, 2008 at 7:42 AM, Gustavo Rosso <[EMAIL PROTECTED]> wrote: > > I created this table: > > <...> > > Because MySQL taught you bad habits? You told the db to insert a 0, > so it inserted a 0. With respect, sir, let me point out that Informix us

Re: [GENERAL] Postgres mail list traffic over time

Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> So, to a first approximation, the PG list traffic has been constant > >> since 2000. Not the result I expected. > > > I also was confused by its flatness. I am finding the email traffic > > almost impossible to

Re: Obfuscated stored procedures (was Re: [GENERAL] Oracle and Postgresql)

Nice trick ... thanks! > One big reason why nothing hasn't been done is that there is a decent > 'low tech' obfuscation tactic already: remove select access from > pg_proc to the user accounts in question and 'public'. This will > essentially disable casual browsing of procedure code from user >

Re: [GENERAL] Postgresql not using an index

Marc -- > Hi, > > I'm using postgres 7.4 and bacula 1.38 on debian. > > In the bacula database there is a table named 'file' which has about 2.5 > million rows. > In this table there is a field 'jobid' which is indexed. > The index is created with the following command: > CREATE INDEX fil

Re: [GENERAL] storing latitude and longitude

Top posting because of a challenged reader ... try for packages and documentation. Greg Williamson Senior DBA DigitalGlobe Inc -Original Message- From: [EMAIL PROTECTED] on behalf of Brent Wood Sent: Thu 7/10/2008 3:16 PM To: [EMAIL PROTECTED]; pgsql-g

Re: [GENERAL] Need to update all entries of one table based on an earlier backup

Thomas Pundt wrote: > > On Freitag, 20. Juni 2008, Gregory Williamson wrote: <...snip...> > Does > > update foo >set foo.foo_name2 = foo_old.foo_name2 > from foo_old > where foo.foo_id = foo_old.foo_id; > > work for you? Thanks to all for pointin

[GENERAL] Need to update all entries of one table based on an earlier backup

For reasons best left unmentioned, I need to update entries in a table from a backup; I need to do all entries. For reasons eluding my sleep deprived eyes this fails in every variation I can think of: update foo set foo.foo_name2=foo_old.foo_name2 where foo.foo_id = foo_old.foo_id; ERROR: mis

Re: [GENERAL] Importing undelimited files (Flat Files or Fixed-Length records)

Bill Thoen asked: > > I've got to load some large fixed-legnth ASCII records into PG and I was > wondering how this is done. The Copy command looks like it works only > with delimited files, and I would hate to have to convert these files to > INSERT-type SQL to run them through psql.. Is ther

Re: [GENERAL] Script errors on run

Try doing what was suggested ? Greg Williamson Senior DBA DigitalGlobe Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information and must be protected in accordance with those

Re: [GENERAL] Open Source CRM - Options?

> > > What do you mean whan you say "Don't top post??? > > http://en.wikipedia.org/wiki/Posting_style In-line comments are more readable, especially for longish emails. The PosgreSQL mail lists all prefer this method. Some related lists (the postGis list for instance) have a preponderance of t

Re: [GENERAL] Vacuuming on heavily changed databases

Sorry for top-posting -- challenged reader, but less challenged than running 8.2.0 -- upgrade to latest release -- 8.2.7! There were many fixes after the initial release and you're risking some bad mojo. Greg Williamson Senior DBA DigitalGlobe Confidentiality Notice: This e-mail message, includ

Re: [GENERAL] Survey: renaming/removing script binaries (createdb, createuser...)

Dawid wrote: [...] > > > abbreviations in cases where there's some overlap in characters: > > > > pgc cluster > [...] > > Agree, except I would prefer "pg" instead of "pgc". > No can do, already taken: "> man pg Reformatting pg(1), please wait... PG(1)

Re: [GENERAL] IBM investing in EnterpriseDB

Brent Wood typed: > I need to learn to type!!! try PostGIS (how did that become PistGIC? I have > no idea) > > >>> "Brent Wood" <[EMAIL PROTECTED]> 27/03/08 1:44 PM >>> > Add Informix to the list of IBM's RDBMS products.. Also note that where > Postgres has PistGIC > as an OGC compliant geoda

Re: [GENERAL] 8.2/8.3 incompatibility

Harald, > > I've found an incompatibility between PostgreSQL 8.2.4 and 8.3.0 which > is not clearly documented. Here's a short example: <...> > > (Note the different column types.) > Precisely -- there are a number of casts that have been removed from this release. You can find details in t

Re: [GENERAL] postgresql book - practical or something newer?

Bruce Momjian said: > Tom Hart wrote: > > I definitely think that the lists are one of the shining stars for > > postgresql support. I've learned some good reference stuff from online > > docs/google but the really tricky questions were only answered here, and > > amazingly enough, quickly and

Re: [GENERAL] [ADMIN] Can we have 2 databases on same server

Suresh Gupta asked: > > I have Solaris 9 machine with Pgsql 7.4 and want to upgrade to 8.2.5. I > don't want to disturb the first version now. I want to install second > one separately and need to test with my application. If it works fine, I > will activate only the latest one and other version

Re: [GENERAL] constraints in table

Dominique Bessette - Halsema asked: > > Hello, > > How do i find the constraints on a table in SQL? my database is linux > based, and I cant seem to find the command. Thanks > >From the psql prompt, \d works for me: billing=# \d work.clients Table "work.clients"

Re: [GENERAL] Online Oracle to Postgresql data migration

Mayuresh Nirhali wrote: > > Josh Harrison wrote: > > > > > > Thanks . > > We have around 3TB of data now running in Oracle. I have done > > replication in postgresql but not much in Oracle. Is there a way you > > can replicate between Oracle and Postgresql. For writing the custom > > codes do

Re: [GENERAL] case dumbiness in return from functions

Nico Sabbi wrote: > > Tom Lane ha scritto: > > Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes: > > > >> After discovering that pg_get_serial_sequence behaves in a bit > >> strange way[1] when it deals to case sensitiveness > >> > > > > The SQL standard specifies that unquoted identifier

Re: [GENERAL] Sun acquires MySQL

Joshua Drake shaped the electrons to say: > > Russ Brown wrote: > > http://blogs.mysql.com/kaj/sun-acquires-mysql.html/ > > > > What does this mean for Sun's support of Postgres? > > > > Does it matter? :) I am sure OmniTI and Command Prompt will be > happy to help any disgruntled customer :)

Re: [GENERAL] Increase the number of concurrent connection

You may not have issues such that upping the # of users may be a) running you out of postgres allocations (see your documentation for details) ... increasing settings in the postgresql.conf file might help (shared_buffers for instance, and shared_buffers ) or b) not enough shared memory confi

Re: [GENERAL] Setting Sequence Values

Joshua Drake shaped the aether to say: > > Shout out to AndrewSN for this one (although I was almost there when he > pasted it ;)): > > SELECT c1.relname AS sequencename, n.nspname AS schema, >c2.relname AS tablename, a.attname AS columnname >FROM pg_class c1 >JOIN pg_depend d ON

Re: [GENERAL] Setting Sequence Values

Joshua Drake spake thusly: > > On Fri, 21 Dec 2007 23:57:21 - > Martin <[EMAIL PROTECTED]> wrote: > > > After porting tables and data from FrontBase I now find that I > > need to update all the values for the sequences that were created > > to reflect the data in the tables. Is there an easy

Re: [GENERAL] thank you

Kevin H. wrote on Tue 12/18/2007 7:26 PM > Hullo List, > > This is aimed at everyone in this community who contributes to the > Postgres project, but especially at the core folks who continually make > this community great through energy, time, money, responses, and > what-have-you. <...snipped.

Re: [GENERAL] Hijack!

Peter Childs caused electrons to shape a message: > > On 11/12/2007, Obe, Regina <[EMAIL PROTECTED]> wrote: > > > > Well said Greg. I have the same problem too of having a crippled mail > > reader :) Really I find mid posting hard to follow especially if I'm the > > one that posted the questio

Re: [GENERAL] Hijack!

Greg Stark shaped the electrons to read: > "Obe, Regina" <[EMAIL PROTECTED]> writes: > > > Well said Greg. I have the same problem too of having a crippled mail > > reader :) Really I find mid posting hard to follow especially if I'm > > the one that posted the question. I hope we aren't going

Re: [GENERAL] Hijack!

-Original Message- From: [EMAIL PROTECTED] on behalf of Joshua D. Drake Sent: Tue 12/11/2007 9:43 AM To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Hijack! -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 11 Dec 2007 16:31:40 + "Raymond O'Donnell

Re: [GENERAL] uninstall postgres 8.2

josh -- Delete everything under the postgres directory (we put ours on /apps/postgres.version.whatever.) to remove the executables/libs etc, and delete the entire data directory that the initdb pointed to. e.g if $PGDATA is /data/postgres/billing, rm -rf /data/postgres/billing would get rid of

Re: [GENERAL] Simple math statement - problem

A quick experiment shows that if either numerator or denominator are decimal, that is preserved in the end result. Probably true for basic math operations in general. GW -Original Message- From: [EMAIL PROTECTED] on behalf of Gregory Williamson Sent: Thu 11/29/2007 10:37 PM To

Re: [GENERAL] Simple math statement - problem

The question: > > How can I write statements that returns a decimal? > > billing=# select 1/100; ?column? -- 0 (1 row) As you said ... So make everything decimal: billing=# select 1.0/100.0; ?column? 0.0100 Or: billing=# selec

Re: [GENERAL] Why upgrade?

Chris -- You asked > > I'm currently using 7.4 and I trying find out what the value/advantage > of upgrading to a more recent version and to which version. > Eventually 7.4 will not be supported (there's discussion elsewhere on how to deal with 7.3), so it would pay to move off of it well befo

Re: [GENERAL] PostgresSQL vs. Informix

Chad -- <...> > > Have you seen any studies (either by Sun or others) that compares > PostgresSQL to other commercial database software (Informix, Oracle, > Sybase,etc.)? I am interested seeing a feature by feature comparison of > PostgresSQL and Informix. > Hope this ain't too late! I can'

Re: [GENERAL] Disk arrangement in a cheap server

Clodoaldo asked: > I will build a cheap server and I'm in doubt about what would the the > best for performance: > > 1 - everything in one lonely fast 10,000 rpm Raptor HD; > > 2 - two cheap 7,200 rpm 16MB cache HDs like this: > > disk 1 - system and pg_xlog > disk 2 - pg_data without p

Re: [GENERAL] A few questions

Samantha Atkins shaped electrons to ask: > > What do you consider the most logical, one database per user? > > - samantha Perhaps a schema per user ? Then you can have the common tables (look up values, whatever) in the public schema. Each user gets a schema that has all of the tables they sha

Re: [GENERAL] For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER

Sorry for top-posting -- challenged reader. Can't speak directly to PostgreSQL but in Informix the fill factor is useful for tweaking indexes. A very high fill factor is useful for tables that are static -- any inserts or changes to the index trigger a *lot* of moving of b-tree branches. But th

Re: [GENERAL] Statistics collection question

Sounds like index bloat to me ... lots of updates of indexed columns = lots of extra dead index entries. Since IIRC PostgreSQL indexes (indicii?) don't store information about the "liveness" of the referenced rows, indexed reads would have to sort through a lot of dead wood to find the few live

Re: [GENERAL] List tables in load order

f the original message. (My corporate masters made me say this.) -Original Message- From: Kristo Kaiv [mailto:[EMAIL PROTECTED] Sent: Tue 8/7/2007 3:58 PM To: Gregory Williamson Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] List tables in load order On 02.08.2007, at 4:16, Gr

Re: [GENERAL] List tables in reverse dependancy order

Lane [mailto:[EMAIL PROTECTED] Sent: Sat 8/4/2007 9:51 AM To: Gregory Williamson Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] List tables in reverse dependancy order "Gregory Williamson" <[EMAIL PROTECTED]> writes: > I'm trying to create a procedure that would l

[GENERAL] List tables in load order

I am not sure if this is the appropriate list -- please point me at the correct one if not. I'm trying to create a procedure that would let me retrieve a list of tables and views in a database that will be used to control the order in which lookup data is created/loaded. So, much simplified, if

[GENERAL] List tables in reverse dependancy order

I am not sure if this is the appropriate list -- please point me at the correct one if not. I'm trying to create a procedure that would let me retrieve a list of tables and views in a database that will be used to control the order in which lookup data is created/loaded. So, much simplified, if