are more than welcome to use closed source
software against the ODBCng driver.
Joshua D. Drake
Rainer
---(end of
broadcast)--- TIP 3: Have you checked our
extensive FAQ?
http://www.postgresql.org/docs/faq
that the driver
can be used in commercial applications? If so then either this should
be stated on the drivers' page (or the licence should be changed to
LGPL).
The official statement is, you can use it in commercial applications as
long as you don't violate the GPL.
Sincerely,
Joshua D. Drake
it is based on pgCluster which isn't quite done but according to
the authors Cybercluster is more complete and portable.
Let us know what your experiences are!
Joshua D. Drake
The cybercluster link:
http://www.postgresql.at/english/downloads_e.html
-Dennis
---(end
of maintenance.
Should I just use statement_timeout as a proxy for this?
That would yes but see my point about maintenance above.
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Testing some changes on our end, please ignore
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
the talks up. We also have some of the slides
(more forthcoming) and the video will be up in a couple of weeks!
Thanks to everyone again for their support of this conference series.
It is great to see the community growing and supporting each other.
Sincerely,
Joshua D. Drake
/schemas:
http://www.postgresql.org/docs/current/static/ddl-schemas.html
Thanks very much for any enlightenment on these questions.
- samantha
Hope this was helpful.
Sincerely,
Joshua D. Drake
---(end of
broadcast)--- TIP 5: don't forget
,
Joshua D. Drake
---(end of
broadcast)--- TIP 3: Have you checked our
extensive FAQ?
http://www.postgresql.org/docs/faq
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency
since 3 drives)
Uhhh RAID 1 is your best bet. You get fault tolerance (mirrored) plus
you get a hot spare (3 drives).
RAID 5 on the other hand will be very expensive on writes.
Joshua D. Drake
Anyway.. I'm trying to figure out the chunk size for the raid. I'm
using 4k chunks since I'm reading
to
require our client user interface to be used for restoration when
there is a pg_restore sitting in the bin directory.
Sincerely,
Joshua D. Drake
(BTW, I just fixed pg_restore to always mention the file name it
attempted to open after getting an fopen failure
such development?
Sincerely,
Joshua D. Drake
Jon
-Original Message-
From: Brad Lhotsky [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 25, 2007 9:13 AM
To: Roberts, Jon
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] subversion support?
You could setup a subversion commit
in the database is different from the last committed
version. A visual diff should be there so you can see what the
differences are.
Would you be willing to sponsor such development? :)
Joshua D. Drake
Jon
-Original Message-
From: brian [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October
/functions-aggregate.html
Sincerely,
Joshua D. Drake
Thanks,
Kevin
---(end of
broadcast)--- TIP 2: Don't 'kill -9' the
postmaster
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7
Ow Mun Heng wrote:
I'm wondering if what I'm doing is redundant.
I have a primary key on columns (A,B,C,D)
and I've also defined an index based on the same columns (A,B,C,D)
and sometimes in the query explain, I see the pkey being used for the
scan instead of the index.
So.. That made me
.
Joshua D. Drake
Dave
Chris
---(end of broadcast)---
TIP 1: 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
On Fri, 19 Oct 2007 14:28:30 -0300
Alvaro Herrera [EMAIL PROTECTED] wrote:
Joshua D. Drake wrote:
On Fri, 19 Oct 2007 10:59:20 -0300
Alvaro Herrera [EMAIL PROTECTED] wrote:
Thomas Pundt wrote:
Alban Hertroys schrieb:
Isn't this just what the ABBR tag in html
On Fri, 19 Oct 2007 20:04:27 +0200
Michael Meskes [EMAIL PROTECTED] wrote:
On Thu, Oct 18, 2007 at 04:46:00PM -0700, Steve Crawford wrote:
ECPG - Embedded SQL in C ??
Correct. And the PG part should be obvious. :-)
Pretty Good?
Michael
--
=== The PostgreSQL Company: Command
On Fri, 19 Oct 2007 10:59:20 -0300
Alvaro Herrera [EMAIL PROTECTED] wrote:
Thomas Pundt wrote:
Alban Hertroys schrieb:
Isn't this just what the ABBR tag in html is for?
Well, yes; according w3.org its purpose is to describe the
abbreviation/acronym inline in a document using a title
on it, but that's not the only one, for
example)
How about we just emit a warning..
WARNING: Connections above 250 on Windows platforms may have
unpredictable results.
Joshua D. Drake
//Magnus
---(end of
broadcast)--- TIP 1: if posting
://www.otg-nc.com/
Sun - http://www.sun.com/
Truviso - http://www.truviso.com/
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com
of software's limitations are also not for this
list, unless that software is PostgreSQL.
May we please get this back on topic.
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions
cost somewhere undecided)
Sincerely,
Joshua D. Drake
Erik Jones
Software Developer | Emma®
[EMAIL PROTECTED]
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate market in style.
Visit us online at http://www.myemma.com
)
AND (lower(a.lastName) LIKE '%foo%' OR '%foo%' IS NULL)
AND (lower(b.emailAddress) LIKE NULL OR NULL IS NULL) )
Granted this isn't WHERE FALSE, but I certainly see WHERE TRUE all the
time in similar scenarios and I have seen WHERE FALSE.
Sincerely,
Joshua D. Drake
Joshua D. Drake
impossible) to materialize the data on a schedule,
since the user has a number of options how how to export the data
(filters, etc) so we chose to do it on-demand.
Export to large object, not text.
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support
not a database, thus -g is your
option.
It has been discussed in the past to have per database roles, but that
has not beed coded.
Joshua D. Drake
I've read the system catalogs documentation [1], but I didn't figure how
to relate the database name with the table names...
So far I can get all
the database, it's handy.
I could easily argue that this is more a problem than a solution. Don't
get me wrong, I understand your point but frankly, if one is willing to
take such a lax approach to your data security... they should just run
flat files with RAID 0 ;)
Joshua D. Drake
That being
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ross Bagley wrote:
Newbie to pl/pgsql here.
I'm trying to create a function that cleans up the foreign keys
referring to a particular row (if any exist), then removes the row (if
it exists), and returns the number of rows of br_role that were
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bob Pawley wrote:
I want to be able to convert a PostgreSQL database to other formats such as
Oracle, Access etc. - with, as well as without, the data.
Can this task be accomplished by employing pg_dump in SQL?
If you dump with inserts, data
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bob Pawley wrote:
Is there a better method of transfering the database and data to between
DBs?
Use your favorite language to do so.
Joshua D. Drake
Bob
- Original Message - From: Joshua D. Drake [EMAIL PROTECTED]
To: Bob Pawley
notes from the docs
5. 8.2 is a completely different beast in terms of performance and
configuration.
Sincerely,
Joshua D. Drake
Thanks
-dave
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL
://pugs.postgresql.org/pdx
PSU: http://www.pdx.edu
Sincerely,
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Matthew T. O'Connor wrote:
Joshua D. Drake wrote:
The PostgreSQL Conference Fall 2007 to date, has been a huge success. Of
course we haven't actually held the conference yet but already we have a
strong line of speakers and sponsors confirmed
systems), AFAIK you have
to manually adjust the init scripts for the runlevels that you want.
Assuming
You can use update-rc.d.
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Erik Jones wrote:
Just a quick question. Are there any issues or incompatibilities that I
should be aware of if I want to build out 64 bit binaries to run on a db
that's previously been run by 32 bit binaries?
Its a dump reload.
Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bill Moran wrote:
In response to Robert Fitzpatrick [EMAIL PROTECTED]:
On Thu, 2007-09-20 at 13:22 -0400, Bill Moran wrote:
In response to Robert Fitzpatrick [EMAIL PROTECTED]:
I have a large database used with our mail filter. The pg_dumpall
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ow Mun Heng wrote:
On Mon, 2007-09-17 at 22:14 -0700, Joshua D. Drake wrote:
Phoenix Kiula wrote:
So a YES/NO question:
Q: To get rid of index bloat, is a VACUUM ANALYZE enough? Or must I
reindex/cluster indexes?
If you overrun your
://www.greenplum.com/
OmniTI: http://www.omniti.com/
OTG: http://www.otg-nc.com/
Sun: http://www.sun.com/
And our local community sponsor:
PDXPUG: http://pugs.postgresql.org/pdx
If you are interested in sponsoring, please visit:
http://www.postgresqlconference.org/sponsor.html
Sincerely,
Joshua D. Drake
max_fsm_pages, no:
else yes;
Sincerely,
Joshua D. Drake
Thanks.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
- --
=== The PostgreSQL Company: Command
the old table to big_table new, rename new table to old table. Run analyze.
Try again. :)
Sincerely,
Joshua D. Drake
Mike
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
- --
=== The PostgreSQL Company: Command
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Michael Glaesemann wrote:
On Sep 6, 2007, at 19:37 , Ow Mun Heng wrote:
Nobody has any comments on this??
Don't do it.
HAHAHAHAHAHAHA
Joshua D. Drake
Michael Glaesemann
grzm seespotcode net
---(end
and
subscribe (we will be needing speakers for other events as well):
http://www.postgresqlconference.org/mailman/listinfo/speakers
If you are planning on attending, please join:
http://www.postgresqlconference.org/mailman/listinfo/attendees
Sincerely,
Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
A.M. wrote:
On Sep 6, 2007, at 21:10 , Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
The PostgreSQL Conference Fall 2007 is shaping up nicely. We are now
seeking more speakers. Here is the current lineup
on WO server.
You can't do that with PostgreSQL without replication. Unless you are
willing to have outages with your RO servers to apply the logs.
Further you are considering the wrong logs. It is not the WAL logs, but
the archive logs that you need.
Sincerely,
Joshua D. Drake
The idea
.
Sincerely,
Joshua D. Drake
The idea is to have say 2 raw devices which would be used as 2 WAL
segments (round-robin). RO servers will go after the one that's not used
at a given time with something like xlogdump utility and produce INSERT
statements to be then executed locally. After
should look into SERIALIZABLE only
for those transactions that need it. There is also SELECT FOR UPDATE.
Joshua D. Drake
- ---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
- --
=== The PostgreSQL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ron Johnson wrote:
On 08/29/07 10:40, Joshua D. Drake wrote:
Ron Johnson wrote:
Argh!!! The RDBMS that I typically use defaults to SERIALIZABLE.
SERIALIZABLE is really slow :). You should look into SERIALIZABLE only
for those transactions
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
Ron Johnson wrote:
Argh!!! The RDBMS that I typically use defaults to SERIALIZABLE.
SERIALIZABLE is really slow :).
Say what? If anything it's probably faster than READ COMMITTED
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
SERIALIZABLE is really slow :).
Say what? If anything it's probably faster than READ COMMITTED, because
it doesn't take as many
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gregory Stark wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
SERIALIZABLE is really slow :).
Say what? If anything it's
are no security at all.
Sure, but you haven't made a security adjustment. You have made a
behavioral adjustment that is guaranteed to break remote applications.
Joshua D. Drake
regards, tom lane
---(end of broadcast
enough contiguous
address space to alloc 512MB.
The X4600 runs with 64-bit Dual Opterons.
The machine we are tracking this problem on is also 64bit.
Joshua D. Drake
Erik Jones
Software Developer | Emma®
[EMAIL PROTECTED]
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps
by using partitioning?
Joshua D. Drake
Benjamin
On Aug 24, 2007, at 6:29 PM, Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Brandon Shalton wrote:
Benjamin,
In order to avoid the re-indexing I was thinking of instead creating
a new
table each month (building
the execution.
Which may be a performance hit, it may not be. It depends on many
factors. In general however, partitioning when done correctly is a
performance benefit and a maintenance benefit.
Sincerely,
Joshua D. Drake
Benjamin
On Aug 25, 2007, at 9:18 AM, Joshua D. Drake wrote
. This message
contains confidential information and is intended only for the individual
named. If you are not the named addressee you should not disseminate,
distribute or copy this e-mail.
Woah! That is great. Now to find a linux version.
Joshua D. Drake
---(end
, and memory usage and scan our logs for errors so if anything else
comes up I'll be sure to share.
We are actually diagnosing a similar problem on this end, where we get a
failure at 1920... I am currently trying to get some DEBUG output.
Sincerely,
Joshua D. Drake
Erik Jones
Software
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeff Amiel wrote:
--- Joshua D. Drake [EMAIL PROTECTED] wrote:
We are actually diagnosing a similar problem on this
end, where we get a
failure at 1920... I am currently trying to get some
DEBUG output.
We are actually getting it semi
, so new data that comes in, is
a lesser amount, and doesn't require re-indexing.
PostgreSQL can do all of this too.
Sincerely,
Joshua D. Drake
example:
select * from logfile_070825 where datafield = 'foo'
if i knew i wanted to specifically go into that child, or:
select * from
is the Firebird is relatively non-configured though
isn't it? For a large scale client server app there is no question that
PG is going to wipe the universe with Firebird, but I would think that
Firebird may be better suited for embedded shipping that kind of thing.
Sincerely,
Joshua D. Drake
but you can check it with vmstat.
And what will be the performance gain if I change the machine to equal
Athlon?
Depends on the work load.
Sincerely,
Joshua D. Drake
Thank you in advance.
---(end of broadcast)---
TIP 2: Don't 'kill -9
, not the actual commit of the
data. 48k records is nothing.
Joshua D. Drake
Your suggestions and comments are greatly appreciated.
Thank you,
Murali K. Maddali
256-705-5191
[EMAIL PROTECTED]
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 22
a bunch of different databases, it might be easier to
manipulate if it was stored in a database. MS-Access maybe? ;-)
Let's get this up on the wiki.
Joshua D. Drake
LewisC
--- Tony Caduto [EMAIL PROTECTED] wrote:
Check it out here:
http://www.amsoftwaredesign.com/pg_vs_fb
When
.
Thanks Dave.
Will update ASAP.
I agree with you on the multi-threaded. I think I will add a note
saying the the multi-threaded architecture is only advantageous on
Windows.
And Solaris.
Joshua D. Drake
I have seen instances where the threaded version of Firebird completely
craps out
are the only company that likely is trying to do it cross
continent ;) :).
You can not do multi master cross continent reliably. There are ways
using custom caches etc, to pull all session info into a geo-redundant
data store though.
Sincerely,
Joshua D. Drake
Thanks,
Matthew
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Geoffrey wrote:
We are looking for a reporting tool that will enable users to generate
their own reports. Something like Crystal Reports.
Anyone using something like this with Postgresql?
Why not Crystal Reports?
Joshua D. Drake
, but the user
interfaces are hard to take if you want a typical Mac application.
MS Access?
Joshua D. Drake
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 4: Have you searched our list
(and, of course, then move the
INSERT into the new partition).
I think I've answered my own question, but would love an expert
to validate the answer:
The answer is no, apparently because 'name' in
That answer is no but you could probably pull it off with a trigger.
Sincerely,
Joshua D
statements.
Alternately, is there some way of inserting or selecting data from the db
which doesn't require the use of apostrophes for non-numeric fields?
Uhmm just prepare all your statements and this shouldn't be an issue.
Joshua D. Drake
of col0 returned to the application and I don't want to
know the name of the sequence involved in the SERIAL column. I just
want the value inserted into the column by using just it's column name.
lastval()
Sincerely,
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt
.
Joshua D. Drake
- Josh
---(end of broadcast)---
TIP 1: 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
for the type?
Joshua D. Drake
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
Should we consider setting storage external by default for the type?
No. That would be counterproductive for the more typical case of bytea
values in the range of some-small-number
update which means a vacuum (probably full) afterward, but the way
you describe above will do the same thing as well.
Sincerely,
Joshua D. Drake
Karsten
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ron Johnson wrote:
On 08/18/07 11:08, Joshua D. Drake wrote:
Josh Tolley wrote:
On 8/18/07, Ron Johnson [EMAIL PROTECTED] wrote:
Interesting. Does PG have to initiate the Perl interpreter every
time you call a Perl-written SP?
IIRC PostgreSQL
, that's your first problem.
And second. And third.
Thanks for the kick in the derierre. Have set it all up to operate as
user postgres. Or is that insecure too?
Not as insecure, but consider that postgres == PostgreSQL root.
Joshua D. Drake
---(end of broadcast
pricing down?
I would suggest the following:
If you have real in house expertise:
CentOS or Debian
If you do not:
Redhat or Ubuntu Dapper.
Sincerely,
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
issues cropping up.
Why are you installing a new postgres 7.3 server. It isn't even
officially supported anymore.
Joshua D. Drake
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Erik Jones wrote:
On Aug 9, 2007, at 1:14 PM, Greg Smith wrote:
On Thu, 9 Aug 2007, Erik Jones wrote:
Perhaps we could have a nice, friendly discussion on using surrogate
primary keys v. string based keys? Or, I think the body of the
nulls
the packages and keeping them up to date.
Hmmm, it seems that this would be also suited to be in the
PostgreSQL.Org archives yes?
Joshua D. Drake
cu
Reinhard
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send
to allow connections, vacuum full,
dissallow connections, and then upgrade.
Sincerely,
Joshua D. Drake
mxl=# select datname, datallowconn from pg_database;
datname| datallowconn
--+--
postgres | t
.
.
.
template1| t
template0| f
(7 rows
which wouldn't?
Joshua D. Drake
//Magnus
---(end of
broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
---(end of broadcast
... out!
Sincerely,
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate
again, OpenSolaris,
OpenCluster are only but a subset of the unix tools that Sun have
I wasn't referring to current Sun, but the Sun of a decade ago.
Sincerely,
Joshua D. Drake
provided to the OSS community. Although, as a desktop, SX (Solars
Express) is as freindly as you will currently get
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bruce Momjian wrote:
Joshua D. Drake wrote:
3. Mac OSX is ugly. I know I just made a bunch of people poo in their
leather pants but it is. It is really ugly. I want clean, out of my way,
customizable interface that works the way I work
David Fetter wrote:
On Fri, Aug 03, 2007 at 09:25:41AM +0200, [EMAIL PROTECTED] wrote:
Am Donnerstag, 2. August 2007 22:37 schrieben Sie:
On Thu, Aug 02, 2007 at 11:58:40AM +0200, [EMAIL PROTECTED] wrote:
Hi,
i would like to use a statement replication for postgresql
Why?
i have read
to have -general
because we have pgsql-general and the immediate reaction is going to be,
oh I am in EU and have general technical questions.
*shrug* if it has all been worked out, so be it. I just think it will be
confusing.
Sincerely,
Joshua D. Drake
I expect there to be 3 or 4 -eu
Joshua D. Drake wrote:
Richard Broersma Jr wrote:
--- Joshua D. Drake [EMAIL PROTECTED] wrote:
Hello,
For those who were too square to be there,
For us squares, are there any pictures avaliable of this event?
Yes :)... they are coming. I hope to have them all this weekend.
I call
,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http
that donations are what pay for our ability to advocate at
these shows!
Sincerely,
Joshua D. Drake
SPI PostgreSQL.Org Liaison
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL
Richard Broersma Jr wrote:
--- Joshua D. Drake [EMAIL PROTECTED] wrote:
Hello,
For those who were too square to be there,
For us squares, are there any pictures avaliable of this event?
Yes :)... they are coming. I hope to have them all this weekend.
Joshua D. Drake
Regards,
Richard
for several databases.
Most commands/loads don't care about the database, since they just use
the one I am connected to. Alter database however needs the database
specified.
You could use it in plpgsql with EXECUTE.
Joshua D. Drake
---(end of broadcast
for the application in question.
just enforce hostssl in your pg_hba.conf and nothing else. If you can
connect, you are good :)
Joshua D. Drake
I can connect from the httpd host to the postgresql host using psql and it
shows that an ssl connection with a 256 bit key is in use. However, I
a party directly after the day. Details can be found
here:
http://www.postresqlparty.org/
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL
Hello,
My current list for volunteers is:
* Alvaro Herrera
* Josh Berkus
* Joshua D. Drake
* Chris Travers
* David Fetter
* Michael Alan Brewer
* Robert Bernier
* Selena Decklemann (part time) (PDXPUG)
* Gabrielle 1-2pm Wednesday (PDXPUG)
Am I missing anyone?
Joshua D. Drake
Joshua D. Drake wrote:
Hello,
This is a reminder to everyone that we hare have a PDXPGDay at the
Oregon Convention Center on July 22nd. The schedule can be found here:
http://pdxgroups.pbwiki.com/PDXPUG%20PostgreSQL%20Day
http://developer.postgresql.org/index.php/OSCON2007
to make it more efficient per row.
There is no way to not dump your TEXT and BYTEA data from a particular
column if you are dumping the whole table.
One option would be to use CREATE TEMP TABLE AS SELECT... and then dump
that temp table.
Joshua D. Drake
---(end
not plperl. plperl can't go outside of postgresql.
Joshua D. Drake
thanks a lot!
Bruno
---(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
something much more aggressive, like 4GB.
Dont' forget your effective_cache_size.
Joshua D. Drake
-x86_64 but Redhat 5 Ent
Benjamin
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
Gauthier, Dave wrote:
I’ll answer my own question...
select * from myfunc();
(dumb, dumb, dumb)
If it makes you feel any better, it is a common mistake :)
Joshua D. Drake
-dave
* From: * [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] *On Behalf Of *Gauthier, Dave
*Sent
the postgres user like this:
psql -U postgres
or
createdb -U postgres
The fine manual explains all of this.
http://www.postgresql.org/docs/8.2/static/index.html
Sincerely,
Joshua D. Drake
BUT, I cannot login as ‘postgres’ because even though the installation
created this user
.
Use pg_memcache.
Sincerely,
Joshua D. Drake
P.S. I agree with you, but you are barking up a very tall tree and you
don't have a chainsaw. The fact is, global temp tables that could be
assigned a static amount of memory to use that would recycle based on
some parameter would be infinitely useful
1001 - 1100 of 2121 matches
Mail list logo
