ctions (ala ref/ files) and automatically
make function-TYPE.html files?
any thoughts?
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)---
TIP 6: Have you searched our list archive
ace? Coerce? [scrolls] Ahh! Coalesce!"
The trouble seems to be getting that list automatically generated from
the existing SGML.
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)---
TIP 9
th selinux. we just disabled the whole thing to make it work.
For the record:
CentOS 4.0
postgresql-8.0.2-1PGDG.i686.rpm (and associated) rpms from
postgresql.org's ftp server
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
--
On May 6, 2005, at 11:23 AM, Tom Lane wrote:
Jeff - <[EMAIL PROTECTED]> writes:
Eventually we found it was SELinux was preventing pg_dump from
producing output.
That's a new one on me. Why was it doing that --- mislabeling on
the pg_dump executable, or what?
We've got a stock Ce
t one point it didn't
work. (I could also be smoking crack).
Hmm.. piping it into another app worked.
I only found out about this when another developer here tried to run
it and got nothing.
in any case, it might be something useful to jot somewhere.
--
Jeff Trout <[EMAIL PRO
e. Would it be
helpful to other people if I included it as a separate heading for
pl/pgsql in the sgml docs?
Regards,
Jeff
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if yo
han the
previous behavior."
Perhaps it could be more clear? I don't know where else I'd go to find
more thorough documentation on that subject.
Also, I've included a couple typo fixes below.
Regards,
Jeff Davis
--- release.html.old2004-07-25 03:06:28.0 -
Should the text include a mention of synchronous vs. asynchronous? Or
does master-master imply synchronous?
Regards,
Jeff Davis
On Sun, 2005-04-24 at 08:01 -0400, Bruce Momjian wrote:
> Marc G. Fournier wrote:
> > On Tue, 16 Nov 2004, Robert Treat wrote:
> >
> > &g
re more reliably.
Regards,
Jeff Davis
---(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
specific autovacuum settings, or manual
vacuum fulls?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 1: if post
|/" | head -1
which seems to work fairly well. Looks like that thread is here:
http://archives.postgresql.org/pgsql-admin/2005-10/msg00173.php
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908
-1
yields AA as you suggested it would.
The following seems to do the trick if we can rely on alphabetizing to
properly decide the winner of a tie:
ls -tp | head -2 | sort -r | head -1
So, with my previous example, it would look like:
ls -tp /pg_xlog/ | grep -v "backup\|/" | head -2
ange all my scripts to use the following:
ls -t /pg_xlog/ | grep
'^[0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F][0-9A-F]$'
| head -1
Thanks Tom!
top.
Bruce, what does
stat x1 x2
look like on your system? Which OS? Maybe we need caveats for various OSes?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(
Maybe we are
back to using sort to decide the winner of a tie?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP
.0 docs. Is this already in
the 8.1 docs? Should we add a description of the way postgresql does the
md5 hashes in the CREATE ROLE section?
Regards,
Jeff Davis
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore y
On Tue, 2006-10-17 at 21:35 +0200, Peter Eisentraut wrote:
> Jeff Davis wrote:
> > This seems to be lacking in the docs. At least, the only place I
> > found this information was a user comment in the 8.0 docs. Is this
> > already in the 8.1 docs? Should we add a d
e versions for both PostgreSQL and MySQL.
One of my customers is trying it out currently.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(
this in
application code or middleware.
Bruce,
Continuent's uni/cluster middleware product implements this type of
clustering/load balancing. Perhaps it warrants a mention? Not sure how far
we want to get into listing external products.
--
Jeff Frost, Owner <[EMAIL P
On Tue, 14 Nov 2006, Bruce Momjian wrote:
Jeff Frost wrote:
On Tue, 14 Nov 2006, Bruce Momjian wrote:
Your description was too detailed, but I took some of your concepts:
In clustering, each server can accept write requests, and these
write requests are broadcast from the original
can accept write requests, and these write requests
are broadcast from the original server to all other servers before each
transaction commits.
I guess it's kind of a fine line how it gets defined?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.fr
semi-automated ways of bringing failed DB
servers back up to date and online with the rest of the servers in the
cluster. All servers need to be able to accept writes, but do we
differentiate on where the writes originated (i.e. middleware or another
postgresql server) or on functionality?
--
Jeff
ch server can accept write requests, and these write
requests are broadcast from the original server to all other servers before
each transaction commits."
Unfortunately, I can't seem to come up with anything more clever.
--
Jeff Frost, Owner <[EMAIL PROTECT
clustering is not necessarily SQL queries.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 3: Have you chec
of events, is it worth adding a note
to the "migration" section of the release notes?
Regards,
Jeff Davis
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
different than /bin/echo. That's why all my
scripts seem to call the binary and not the built-in.
Another possibility is that the original author had the options set in his
xpg_echo environment variable and forgot about it...or his distro was setting
it in a profile.d file.
--
Jeff F
Pratik,
You should post this to the pgsql-jobs list ([EMAIL PROTECTED]) not to
the docs list if you want to get reasonable responses.
-Jeff
On Wed, 17 Jan 2007, Pratik wrote:
Hi,
This is Pratik with APN Software services, we have urgent direct client
requirement with one of our direct
e, do you think we should say several minutes of downtime? It's been my
experience that the downtime is usually measurable in seconds. I don't think
I've ever had a switchover take more than 1 minute.
Excellent catch and good work by the way!
--
Jeff Frost, Owner <[
table (using triggers) and
index that. Maybe that could be a tip for using GiST indexes.
Regards,
Jeff Davis
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
slow; ..."
to something like:
"Lossiness causes performance degradation due to unnecessary random
accesses to table records; ..."
The only reason I say this is because, on my first reading, I read that
to mean that lossless indexes don't require trips to the hea
In the current version of the docs here:
http://developer.postgresql.org/pgdocs/postgres/functions-sequence.html
The lastval() function appears to be missing from table 9-38.
I don't see any obvious reason that it's left out.
Regards,
Jeff Davis
ronization as well as
connection objects?
Regards,
Jeff Davis
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
es with many partitions each can require raising this setting.
Is "partition" defined somewhere else in the docs?
Maybe it should say something like: "Extensive use of table inheritance
is the most common reason to increase this value from the default",
assuming that's what yo
ng."
http://www.postgresql.org/docs/9.2/static/ddl-partitioning.html#DDL-PARTITIONING-CONSTRAINT-EXCLUSION
Looks like we do define it, so that's fine with me.
Regards,
Jeff Davis
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Where the SQL COPY command warns us not to confuse it with \copy, a
link to \copy would be useful. The attached patch implements that,
but I'm not sure it does so in the preferred way.
Thanks,
Jeff
copy_crossref_v1.patch
Description: Binary data
-
Sent via pgsql-docs mailing list (pgsql
tation) recently appeared on -novice:
http://archives.postgresql.org/message-id/[email protected]
That's exactly the kind of (potential) user we should target with this
document.
Regards,
Jeff Davis
--
Sent via pgsql-docs mailing list (pgsql-docs@post
.0 / 8.4 / 8.3 | devel / 9.2 (beta) |
Old versions: 8.2 / 8.1 / ..."
I didn't read the original rationale, but it's not clear to me why we
have quick links to the documents for unsupported versions. Maybe just
have one link "unsupported versions" that goes to
http://www.po
g to users
b. connects with OOP so the users don't feel like it's a
bait-and-switch or get confused by starting with the
wrong expectation
I feel like making #1 compatible with 2(a) requires some creativity; and
#1 might be incompatible with 2(b) entirely.
Regards,
ritance and composite types are easy enough to understand. Perhaps
those could make for a short example on the O-R side while still looking
different enough from a traditional relational approach.
Regards,
Jeff Davis
--
Sent via pgsql-docs mailing list ([email protected])
To m
to look at the index (eg with \d) to see what the name of
> the desired column is, since index expressions have system-assigned
> column names.
Is this documented anywhere? I couldn't find it. If not, which
section would be the best one to add it to?
Cheers,
Jeff
--
Sent via pgs
#x27;::bpchar, 'Nov'::bpchar, 'Dec'::bpchar]))
> );
>
>
>
> How can add a CONSTRAINT on statuscode array elements to accept values
> between 0 to 5
You can try:
CHECK (statuscode <@ ARRAY[1,2,3,4,5])
Regards,
Jeff Davis
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
: Bruce Momjian
Date: Wed Aug 25 23:55:54 2010 +
Remove docs for "Incrementally Updated Backups" because it was of
questionable reliability; information moved to a wiki:
http://wiki.postgresql.org/wiki/Incrementally_Updated_Backups
Backpatch to 9.0.
Cheers,
On Fri, Nov 23, 2012 at 3:42 PM, Bruce Momjian wrote:
>
> We don't assume people are reading docs from very old versions.
>
Even if that is the version they are using? It is, after all, still
under maintenance,
Cheers,
Jeff
--
Sent via pgsql-docs mailing list (pgsql-docs@post
On Fri, Nov 23, 2012 at 5:36 PM, Bruce Momjian wrote:
> On Fri, Nov 23, 2012 at 04:26:48PM -0800, Jeff Janes wrote:
>> On Fri, Nov 23, 2012 at 3:42 PM, Bruce Momjian wrote:
>> >
>> > We don't assume people are reading docs from very old versions.
>> >
&
On Mon, Nov 26, 2012 at 12:01 PM, Bruce Momjian wrote:
> On Sat, Nov 24, 2012 at 01:56:27PM -0800, Jeff Janes wrote:
>> On Fri, Nov 23, 2012 at 5:36 PM, Bruce Momjian wrote:
>> > On Fri, Nov 23, 2012 at 04:26:48PM -0800, Jeff Janes wrote:
>> >> On Fri, Nov 23,
2PC state files actually are protected by CRC32 (see EndPrepare()), and
so is pg_control (which is not mentioned).
If we want to be thorough, it might be worth mentioning that we expect
filesystem metadata to not be corrupted/lost, either.
Regards,
Jeff Davis
--
Sent via pgsql-docs
ror 1
rm postgres-A4.tex-pdf
I found this older thread with a similar error:
http://www.postgresql.org/message-id/[email protected]
Help?
--
Jeff Frost
CTO, PostgreSQL Experts, Inc.
Phone: 1-888-PG-EXPRT x506
FAX: 415-762-5122
http://www.pgexperts.com/
--
Sent via pgsql-docs mail
On 06/26/13 10:31, Alvaro Herrera wrote:
> Jeff Frost wrote:
>
>> ! pdfTeX error (ext4): \pdfendlink ended up in different nesting level than
>> \pd
>> fstartlink.
> Did you see this one?
>
> http://www.postgresql.org/message-id/3b4139a6e0ceea903dd359b7035d5d4a.
On 06/26/13 10:34, Jeff Frost wrote:
> On 06/26/13 10:31, Alvaro Herrera wrote:
>> Jeff Frost wrote:
>>
>>> ! pdfTeX error (ext4): \pdfendlink ended up in different nesting level than
>>> \pd
>>> fstartlink.
>> Did you see this
On 06/26/13 11:55, Alvaro Herrera wrote:
> Jeff Frost wrote:
>> On 06/26/13 10:34, Jeff Frost wrote:
>>> On 06/26/13 10:31, Alvaro Herrera wrote:
>>>> Jeff Frost wrote:
>>>>
>>>>> ! pdfTeX error (ext4): \pdfendlink ended up in different nes
On Jun 26, 2013, at 12:07 PM, Alvaro Herrera wrote:
> Jeff Frost wrote:
>
>> Yah, it's a different error when it's the wrong openjade version.
>>
>> It looks like this one that's in the docs:
>>
>> openjade:./stylesheet.dsl:664:2:E: flow
On 06/26/13 12:14, Jeff Frost wrote:
>
> I am receiving this when building postgres-A4.pdf for beta2. postgres-US.pdf
> builds fine.
>
> [243.0.11
> ! pdfTeX error (ext4): \pdfendlink ended up in different nesting level than
> \pd
> fstartlink.
> \At
On 06/26/13 12:40, Alvaro Herrera wrote:
> Jeff Frost wrote:
>
>> Alvaro, did both the beta2 PDFs build fine on borka? If so, could you get
>> them to me so I can build the RPMs while I figure out the issue with my
>> tex/jade setup?
> I don't think borka builds
On Jun 26, 2013, at 13:20, Alvaro Herrera wrote:
>> Any idea how to fix it?
>
> Nope, but maybe try to build the PDF using the XML toolchain?
I'm afraid that's a bit out of my depth. I would speculate that since the US
PDF builds and the A4 format is smaller, it's a sizing problem, but I've no
rned) it's just an opaque 32 bits?
It seems like it's worth a note somewhere at least.
Regards,
Jeff Davis
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
er start."
Isn't it unfortunate that the command used for changing the configuration
file from within SQL mentions SIGHUP and pg_ctl reload, but not "select
pg_reload_conf();", as a way to activate that change?
Cheers,
Jeff
On Mon, Jun 15, 2015 at 2:10 PM, David G. Johnston <
[email protected]> wrote:
> On Mon, Jun 15, 2015 at 4:58 PM, Euler Taveira
> wrote:
>
>> On 15-06-2015 13:32, Jeff Janes wrote:
>> > From http://www.postgresql.org/docs/current/static/sql-altersystem.h
/perl has accepted "record" as in argument type since 9.1.
Cheers,
Jeff
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
nk we should just strike the first clause.
Cheers,
Jeff
pg_archivecleanup_doc.patch
Description: Binary data
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
say:
List the table of contents of the archive.
Cheers,
Jeff
pg_restore_TOC.patch
Description: Binary data
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
60 matches
Mail list logo
