On Fri, 2009-03-13 at 14:00 -0400, Tom Lane wrote:
Marco Colombo pg...@esiway.net writes:
You mean some layer (LVM) is lying about the fsync()?
Got it in one.
I wouldn't think this would be a problem with the proper battery backed
raid controller correct?
Joshua D. Drake
On Fri, 2009-03-13 at 11:17 -0700, Ben Chobot wrote:
On Fri, 13 Mar 2009, Joshua D. Drake wrote:
On Fri, 2009-03-13 at 14:00 -0400, Tom Lane wrote:
Marco Colombo pg...@esiway.net writes:
You mean some layer (LVM) is lying about the fsync()?
Got it in one.
I wouldn't think
On Fri, 2009-03-13 at 11:41 -0700, Ben Chobot wrote:
On Fri, 13 Mar 2009, Joshua D. Drake wrote:
Of course. But if you can't reliably flush the OS buffers (because, say,
you're using LVM so fsync() doesn't work), then you can't say what
actually has made it to the safety of the raid card
On Fri, 2009-03-13 at 11:41 -0700, Ben Chobot wrote:
On Fri, 13 Mar 2009, Joshua D. Drake wrote:
It seems to me that all you get with a BBU-enabled card is the ability to
get burts of writes out of the OS faster. So you still have the problem,
it's just less like to be encountered
I
went to look at initdb. adduser says that postgres user exists, which makes
sense.
I am having a hard time understanding your problem. Why do you have to
recatalog the databases? Why not just createlang -u postgres?
Joshua D. Drake
thanks,
Robert
--
PostgreSQL - XMPP: jdr
not just take a backup of the pitr slave instead? If you need to do
it nightly, shut down the standby process, tar, start standby process.
You never have to bother the master at all.
Sincerely,
Joshua D. Drake
-Glen
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting
sorry but this seems very silly. If you don't want to back up
indexes use pg_dump.
Any chance of something like this being done in the future?
I am going to go out on a limb here and say, no.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development
no longer
do. That suggestion is silly.
*shrug* you can consider it silly. It doesn't change the outcome.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company
to make
any sense.
Creating indexes concurrently is also out because while you are creating
those indexes your performance will tank because everything is
sequential scanning and there is a possibility that the concurrent
creation will fail.
Sincerely,
Joshua D. Drake
-Glen
--
PostgreSQL
is bigger than
yours fight.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list (pgsql-general
On Mon, 2009-03-09 at 18:11 -0500, JohnD wrote:
Hi,
Any idea why I am no longer able to connect?
What does your listen_addresses say on the affected server? Also just to
be safe do a /sbin/iptables -L and make sure you aren't blocking.
Joshua D. Drake
Thanks for any and all help.
John
On Mon, 2009-03-09 at 19:09 -0500, JohnD wrote:
Joshua D. Drake wrote:
What does your listen_addresses say on the affected server? Also just to
be safe do a /sbin/iptables -L and make sure you aren't blocking.
Joshua,
Thank you so much - that was it. My postgresql.conf
.
Doesn't pgAdmin have a scheduler?
Joshua D. Drake
regards, tom lane
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
On Fri, 2009-03-06 at 01:09 +0530, Sathish Duraiswamy wrote:
Can we automate this process , maintained by postmaster itself
No and that would be a bad idea. There has been discussion in the past
of having an IDLE in TRANSACTION timeout but that is a different thing.
Joshua D. Drake
as it allows
further exposure to our great project. Good Work.
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql
On Fri, 2009-02-27 at 13:30 +0100, Tim Tassonis wrote:
Hi all
I remember, a while ago somebody mentioning an odbc driver for postgres
that is not dependant on a working postgres client installation.
Unfortunately I lost the link to it, can anybody remember?
ODBCng?
On Fri, 2009-02-27 at 19:06 +0100, Tim Tassonis wrote:
Joshua D. Drake wrote:
On Fri, 2009-02-27 at 13:30 +0100, Tim Tassonis wrote:
Hi all
I remember, a while ago somebody mentioning an odbc driver for postgres
that is not dependant on a working postgres client installation
space perhaps?)
This is relations which means tables, indexes etc... So unless you
start dropping things, no you can't reduce it.
Just increase it a bit (say 20%) it won't hurt you.
Note it does use a little shared_memory,.
Joshua D. Drake
Thanks
-dave
--
PostgreSQL - XMPP
On Fri, 2009-02-27 at 10:19 +1300, Tim Uckun wrote:
8.4 was scheduled to be released march 1. Do we know what the
All schedules are subject to change within the community :)
tentative date of release is?
When it is done of course.
Joshua D. Drake
--
PostgreSQL - XMPP
.
I am sure that MoteView's license says otherwise.
Sincerely,
Joshua D. Drake
regards, tom lane
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company
On Thu, 2009-02-26 at 15:27 -0800, Ron Mayer wrote:
Joshua D. Drake wrote:
On Fri, 2009-02-27 at 10:19 +1300, Tim Uckun wrote:
[according to some page on the web site...]
8.4 was scheduled to be released march 1. Do we know what the
All schedules are subject to change within
/faqs.FAQ_german.html
Basically for all the languages you get a different lateset
release.
I can fix the press faq but the others will have to go to the
translators project.
Joshua D. Drake
Surely these FAQ entries are doing more harm than good.
Can we please just update all of these to link
On Fri, 2009-02-27 at 01:36 +0100, Alban Hertroys wrote:
On Feb 26, 2009, at 11:02 AM, Grzegorz Jaśkiewicz wrote:
You're the one who's asking a question, it's your responsibility that
we can understand your problem.
Woah... ease up cowboy.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr
://projects.commandprompt.com/public/pitrtools
Just pull down the stable branch:
svn co
https://projects.commandprompt.com/public/pitrtools/repo/branches/1.2
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http
...
I have updated the wiki to make it a bit more friendly.
https://projects.commandprompt.com/public/pitrtools/wiki
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com
On Wed, 2009-02-25 at 12:10 -0600, Justin Pasher wrote:
Is there a reason why the source RPMs for PG 8.1.16 on RHEL don't show
up here?
http://www.postgresql.org/ftp/binary/v8.1.16/linux/srpms/redhat/rhel-4-i386/
If I cycle through the versions, the last version in the 8.1 branch I
can
can't fine the
source RPMs on the yum repo either, just the regular RPMs.
Doh! Yep you are right. Sorry for the noise.
Joshua D. Drake
--
Justin Pasher
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http
called that.
Looks like you didn't run cmd_archiver -C config_file -I
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql
on the pitrtools list. Let's bounce over
there and resolve this.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql
On Wed, 2009-02-25 at 09:21 +0900, Jordan Tomkinson wrote:
On Wed, Feb 25, 2009 at 12:05 AM, Aidan Van Dyk ai...@highrise.ca
wrote:
* Greg Smith gsm...@gregsmith.com [090201 00:00]:
Shouldn't someone have ranted about RAID-5 by this point in
the thread?
On Wed, 2009-02-25 at 09:44 +0900, Jordan Tomkinson wrote:
On Wed, Feb 25, 2009 at 9:23 AM, Joshua D. Drake
j...@commandprompt.com wrote:
RAID5 outside of RAID 0 is the worst possible RAID level to
run with a
database. (of the commonly used raid
a suggestion for a better approach?
Do you want queries, or transactions? If you want transactions you
already have that in pg_stat_database. Just do this every 10 minutes:
psql -U user -d database -c select now() as time,sum(xact_commit)
as transactions from pg_stat_Database
Joshua D. Drake
Tschö
...
Is there a recommended procedure for resolving this safely?
You can use alter type to change the owner of the type to a valid user
but see above. Something is wrong.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503
Source, and AFAICS it looks more suitable for our needs then
Slony-I (we are going to replicate the whole DB). I'm I wrong on this?
Well that would depend on your needs I guess. Slony-I is a fine if
complicated system. I would suggest popping over the the
replicator-general list.
Joshua D. Drake
On Wed, 2009-02-18 at 19:58 -0800, Mike Christensen wrote:
I have two questions actually..
First off, is there a way to remove a database if the postgres.exe
service won't start? It seems if I just delete the data\base\x
directory, then postgres will crash. Is there a way to drop a
columns.
Joshua D. Drake
Cheers,
Steve
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list (pgsql-general
On Wed, 2009-02-11 at 18:01 +, Adrian Klaver wrote:
- Joshua D. Drake j...@commandprompt.com wrote:
Now I am confused. From the docs I get:
My bad. The docs are obviously correct. I think I was thinking about the
postgresql.conf option.
Joshua D. Drae
SET WITHOUT OIDS
On Tue, 2009-02-03 at 18:44 -0500, blackwater dev wrote:
I need to return all rows in a table where one of the columns 'name'
is 37+ characters. In postgres, is there a function to get the length
of the columns contents?
http://www.postgresql.org/docs/8.3/static/functions-string.html
At all...
It should be pg_backup and that is it, with a nice -R flag for restore.
The idea that it is proper to pipe a backup through psql to restore.
Our date handling as a whole (extract,date_part) is wonky. There have
been more than one blog post on this.
Our lack of partitioning :)
Joshua D
values ('fo');
INSERT 0 1
postgres=# insert into test_trunc values ('foo');
ERROR: value too long for type character varying(2)
postgres=# insert into test_trunc values ('foo'::varchar(2));
INSERT 0 1
postgres=# select * from test_trunc;
fname
---
fo
fo
(2 rows)
Sincerely,
Joshua D. Drake
On Fri, 2009-01-16 at 22:09 -0800, johnf wrote:
I'm using python and can execute standard select,update,delete,functions.
What I'd like to do is execute a sql script (a text file). But I don't know
how?
You need to open the text file and pass it as an argument:
try:
file = %s/%s %
60 seconds. You could also pipe
it to a named pipe while an injector was listening.
Joshua D. Drake
--
View this message in context:
http://www.nabble.com/auto-insert-data-every-one-minute-tp20027811p21524797.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com
directory
-p, --port=PORT database server port
-U, --username=USERNAME user name to connect as (not the one to
create)
-W, --passwordforce password prompt
If one of -s, -S, -d, -D, -r, -R and ROLENAME is not specified, you will
be prompted interactively.
Joshua D
the query timeout set to 2
minutes, but I do not know if this can affect vacuumdb or reindexdb
and the time should take much less than 2 minutes anyway.
I am using 8.3.3 on Centos 5.
You have statement_timeout set. You can use SET in psql to change
this
SET statement_timeout TO ...
Joshua D
emails to this list.
It makes it look as if you are not just shouting, but SCREAMING at the
top of your lungs! :-)
The answer to this is to not allow HTML email at all to your client. It
is the first thing I disable on any family/friend/church member that
asks for help.
Joshua D. Drake
://www.georgedillon.com/web/html_email_is_evil.shtml
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql
of them make sure
geeks like us, *EAT*.
Does that mean they are not intelligent or perhaps that there talent set
is just different?
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http
of that. The main job of
the type system is to assist in insuring that your data is correct.
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list
is:
United States PostgreSQL Association
1767 12th Street
#149
Hood River, OR 97031
Sincerely,
Joshua D. Drake
President
United States PostgreSQL Association (PgUS)
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company
On Mon, 2009-01-12 at 18:34 -0300, Alvaro Herrera wrote:
Joshua D. Drake wrote:
Hello,
It is now 2009 and time for a, Thanks for all the laughs 2008!
That's all great, congratulations.
In the future please do not spam multiple lists with the same message.
Or rather, if you want
more pain-free, add a Reply-To:
pgsql-advocacy header or some such.)
Hmm good point. I didn't think about that idea.
Sincerely,
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since
?
How about a paste of the error itself?
Joshua D. Drake
Thanks.
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
configure:
http://brazil.postgresqlconference.org/
If you are a community looking for such help, please don't hesitate to
ask.
It is my hope that this will put an end to the PgCon debate.
Sincerely,
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564
?
Sure. Do this :)
\o /tmp/go_to_lower
select 'ALTER TABLE '||''||tablename||''||' RENAME TO ' ||
lower(tablename)||';' from pg_tables where schemaname = 'public';
psql -U username database /tmp/go_to_lower
Sincerely,
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
they were before.
Not to disparage pgPool, but we have also had great results with
pgBouncer.
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general
On Thu, 2009-01-08 at 15:12 -0500, Josh Harrison wrote:
Hi,
Is there any utility like (oracle's dblink etc) that can establish
connection between oracle and postgres database?
dbi-link
Thanks
Josh
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 -
advice will be greatly appreciated.
An explain analyze of the query would be useful.
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list
on writing installers instead
so they can slip in some commercial advantage...
As both pgAdmin and the one-click installers are fully open source, I
fail to see how this is reasonable. If you don't like how pgAdmin is
packaged, you can always create your own.
Sincerely,
Joshua D. Drake
like Replicator)
keeps its own tree that incorporates the PostgreSQL code.
When open sourcing replicator I tried very hard to convince myself and
others that it was merely a branch of PostgreSQL. I lost that sale :P
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
;-)
Heh fair enough.
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
are the most accurate source of detail.
I think this statement is misleading. The only thing core contains is
the ability to use a bunch of utilities (with the exception of
pg_standby) that aren't in core to provide log shipping.
Sincerely,
Joshua D. Drake
--
PostgreSQL
Consulting
On Thu, 2008-12-11 at 17:37 +, Simon Riggs wrote:
On Thu, 2008-12-11 at 09:14 -0800, Joshua D. Drake wrote:
I think this statement is misleading. The only thing core contains is
the ability to use a bunch of utilities (with the exception of
pg_standby) that aren't in core to provide
, that they will have to roll their own to a degree.
Stop being defensive.
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list (pgsql-general
On Thu, 2008-12-11 at 19:33 +, Simon Riggs wrote:
On Thu, 2008-12-11 at 11:29 -0800, Joshua D. Drake wrote:
As I said before, if you think something is missing, submit a software
or a doc patch and submit it to peer review. Until then, I think its
misleading to claim that only your
On Wed, 2008-12-10 at 15:55 -0500, Eric Schwarzenbach wrote:
Robert Treat wrote:
On Tuesday 09 December 2008 19:43:02 Liraz Siri wrote:
Greg has a good point. Ubuntu is a bit of a moving target. In contrast,
Debian has a much slower release cycle than Ubuntu and is thus
considered by
to it that would be very helpful, thanks!
Sincerely,
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
experience with it.
iii) Is data replication planned for an upcoming release of PostgreSQL,
and if so what are the exact features and when is the release expected?
Planned yes, guaranteed no and it is still log shipping which means read
only slaves are out (as I recall).
Sincerely,
Joshua D
for periodic backups from the primary to the warm standby.
You can. There is a BSD open source project here:
http://projects.commandprompt.com/public/pitrtools
That will help you with your warm standby needs quite a bit.
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support
various
functions (including things like failover).
Sincerely,
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list (pgsql-general
On Thu, 2008-12-11 at 15:21 +1300, Tim Uckun wrote:
What happens when I bring the primary back on line. I now want this to
be primary again and catch up on all the transactions that were sent
to the secondary. I want the secondary to resume it's backup status.
You have to run a new base
as
you can sync from slony (or replicator or whatever).
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
On Wed, 2008-12-10 at 21:39 -0700, Scott Marlowe wrote:
On Wed, Dec 10, 2008 at 8:43 PM, Joshua D. Drake [EMAIL PROTECTED] wrote:
On Wed, 2008-12-10 at 20:41 -0700, Scott Marlowe wrote:
On Wed, Dec 10, 2008 at 7:40 PM, Tim Uckun [EMAIL PROTECTED] wrote:
Log shipping doesn't really lends
On Thu, 2008-12-04 at 13:44 -0300, Gustavo Rosso wrote:
Please, exists postgres forum in spanish?
http://archives.postgresql.org/pgsql-es-ayuda/
Thanks
Gustavo
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL
On Thu, 2008-12-04 at 19:35 -0700, Bill Todd wrote:
Using 8.3.3 I am trying to import a CSV file using the following copy
command.
copy billing.contact from 'c:/export/contact.csv'
with delimiter as ','
null as ''
csv quote as '';
The following record record causes an error because the
on but is it possible for load balancing, i mean with
the two servers active? obviously one of the two should be only for
reading...
No.
You may have two servers pointed at $PGDATA but at no point can
postgresql be running on both at the same time.
Joshua D. Drake
--
PostgreSQL
Consulting, Development
a full restart -- reload won't cause
that parameter to be re-evaluated.
You can change archive_command to something like /bin/true and reload.
However you will have to do a full base backup to get postgresql doing
log shipping again.
Joshua D. Drake
--
PostgreSQL
Consulting, Development
On Wed, 2008-12-03 at 16:23 -0500, Jaime Casanova wrote:
On Wed, Dec 3, 2008 at 1:10 PM, Andrew Sullivan [EMAIL PROTECTED] wrote:
On Wed, Dec 03, 2008 at 09:43:24AM -0800, Joshua D. Drake wrote:
You may have two servers pointed at $PGDATA but at no point can
postgresql be running on both
. ;-)
It could also be that a lot of work is happening off channel. I know
that many contributors are having the first 50 replies of the email on
jabber, irc or directly and then posting to various lists at any given
point.
Joshua D. Drake
--
PostgreSQL
Consulting, Development, Support
in that regard.
Depends on your needs, a broken step is worse than a manual one.
Joshua D. Drake
Now I know why Tom Lane doesn't have a blog :)
--
GJ
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company
On Tue, 2008-12-02 at 00:37 -0500, Greg Smith wrote:
Tom on things that might ruin his tape backups:
Then of course there are the *other* risks, such as the place burning to
the ground, or getting drowned by a break in the city reservoir that's a
couple hundred yards up the hill...Or maybe
=list%3Aorg.postgresql.pgsql-general
Same for -hackers:
http://pgsql.markmail.org/search/?q=list%3Aorg.postgresql.pgsql-hackers
The top Who sent it list is very telling. It says, Paging Tom Lane...
take a vacation! :)
Joshua D. Drake
--
--
Sent via pgsql-general mailing list (pgsql
on Hackers in the past 3 months - well
over twice the historical levels; and maybe 4X 2002-2006.
Its because we eliminated the -patches mailing list.
Joshua D. Drake
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
but a constant after that?
I know that my email (I am pretty sure I am subscribed to at least as
many lists as you) has been on a steady incline, especially through
-general and -hackers.
Joshua D. Drake
regards, tom lane
--
--
Sent via pgsql-general mailing list (pgsql
On Thu, 2008-11-20 at 23:46 -0500, Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
I know that my email (I am pretty sure I am subscribed to at least as
many lists as you) has been on a steady incline, especially through
-general and -hackers.
I would have said the same, which
On Thu, 2008-11-20 at 21:19 -0800, Joshua D. Drake wrote:
On Thu, 2008-11-20 at 23:46 -0500, Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
I know that my email (I am pretty sure I am subscribed to at least as
many lists as you) has been on a steady incline, especially through
over YouTube.
I assume you don't realize that is already happening :P
Joshua D. Drake
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, 2008-11-19 at 17:19 +0200, Devrim GÜNDÜZ wrote:
On Wed, 2008-11-19 at 08:35 -0500, Josh Harrison wrote:
If so can you direct me to the website?
Just a tip... 8.4 isn't released... it isn't even beta yet.
Here is yesterday's snapshot:
?
15ms * 200, 3000ms = 3 secs * 2 (both ways) = 6 seconds.
Joshua D. Drake
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, 2008-11-20 at 15:41 +1100, novice wrote:
omg - how embarrassing.
so sorry :(
I note your name is novice.
Don't sweat it. We are here to help.
Joshua D. Drake
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
/docview.wss?uid=nas191f301ccd7abae2f862565c2007cf178
Joshua D. Drake
Thanks for any input. Or please point me online to any resource that
discusses this kind of info. I could not find any.
PK
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On Tue, 2008-11-18 at 15:28 -0500, Jonah H. Harris wrote:
On Tue, Nov 18, 2008 at 3:09 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
Oh, and citation needed. I don't remember seeing anything about
oracle using indexes as sole storage units back in 8i
Your memory-foo is weak. See
the functionality.
Joshua D. Drake
Regards,
Enrico
--
That's one small step for man; one giant leap for mankind
www.enricopirozzi.info
[EMAIL PROTECTED]
Skype sscotty71
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On Tue, 2008-11-11 at 06:45 -0800, NetGraviton wrote:
Web Application Engineer - Drupal, PHP, CSS, JavaScript, Postgresql
Please use the proper list... pgsql-jobs.
Joshua D. Drake
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
just seemed a little heavy (was
hoping for an alias-sized answer) to figure out something that the
server certainly knows.
show log_filename;
?
Then just grab the strftime string?
Joshua D. Drake
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
--
--
Sent
.
Joshua D. Drake
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
alphabetically will
sort them chronologically (i.e. %Y-%m-%d or something similar) (not easy
to change)
Hmm what about just ls -tu
Which if I am reading the man page correctly sorts by last access time.
Joshua D. Drake
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: http
On Mon, 2008-11-10 at 20:55 +0100, hubert depesz lubaczewski wrote:
On Mon, Nov 10, 2008 at 11:44:31AM -0800, Joshua D. Drake wrote:
Hmm what about just ls -tu
Which if I am reading the man page correctly sorts by last access time.
which might not be what you need. the problem
On Mon, 2008-11-10 at 16:35 -0500, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
It seems that there is enough need for this feature, that it has been
implemented multiple times -- but most of them will fail in corner
cases. Seems an obvious candidate for an in-core function ...
troll the
archives for when this has come up in the past. CMD at one time had a
hacked up version that proved compression was a benefit (even at 100Mb).
Alas it was ugly, :P... If it was done right, it would be a great
benefit to folks out there.
Joshua D. Drake
LZO is under the GPL though
off. Use
views, functions and GRANT.
Joshua D. Drake
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
601 - 700 of 2121 matches
Mail list logo