I think it's in pgFoundry, though
there may be some stuff in contrib as well.
-Original Message-
From: Alain Rodriguez Arias [mailto:[EMAIL PROTECTED]
Sent: Monday, December 19, 2005 3:10 PM
To: Jim Nasby
Subject: Re: [ADMIN] file in posgres
Naybe you missunderstood me, i need to expo
On Mar 7, 2006, at 2:58 PM, Louis Gonzales wrote:
Based on:
Postgres based Replication Projects
PG Replication
Postgres-R: Dr. Kemme's Site, Paper, Publications, Replication
Work, The Horus Project and Emsemble
DRAGON: Database Replication based on Group Communication
The Slony-1 Project
PGC
On Mar 28, 2006, at 7:55 PM, Scott Marlowe wrote:
On Tue, 2006-03-28 at 19:47, sh test wrote:
Hello admins!
i need to collect as much information
pro/cons on a possible upgrade from
7.4 ---> 8.0/8.1 version
Aside from getting our users vote on this, I wanted to ask you first
in order to col
Can you provide exact error messages here? You're not giving us a lot
of detail to go on...
On Mar 30, 2006, at 11:30 AM, Sriram Dandapani wrote:
Hi
This is the scenario:
Export schema only
On a different postgres box, drop the existing database, recreate
the database and run psql wit
On Mar 31, 2006, at 5:45 PM, Matthew T. O'Connor wrote:
I think the closest approximation of disabling autovacuum on a
per database basis is to connect to the database in question and
perform:
update pg_autovacuum set enabled = 'false';
This will prevent autovacuum from vacuuming or analyzi
On Mar 31, 2006, at 9:29 PM, Tom Lane wrote:
"Matthew T. O'Connor" writes:
I think the closest approximation of disabling autovacuum on a per
database basis is to connect to the database in question and perform:
update pg_autovacuum set enabled = 'false';
Not really gonna help unless you ins
On Apr 3, 2006, at 12:52 PM, Tom Lane wrote:
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
Is there any way to tweak this in favor of more accurate information,
even if has a performance cost? We're finding that during normal
operations we're not seeing most connections added to the
pg_stat_act
On Apr 4, 2006, at 1:29 AM, Tom Lane wrote:
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
It is probably related to something we've been seeing in the
PostgreSQL
logs on the Windows servers:
[2006-04-03 08:28:25.990 ] 2072 FATAL: could not read from
statistics
collector pipe: No error
[20
In the meantime, there is a replacement for COPY on pgFoundry. I
think it's called pgloader...
On Apr 5, 2006, at 6:42 PM, Tomeh, Husam wrote:
I think that's still on the TODO list. A very useful feature that I've
looking forward to as well.
http://www.postgresql.org/docs/faqs.TODO.html
On Apr 17, 2006, at 2:46 PM, Tom Lane wrote:
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
Haven't seen this in previous discussions of OID wrap in the
archives.
The issue is that DDL statements don't make any attempt to skip past
used ranges of OIDs.
duplicate key violates unique constraint "pg
Please include the list in your reply so others can help. I'm also adding
-interfaces.
You're still not showing exact errors, but I suspect this might be a JDBC
issue. Here's what I get:
Session 1:
decibel=# begin;
BEGIN
decibel=# select * from i where i=1 for update nowait;
i
---
1
(1 row)
06 11:12 PM
To: Jim Nasby
Subject: RE: [ADMIN] Regarding installation of postgresql8.1 on windows XP
Hi
Thanks revert back ,I installed it, some what I worked on PgAdmin and
psql to postgres
But here my problem is how to start "startservice."
Thanks and Regards
Srinivas.D
-O
On Apr 28, 2006, at 10:34 AM, Andy Shellam wrote:
My future plan for when my database grows larger, is with the use
of WAL logging – have a base backup taken on a Sunday morning (our
quietest time), ship this to the hot-standby once a week, and start
it off in a recovery mode (using my rolli
On Apr 28, 2006, at 10:23 AM, Andy Shellam wrote:
I've developed and am now testing a new "rolling-WAL" script, and have
noticed something a little peculiar with Postgres 8.1.3.
Note I intend to make this script public once testing has been
carried out -
if anyone is interested in testing
Please include the mailing list in your replies so others can provide input.
> From: Sriram Dandapani [mailto:[EMAIL PROTECTED]
> Most of our reports use a order by limit X...The rowcount in
> some tables
> are > 200 million. (and the table size is about 50-100gb)
>
> Does the fact that constrai
On May 24, 2006, at 2:56 PM, Todd A. Cook wrote:
Tom Lane wrote:
"Todd A. Cook" <[EMAIL PROTECTED]> writes:
I have found that increasing maintenance_work_mem can decrease index
build speed on large tables:
You should probably re-measure when 8.2 comes out; we've fixed a
number
of performanc
On May 25, 2006, at 1:33 AM, hubert depesz lubaczewski wrote:
On 5/23/06, Meyer Marco <[EMAIL PROTECTED]> wrote:
I've been asked for the transaction rate we have on an installed
Postgres server. Where and how can I get this information. I could
not find anything in the documentation. I have r
On May 31, 2006, at 7:56 AM, Ramakrishna Reddy wrote:
Hi,
I need to connect to remote databases using Dblink. Our existing
version is 7.2.1 on Windows and please point me the location of
this package where I can download from and the installation
procedure. I don't find any such package e
On Jun 21, 2006, at 12:00 PM, Tom Lane wrote:
This could be avoided by using COPY BINARY format, but I don't see any
very nice way to do that in the context of pg_dump --- it needs to
intermix COPY data with SQL commands ...
Would the tar or custom format allow for this? IIRC, at least tar
pu
On Jun 22, 2006, at 2:24 AM, Jérôme BENOIS wrote:
We use 7.4.6 version and now we have a bad performance on our
You should upgrade to the latest 7.4 version.
production server. We detected several strange messages in a log
file :
LOG: statistics buffer is full
LOG: statis
On Jun 22, 2006, at 9:52 AM, Jeff Frost wrote:
So, I set it to 3366499. I came up with this number by:
select sum(relpages) from pg_class where relkind in ('r','t');
and adding that up for all the DBs (there is just the one plus
postgres and template1 and now I get th efollowing, so it appears
On Jun 22, 2006, at 9:39 PM, Tom Lane wrote:
Jim Nasby <[EMAIL PROTECTED]> writes:
On Jun 21, 2006, at 12:00 PM, Tom Lane wrote:
This could be avoided by using COPY BINARY format, but I don't
see any
very nice way to do that in the context of pg_dump --- it needs to
intermix COP
On Jun 23, 2006, at 5:31 PM, Jeff Frost wrote:
On Thu, 22 Jun 2006, Jeff Frost wrote:
On Thu, 22 Jun 2006, Jim Nasby wrote:
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: free space map contains 3339998 pages in 125 relations
DETAIL: A total of 3341600 page slots are in use (including
On Jun 24, 2006, at 5:03 PM, Chris Hoover wrote:
What are most of you setting your vacuum and autovacuum parameters
to for your 8.x databases. I just turned on autovacuuming on one
of my db servers and went with a very conservative
vacuum_cost_delay of 200 and vacuum_cost_limit of 50. I am
On Jun 23, 2006, at 12:42 AM, Bruce Momjian wrote:
Mario Splivalo wrote:
On Wed, 2006-06-21 at 21:30 -0400, Bruce Momjian wrote:
Mario Splivalo wrote:
Can I force archiving of the WAL files using CHECKPOINT
statement? My
checkpoing_segments is set to 32, but still archive_command is
beeing
On Jun 26, 2006, at 7:48 PM, Aaron Bono wrote:
Would there be a way to set up the 2 databases - one with the
tables and data and the other that connects to the first with views
into the second database?
google: postgresql dblink
Actually I am interested because I will soon need to set up a
On Jun 26, 2006, at 9:05 AM, Dennis Wagner wrote:
I'm currently thinking about using GUIDs as primary keys.
Look on pgFoundry.org; I'm pretty sure there's some kind of UUID type
there.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive
On Jun 27, 2006, at 3:37 AM, Jorge D wrote:
I'm trying to use jobs. I installed the service as manual saids but
i saw no node on view.
Can anybody tell me what i'm doing wrong.
Assuming that you're using the job agent that comes with pgAdmin,
you'll have better luck asking on their mailing
On Aug 6, 2006, at 6:42 PM, Geoff Parker wrote:
Hi,
I've got a database with about 155GB of binary data, however when I
run the unix utility df, it reports only 60GB of disk space is
being used. I've extracted random samples of data from the
database, and it all appears correct, so I pres
First, you need to upgrade to 8.1.4.
You can redirect STDOUT to /dev/null. Error messages will be sent to
STDERR.
On Aug 7, 2006, at 9:00 AM, Nicola Mauri wrote:
I scheduled a dump between two databases, via network:
pg_dump --clean -U postgres mydb | psql -q -h remote_host -d mydb -
U po
On Aug 7, 2006, at 9:08 PM, Benjamin Krajmalnik wrote:
I have a database whose records are inserted via ODBC.
I turned on logging, and the client is explicitly setting the
client encoding to UTF.
Rows are inserted into the tables. When I do a pg_dump, I do not
get any errors. When I try t
On Aug 2, 2006, at 11:34 AM, Scott Marlowe wrote:
Postgres v7.4.2 (upgrade underway)
If you can get a clean backup, look into at least 8.0. There were
huge
improvements from 7.4 to 8.0. 8.1 is even more impressive. (says
the DBA
who's still running 7.4.13 on all his boxes... :)
Most im
On Aug 6, 2006, at 9:47 AM, Srinivas Iyyer wrote:
I have two databases in my system.
In firstdb i am having the following problem:
firstdb=# \d targets
ERROR: could not access status of transaction 362
DETAIL: could not open file
"/var/lib/pgsql/data/pg_clog/": No such file or
director
On Aug 7, 2006, at 10:36 PM, Geoff Parker wrote:
Unfortunately I didn't notice the problem until I saw the logs
today, and by then it was back tor normal.
Is it safe to assume this is abnormal behaviour?
Probably, unless you had a transaction running for 2 days that was
using space in pgsq
On Aug 8, 2006, at 3:10 AM, Sharma;G.S. wrote:
Dear all,
I have a database of 53GB , i want to know break up of these 53GB .
Is there any command or way through which i can find out that how
much space is used by database,Transaction Log,TempDB, tables
indexes etc.
The sysviews project on h
On Aug 8, 2006, at 7:19 AM, mcelroy, tim wrote:
Thank you Thomas. I've tried it but get a few syntax errors. I
have postgresql 8.0.1 installed and have moved it to /var/lib/pgsql
to mimic Linux so I need to edit the file some more. I'll let you
know how it works.
You need to upgrade. You'
If you must use inserts, you'll get much better performance if you
wrap the restore in a transaction. I think someone came up with a
clever way to do this on the command line, or you could edit the dump
file. Note that if you do this and there's any errors, the restore
will fail.
Also, gr
format).
No,
it's a unix utility. You'd have to dump in plain text output, and then run that
through iconv. There's info about this in the 8.1 release
notes.
From: Jim Nasby
[mailto:[EMAIL PROTECTED]Sent: Tue 8/8/2006 10:48
AMTo: Benjamin KrajmalnikCc: pgsql
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wed 8/16/2006 8:42 AM
To: Jim Nasby
Subject: Re: [ADMIN] Restoring database question, part 2..
Hi there,
one question to your response, are all the tables (especially the pg_*
ones) located under the data/base folder for each
I think you'll probably need to submit a self-contained, reproducible
test case.
On Aug 15, 2006, at 6:00 PM, Sriram Dandapani wrote:
Postmaster was automatically restarted. (didn't crash).
Rules are used to implement the partitioning (and the triggers as
well)
Using postgres 8.1.2
-
it's still pretty
unclear what the use-case for that info is (and without a decent use-
case, it's pretty unlikely that this info will get stored).
So... why is it you want to know this?
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://e
d FROM el_text WHERE el_text.user_id =
112))) AND status=1;
... FROM el_comment c, el_comment tt, el_text t
WHERE ( ( c.parent_id = tt.id AND tt.user_id = 112 AND tt.status = 1 )
OR ( c.text_id = t.id AND t.user_id = 112 ) ) AND c.status=1;
--
Jim Nasby
rpms from suse.
I don't know, but I'm sure someone on the pgAdmin (not pgsql-admin)
list could help. :)
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
--
Jim Nasby
ly useless.
Second, as long as you are vacuuming frequently enough, there's no
reason you should ever have to REINDEX. You certainly shouldn't be
doing it on a regular basis.
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com
I believe there's a
tweakers.net article floating around that did some performance
testing with the new CPUs.
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---(e
it on, you'd see at most one transaction per
insert.
The triggers might use subtransactions. You get implicit
subtransactions if have an EXCEPTION clause in a plpgsql function.
I'm not sure if there's other things that do that as well.
Ahh, I thought that was handled within cmi
table will be unavailable
during the cluster which might be a deal breaker for you.
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
--
Jim Nasby[EMAIL PROTEC
in paying someone to help setting this up, I
know that we (EnterpriseDB) have folks that have done this before. I
suspect that some of the other folks listed on the commercial support
page have done this as well (likely Command Prompt and Varlena).
--
Jim Nasby
On Oct 6, 2006, at 5:39 AM, Kevin Johnson wrote:
You are correct, it is 7.4 we are running on a RHEL3 system.
The database itself is vacuumed via cron 6 times a day.
Jim Nasby wrote:
I didn't see you mention what version you're running; index bloat
shouldn't be a big issue i
to the docsindicate it's not postgresql syntax.is there a quick hack allow the driver and the database to accept thesyntax?Quick? Not really. You'd have to modify the grammar, at a minimum. --Jim Nasby [EMAIL PROTECTED]EnterpriseD
the startup cost is the estimate of how much work it will take to
generate the first row from an operation.
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---(end of broa
Yahoo! Mail beta.
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
tdaily (cost=0.00..4.83 rows=1 width=8)
Index Cond: ((monthdate = '2006-12-01'::date) AND
(kstestssysid = 3143))
If constraint exclusion is on, why are index scans taking place on all
of the tables and not only on the only partitioned table for which th
version of *pg_dump* is much more likely to succeed. It's not a
guarantee, but it should get you pretty close. And as someone else
mentioned, doing a plain text dump is probably your best bet in this
case.
--
Jim Nasby[EMAIL PROTECTE
-- Data for Name: doctors; Type: TABLE DATA; Schema: define; Owner:
postgres
--
INSERT INTO doctors VALUES ('Baker');
INSERT INTO doctors VALUES ('Dow');
INSERT INTO doctors VALUES ('DOW');
Need a quick answer? Get one in minutes from people who know. Ask
your quest
lines in psql.
I think the docs make it pretty obvious which is which, but as a rule
of thumb, people tend to capitalize SQL commands (ie: CREATE
DATABASE), but not the command-line commands.
When in doubt, there's an entire section of the docs that is a
reference to all commands.
-
reload .
While I agree it would be a useful feature, I doubt you'll find much
interest from existing developers to add this. I suspect a patch
would be accepted, though... just make sure and ask on pgsql-hackers
before you start coding one. :)
--
Jim
.
What is the equivalent command in 8.2 (assuming autovacuum is
turned off)
vacuumdb -a will still work, though you might do better to let
autovacuum take care of things since it will only vacuum tables that
need to be vacuumed.
--
Jim Nasby
g in the process list (how can I check if it is working?)
b.) there is a separate program that I should start (where?)
c.) I missed some extra configuration (what should I do?)
d.) something else
Please help me out.
Thanks,
Laszlo
---(end of
broadcast)----
ehind.
Additionally, you can specify an XID when doing a point-in-time
restore; you don't need to find an exact time to restore to.
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
ferenced by any table. The serial
data type is essentially a 'macro' that:
Creates a sequence
Sets the default value for the field to be the nextval() of that
sequence
Sets the field to be NOT NULL
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB
increasing this
parameter?
Yes, increasing max_fsm_relations requires more shared memory. Theres
more information about this in the docs... search for shmmax.
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell
On May 23, 2007, at 10:11 PM, Jair Elton Batista wrote:
How to monitor PgSQL performance, like JConsole for Java Virtual
Machine? Usage of memory, CPU, etc.
Use the OS level tools. There's also a chapter in the documentation
dedicated to monitoring.
--
Jim
will
be having a class in Islen, NJ mid-june, if that's more convenient.
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---(end of broadcast)---
much in Oracle to do so. My guess is it's because Oracle
has to copy the entire deleted row to the undo log as part of the
delete, which would be pretty costly.
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com
/
---(end of
broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://en
e than
a few files.
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an a
ing list cleanly
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
68 matches
Mail list logo
