On Wed, 2010-08-25 at 12:20 -0400, Eric Comeau wrote:
Without even changing any line of data or code in sql !
Incredible, isn't it ?
Curious- what postgresql.conf settings did you change to improve it?
The most obvious would be to turn fsync off, sychronous_commit off,
increase
for all databases within it on a single (or small number) of
connections?
Well if you are just using it for updates to the schema etc... you
should only need to launch a single connection to each database to make
those changes.
Joshua D. Drake
--
Sent via pgsql-general mailing list (pgsql
windows operating system except Windows
2003 .
There is a reason the community provides binary packages. The idea that
you are patching 8.4.1 is quite ridiculous. Upgrade to 8.4.4.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http
://archives.postgresql.org/pgsql-hackers/2002-12/msg00598.php
I say, let's DO IT! :)
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http
% of available memory
work_mem = 2-4MB (test using explain analyze)
effective_cache_size = 50-60% of available memory INCLUDING
shared_buffers
etc
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support
On Thu, 2010-08-12 at 20:01 -0400, Greg Smith wrote:
Joshua D. Drake wrote:
Can we just say in the docs say 25% of memory to shared_buffers
Yes, in fact we can. With the caveat of Windows, the reality is this
isn't going to hurt nearly as much as a untuned version of PostgreSQL
On Wed, 2010-08-11 at 13:17 -0400, Michael C Rosenstein wrote:
Hello. We are new to Postgres, and are in the process of migrating our
project's app from Oracle.
I have been using Embarcadero's ER/Studio as a data modeling/DDL tool
for 15 years (and love it!), but its support for Postgres
On Mon, 2010-08-09 at 10:09 -0600, Scott Ribe wrote:
It's not a requirement, just a reasonable default.
The actual requirement is:
Thou shall not use a privelaged user, e.g; Administrator or UID = 0.
Not only is that a reasonable default, MySQL is broken because of
theirs.
Joshua D. Drake
if it lasts for any length of time as it can conflict
with routine maintenance. However again, it could also be doing the same
thing as above.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support
On Tue, 2010-08-03 at 16:15 +0200, Ulas Albayrak wrote:
Hi,
I have a Linux/Debian machine running postgres 8.3 and I need to
remove a database cluster that I created with the initdb command. Is
it enough to just delete the folder in which the cluster resides on
the filesystem, or does it
no idea why...
What are you using to manage this? I would strongly suggest Walmgr or
PITRTools. They take a lot of the guess work out of all this stuff.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training
the CACHE turned on,
on the drive. The SATA drives will have cache turned on and will be
faster.
That said, your results are slow as a whole.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom
On Mon, 2010-08-02 at 21:04 +, stee...@gmail.com wrote:
Hi, I posted twice and didn't get any response, wonder my post didn't get
populated properly.
Again, followed the document on WAL shipping, and couldn't get target to
recognize the archive WAL files. It looks for different WAL
.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
--
Sent via pgsql-general mailing list
with Postgres support in Drupal.
The issue isn't Drupal. It is modules. There are a lot of popular
modules that do not work with PostgreSQL (Lightbox for example).
The google checkout module for Ubercart didn't work either until
relatively recently.
Sincerely,
Joshua D. Drake
definitely competitive now, but I don't know if we'll ever fully
overcome that historical disadvantage.
Yeah that is a tough one. I would note though, if you move out of PHP,
our community grows astronomically.
Sincerely,
Joshua D. Drake
regards, tom lane
--
PostgreSQL.org
of application
would you expect to find that start development right now in VB?
http://www.tiobe.com/index.php/content/paperinfo/tpci/index.html
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training
Except for Drupal's partial support, I cant find any which has a
sizeable
deployment and community size behind it. Spree is a new RoR based
system,
that would obviously work with PG, but doesnt have a sizeable deployment
base.
Drupal + Ubercart + a ton of their modules work great. It is
on-site).
Over time though, there is no question that hands down PostgreSQL will
save you money. You can get an Enterprise class support contract for 500.00
a month per server.
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development
there for PG tables? what do you all recommend in this
case?
80-100Gb isn't that much. However it may be worth looking into
partitioning by state.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training
On Wed, 2010-07-28 at 22:37 +0530, Sandeep Srinivasa wrote:
Could you point me to any deployments of Drupal + Ubercart +
Postgres ?
Did you not see the links below?
Drupal + Ubercart + a ton of their modules work great. It is
what drives:
/multiple_drupal_installations_single_login_10_steps/
That show the flexibility you get by using PostgreSQL.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
On Thu, 2010-07-29 at 07:04 +0200, Ivan Sergio Borgonovo wrote:
BTW up to my memory Django suggest postgres. I haven't seen any
benchmark of Django with pg vs mysql.
Django was originally developed for Postgres but really, they are wholly
different beasts.
Joshua D. Drake
--
PostgreSQL.org
On Wed, 2010-07-21 at 08:58 -0700, Ben Chobot wrote:
Is there any difference between text and varchar data types? (Not
varchar(n), just varchar.) I can't see a different from the manual page, but
I'm wondering about index usage or something similarly subtle.
They are the same thing. So is
On Wed, 2010-07-14 at 18:18 +0200, easyCity Team wrote:
Hi guy,
I just droped a development database by mistake using the dropdb command
witch contains valuable data.
Can I still restaure it ? I have no backup.
No.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
On Wed, 2010-07-14 at 13:05 -0400, Darin Del Vecchio wrote:
We are doing an upgrade soon, and are wondering if its worth waiting
till version 9.0 is put into production.
I found that its projected to be mid-August at the following wiki. I
wasn't sure if there might be some more recent up
fishy( $1 , $2 , $3 , $4 )
PL/pgSQL function main line 9 at SQL statement
You are passing four IN paramaters. The out paramaters are used in
return are they not?
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting
Following on the smashing success of PostgreSQL Conference East,
PostgreSQL Conference West, The PostgreSQL Conference for Decision
Makers, End Users and Developers, is being held at the St. Francis,
Westin Hotel in San Francisco from November 2nd through 4th 2010. Please
join us in making this
On Tue, 2010-07-13 at 20:33 +0800, Craig Ringer wrote:
That's a write rate of 34MB/min, or half a meg a second. Not pretty.
Where's the load during the COPY? Mostly CPU? Or mostly disk I/O?
Are you writing the output to the same disk the database is on? (Not
that it should make this much
On Tue, 2010-07-13 at 03:42 +, Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Joshua D. Drake wrote:
* No trusted/untrusted versions
This is false. There are both.
Ah, good news, glad I was misinformed. I'm curious, what
mechanism does it use
On Wed, 2010-07-07 at 17:54 -0700, David Fetter wrote:
On Wed, Jul 07, 2010 at 02:31:04PM -0700, Josh Berkus wrote:
Folks,
I'll be unexpectedly in Madison next week for an onsite contract. Is
there a user group in Madison I could meet up with? Maybe do a quick
session on 9.0?
As
be.
- could this be solved using persistent connections, or the persistent
connections in php and postgres don't work properly?
Don't use them.
- could this be solved using something like pgpool?
Yes, using a connection pooler will solve the problem. I prefer
pgbouncer.
Joshua D. Drake
On 6/26/2010 1:25 PM, Pavel Stehule wrote:
Hello
2010/6/26wei...@lycos.com:
About four five years ago, I had received a few of emails about the data type
problems on this mailing list. I believe that the problem was about a
performance issue. Is any problem withe the Long Integer type in
/postgresql84/bin/psql Trading-Access
./Trading-Access
it causes the error: invalid byte sequence for encoding UTF8: 0x8b
It means the database you has characters in it that are not UTF8
compliant. You can use iconv to clean it up.
Joshua D. Drake
Thanks,
--
PostgreSQL.org Major Contributor
that?
You have to move the whole cluster. (Your data directory)
1. Are the Redo Logs enabled by default?
Yes, its called WAL.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom
they don't have access to the data.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
have no problem with him trying to protect his hard earned work. I
just think he is trying to solve the wrong problem.
Joshua D. Drake
Allan.
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom
/pl_secure_standard_server.do
That's interesting... does it just turn it into bytecode?
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
--
Sent via pgsql-general mailing list
those?
Here is a nice interface to the code:
http://doxygen.postgresql.org/
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
--
Sent via pgsql
.
Any idea if that's the case? and if so, is that expected?
It finished before it received the cancellation. You need to be using
transactions.
Joshua D. Drake
Thanks
Dave
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting
On Wed, 2010-06-23 at 17:17 -0400, John DeSoi wrote:
On Jun 22, 2010, at 1:08 AM, Scott Marlowe wrote:
I recall talking to the guys at command prompt and apparently
something in the php runtime makes it unsuitable for pl deployment.
Any chance that the Parrot runtime could be used for
to update it from the migration from Trac.
* PHP is not as stable, mature, secure, or well designed as Perl/Tcl/Python.
No it is just more popular, more widely used and has a larger community.
(Oh: And remember, I am a python guy)
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command
in selection of hardware and configuration. Is this different
for any database system?
Yes :) but does it matter?
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development
for uniqueness instead of Sequences and Site ID's.
No you can use your own library as well (or language library).
Joshua D. Drake
Thanks,
O.
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom
to stop postgres,
initdb, recreate your users etc...
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
--
Sent via pgsql-general mailing list (pgsql-general
, this happens at least 5 times per day at
random times. Apache however, does not die.
All three? What does /var/log/messages or /var/log/syslog say?
I wonder if the oom killer is acting up.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
to work with for partial restores.
Joshua D. Drake
Thanks in advance.
Mary
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
--
Sent via pgsql-general mailing
On Thu, 2010-05-13 at 15:15 +0100, Dave Page wrote:
On Thu, May 13, 2010 at 3:03 PM, Igor Neyman iney...@perceptron.com wrote:
Will 9.0 also have 64-bit ODBC driver?
Eventually.
What would be the benefit? We considered it with ODBCng but couldn't
find any real suitable purpose.
Joshua D
On Thu, 2010-05-13 at 19:08 +0200, Magnus Hagander wrote:
On Thu, May 13, 2010 at 7:01 PM, Joshua D. Drake j...@commandprompt.com
wrote:
On Thu, 2010-05-13 at 15:15 +0100, Dave Page wrote:
On Thu, May 13, 2010 at 3:03 PM, Igor Neyman iney...@perceptron.com
wrote:
Will 9.0 also have 64
it is also important to remember to use the right tool for each
job. SQLite is used for RPM as well as bookmarks for firefox. It makes
sense there. PostgreSQL would not.
SQLite is a small, cool, fast, embedded database.
Joshua D. Drake
RobR
--
PostgreSQL.org Major Contributor
Command
On Wed, 2010-05-12 at 19:05 +0100, Thom Brown wrote:
Hi,
Does anyone know if there are issues with performing a pg_dump in
custom format in one major version, and using pg_restore on it on a
higher version?
You want to use the pg_dump from the higher version.
Joshua D. Drake
Thanks
On Wed, 2010-05-12 at 19:33 +0100, Thom Brown wrote:
On 12 May 2010 19:29, Joshua D. Drake j...@commandprompt.com wrote:
On Wed, 2010-05-12 at 19:05 +0100, Thom Brown wrote:
Hi,
Does anyone know if there are issues with performing
a authorized_keys with a specific command in it,
and other tricks, but nothing will be as straightforward and error proof
as the line you gave, I suspect.
With one minor exception. I don't think he needs -Z9 since he is using
SSH which will compress anyway.
Joshua D. Drake
- --
Greg Sabino
back to the size it is supposed to
be at?
PostgreSQL 8.2.6 on Windows 2003 Server.
vacuum full, its an exclusive lock though.
I don't recall if 8.2 autovacuum would vacuum system catalogs or not.
Either way, you really should upgrade, especially since you are on
Windows.
Joshua D. Drake
as it gets. It
is a great baseline at this point.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
On Tue, 2010-04-27 at 12:33 -0400, akp geek wrote:
Hi all -
I would like to know, if there is a open source BI tool
for creating reports against Postgres database ? appreciate your help
Pentaho
Regards
--
PostgreSQL.org Major Contributor
Command Prompt, Inc:
On Tue, 2010-04-27 at 13:40 -0700, John R Pierce wrote:
akp geek wrote:
Business Intelligence
isn't that an oxymoron?
Depends, you want your paycheck?
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training,
On Tue, 2010-04-27 at 15:39 -0500, Chris Copeland wrote:
Any help is greatly appreciated. Please let me know if I can provide
any more information that will be helpful.
Well the problem is that the files are missing. How are you copying
them?
Joshua D. Drake
-Chris
.
Yeah but that isn't generally a problem now and the gain he gets from
the lack of join performance is more than worth it.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development
remove the need for the join in the first
place, which is certainly faster than joining :P
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
--
Sent via pgsql
On Wed, 2010-04-14 at 22:53 -0400, Bruce Momjian wrote:
Damian Carey wrote:
On Thu, Apr 15, 2010 at 6:18 AM, John R Pierce pie...@hogranch.com wrote:
Joshua D. Drake wrote:
Mostly, I think you will find that the back end developers aren't fond
of Java and thus, it doesn't get much
.
There is a reason that plPerl is king in this community (and I don't
even like Perl).
Joshua D. Drake
--
Craig Ringer
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
.
That's only true for the 8.2 series. :
PPAS 8.1 = PostgreSQL 8.1
PPAS 8.3x = PostgreSQL 8.2 base (plus HOT and wal_writer)
PPAS 8.4 = PostgreSQL 8.4 (plus compatibility)
PPAS 9 [is planned to] = PostgreSQL 9.0
So there was no actual 8.3 base release of PPAS?
Joshua D. Drake
On Thu, 2010-04-01 at 10:54 -0600, Scott Marlowe wrote:
On Thu, Apr 1, 2010 at 10:05 AM, David E. Wheeler da...@kineticode.com
wrote:
On Apr 1, 2010, at 3:01 AM, Magnus Hagander wrote:
I prefer to dump all my data in a big text file and grep it for the
information I need.
As long
in files such as pgpass.conf.
Is there any configuration that can be done, on the server side, or in
the C++ and/or java application side, so to prevent such thing ?
Don't let your users log in to the Windows machine as users that have
access to those files.
Joshua D. Drake
.
Joshua D. Drake
--
Craig Ringer
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or
Sir.
--
Sent
applications in one database. Use
multiple databases to isolate them entirely.
Or use Schemsa.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned
On Fri, 2010-03-12 at 16:45 -0700, Gordon Shannon wrote:
This is 8.4, there is no pg_autovacuum table. I set it like this:
alter table foo set (autovacuum_analyze_scale_factor=0.01);
That is 1% changes. I think you want .10
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major
03/11/2010
The hotel discount deadline is today, 03/11/2010. If you have not
purchased your rooms by the end of today, you will pay at least 60.00
more per night.
The hotel is also reaching capacity. It is doubly worth your attention
to register today if you are seeking to do so. If you do not,
March 9th, 2010
PostgreSQL Conference East, the largest PostgreSQL Conference for Users,
Developers, Decision makers and anyone using PostgreSQL arranged for a
hotel discount for attendees from the Radisson Warwick Hotel (the
location of the conference).
The retail price of a double room is ~
to not conflict.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or
Sir.
--
Sent via
numeric;
ERROR: column id cannot be cast to type pg_catalog.numeric
postgres=#
Joshua D. Drake
--
Richard Huxton
Archonet Ltd
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development
smarlowe=# alter table abc alter column c type numeric using c::numeric;
ALTER TABLE
Well that is interesting. I would have thought it would have failed
because of the padding...
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
On Mon, 22 Feb 2010 23:19:34 -0800, Wang, Mary Y
mary.y.w...@boeing.com
wrote:
Hi,
I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in
the
process of restoring the databases in Postgres 8.3.8. There were lots
errors showed on the screen when I ran this command 'psql -e
us a little time. That said, I am not sure that we have any
desire to continue to build for 7.4. I will have to discuss it with the
team.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom
On Thu, 2010-02-11 at 23:39 +0900, Koichi Suzuki wrote:
Dear Folks;
A very serious bug was reported on pg_lesslog. So far, I found it's
a bug in pg_compresslog. Please do not use pg_compresslog and
pg_decompresslog until improved version is uploaded.
I strongly advise to take base
that can efficiently connect RDF to
PostgreSQL?
What do you mean connect? If you want to support RDF as storage we do
have native xml capabilities.
http://www.postgresql.org/docs/8.4/static/datatype-xml.html
Sincerely,
Joshua D. Drake
Aaron Thul
http://www.chasingnuts.com
, no doubt. Does
it not install symlinks in the actual data directory? If not, that
should be reported as a bug ...
I disagree. Debian/Ubuntu use the postgresql.conf facilities to have a
different postgresql.conf.
This is a limitation within PostgreSQL.
Joshua D. Drake
--
PostgreSQL.org Major
all (7.3+) versions to versions.rss, but show only
top 5 versions?
7.3 is not supported. It would be 7.4+ and even that, we need to put
that under a different category... Something like:
Old versions you shouldn't use:
8.0
7.4
Joshua D. Drake
Regards,
--
PostgreSQL.org Major
On Fri, 2010-01-29 at 18:50 +0200, Devrim GÜNDÜZ wrote:
On Fri, 2010-01-29 at 08:44 -0800, Joshua D. Drake wrote:
Is it possible to add all (7.3+) versions to versions.rss, but show
only
top 5 versions?
7.3 is not supported.
I know. But it would be a chance to remind people
On Fri, 2010-01-29 at 23:52 +0200, Moe wrote:
Is it possible to set postgres in case insensitive mode ?
I assume you mean the issue where postgres folds all case of objects to
lower if they are not . No.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http
On Mon, 2010-01-25 at 09:09 -0600, Abraham, Danny wrote:
Our setup is a real valid one. Looks like it has to do more with
remote connections.
A remote connection trying to set statement_timeout on its own and
sending an invalid value.
Joshua D. Drake
Any idea?
Thanks
Danny
On Fri, 2010-01-15 at 12:16 -0500, Alan McKay wrote:
Hey folks,
Sorry for the OT - we are most of the way through a Db2 -- PG
migration that is some 18 months in the making so far.We've got
maybe another 3 to 6 months to go before we are complete, and in the
meantime have identified the
On Fri, 2010-01-15 at 17:35 -0500, Alan McKay wrote:
On Fri, Jan 15, 2010 at 4:45 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
What language are you running this in again? There might be other
options that are more language oriented (java for instance) than db
oriented. Or maybe
insert a bad record the whole
transaction fails.
Joshua D. Drake
Thanks in Advance!
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained
our statements and triggers/stored procedures
wich is currently in work.
PostgreSQL 8.3/8.4/8.5 will run just fine on 64bit Windows. Just
understand that PostgreSQL will be running in 32bit mode, which frankly
on windows is not a problem compared to other platforms.
Joshua D. Drake
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
applaud your willingness to move to Pg but in this case
something like SQLite or even Ingres may be a better solution for you.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom
to deploy my DB on a hosting company server. But they can see my
functions code (they have root privileges) and this is what I want to
avoid.
If you don't trust your hosting company then why are you doing business
with them?
This+
Bingo...
Joshua D. Drake
--
PostgreSQL.org
in
a court of law, thus is still on shaky legal ground.
Can we move this thread to someplace relevant? This really has no place
on this list.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom
Monty made his be, let him lie in it.
I repeat, this if off-topic. Please drop it.
Joshua D. Drake
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving
without paying a license fee requires that projects using the database
are also GPL, IIRC)
I'm pretty sure this only applies to commercial software thats
distributed -with- MySQL
Guys, this is wholly off-topic.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc
On Tue, 2009-12-29 at 13:21 -0800, Nick wrote:
On Dec 28, 8:22 pm, pie...@hogranch.com (John R Pierce) wrote:
Nick wrote:
'g++' or g++ says -bash g++: command not found
distro is red hat
Assuming thats RHEL5,
yum install gcc-c++
if its RHEL4 or earlier, use up2date
sort of assumed that psql connected via a local pipe and not a port.
The socket is named... .s.PGSQL.port, thus it still needs to know.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom
On Tue, 2009-12-22 at 16:08 -0800, David Kerr wrote:
- export PGPORT=5433
-
- etc...
ok thanks, that might be an easier way to handle my scripts.
can you export PGHOST as well?
The manual provides a list:
http://www.postgresql.org/docs/8.3/static/libpq-envars.html
Joshua D. Drake
,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. -
Salamander
--
Sent via pgsql-general mailing
(which is bytea with a
different delivery and storage mechanism).
5k chunks is pretty small, bytea is probably fine.
Joshua D. Drake
Thanks.
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom
or directory:
'/opt/postgres/archive/10.100.101.150'
LOG: archive command failed with exit code 1
DETAIL: The failed archive command was: cmd_archiver
-C /export/home/postgres/8.4/pitrtools/cmd_archiver.ini -F
pg_xlog/00030001007D
Did you run cmd_archiver -I ?
Joshua D. Drake
).
Regards
On Wed, Nov 18, 2009 at 4:58 PM, Joshua D. Drake j...@commandprompt.com
wrote:
On Wed, 2009-11-18 at 16:46 -0500, akp geek wrote:
Hi All -
I would like to know if any one has instructions on how
to setup pg_standby, if so can you please share?
If you
401 - 500 of 2121 matches
Mail list logo