Hi,
I've been trying to cluster some large tables (more than 10 million
records) and this is the error I keep getting:
"ERROR: expected both swapped tables to have TOAST tables"
and it just stops! Please can someone explain what this means? How do
I fix it? I can find *no* reference whatsoever on
king the files (WAL files only?) across.
Can anyone please tell me what to do here and how to harness the power
of the three SCSI drives that I have. Which files in the data directory
need to be moved? Is this safe? Can backups etc be easily done? Any
information will be greatly
re) to an independant drive and then
creating symbolic links to it to the '/opt/postgresql/data/...'
directory? How do I achieve this without losing any of the data.
Database integrity is of utmost importance and so is speed. I know there
are tradeoffs but I really do think that
uum could
vary, but that is basically why the database reduced to 2GB from 12GB.
VACUUM basically deletes unwanted tuples and indexes and so 'compresses'
the amount of disk space used (and so effectively speeding up queries
two to three orders of magnitude).
Steve
-
Kris Kiger wrote:
Steve,
Are the three SCSI drives raided? If so, I would move the operating
database to that machine. From what I understand it can be a real
hassle to setup/maintain sym-linked tables. If you don't have the
option to move the database, I would explore one of thes
monthly vacuum full on the database and a nightly vacuum
all
Thanks.
Steve.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
od of: psql dbname < sql.dump
Thanks.
Steve
On Thu, 14 Aug 2008 10:30:07 +0200, Thomas Jacob <[EMAIL PROTECTED]>
wrote:
> On Thu, Aug 14, 2008 at 12:06:53PM +1000, [EMAIL PROTECTED] wrote:
>> Hi all,
>>
>> I am curious as to why a pg dump of database "name"
Nice, that has cleared it up.
I am on 8.1 also.
On my test box, a standard dump took 6m 26sec & a -Fc dump took 11min 2sec.
That's not a great difference, but the size difference is quite noticeable.
Thanks for your help.
Steve.
On Fri, 15 Aug 2008 02:15:25 +0200, Thomas Jaco
I am also curious as to why an SQL dump from the production server would
come out to 2.8G but a dump of an exact replica on a test box would come
out to 3.0G. What determines the size and makeup of an SQL dump?
Cheers.
Steve.
On Fri, 15 Aug 2008 12:24:32 +0200, Tino Schwarze <[EMAIL PROTEC
Hi all,
Is there a way to make the postgres logs readable by other users or a group
apart from postgres:postgres?
I am on postgres 8.1
I cannot see any feature to allow setting perms or ownership
Thanks
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes
Yeah, thought about that but as you said the perms on the logs are 700. on
both stderr and syslogging.
On Mon, 25 Aug 2008 19:22:45 -0700, Joshua Drake <[EMAIL PROTECTED]>
wrote:
> On Tue, 26 Aug 2008 14:11:13 +1200
> Steve Holdoway <[EMAIL PROTECTED]> wrote:
>
>> O
Correction, perms are 600.
On Mon, 25 Aug 2008 19:22:45 -0700, Joshua Drake <[EMAIL PROTECTED]>
wrote:
> On Tue, 26 Aug 2008 14:11:13 +1200
> Steve Holdoway <[EMAIL PROTECTED]> wrote:
>
>> On Tue, 26 Aug 2008 10:42:19 +1000
>> <[EMAIL PROTECTED]> wrote:
>
Hi Richard,
This means a file systems backup. eg.
tar -cvpf data_bakup.tar /var/lib/pgsql/data
Here's a script I use to automate this process. It may be helpful to
customize for yourself.
#!/bin/bash
#
# PostgreSQL Weekly Backup
#
DATE=$(date +%G%m%d)
MAILLOG="/backup/weekly_$DATE.log"
WALAR
0001223387 would usually be the next WAL to be written.
How often are you WALs written out?
On Wed, 27 Aug 2008 07:07:17 -0700 (PDT), [EMAIL PROTECTED]
wrote:
> I have a question regarding the WAL files that are moved during a backup
to
> the "archive directory".
>
> I have setup
ready knows.?
On Wed, 27 Aug 2008 13:49:13 -0700 (PDT), [EMAIL PROTECTED]
wrote:
> Steve, thanks for your response and your question.
>
> Ok, here is some clarification on the WAL file name used in the example
> below.
>
> The WAL file name I used in the example is actually
> 000
WAL's. You can
add the current X log to the WAL and recover your DB to its existing state.
On Thu, 28 Aug 2008 05:24:56 -0700 (PDT), [EMAIL PROTECTED]
wrote:
> Thanks Steve.
>
> If I understand your comment regarding the 16MB limit, it means I should
> not worry about the WAL file
?
Cheers
Steve.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Is there any negative effects by doing this?
The swappiness is sitting on the default 60 at the moment.
On Wed, 17 Sep 2008 00:46:13 -0600, "Scott Marlowe"
<[EMAIL PROTECTED]> wrote:
> On Tue, Sep 16, 2008 at 11:30 PM, <[EMAIL PROTECTED]> wrote:
>> Hi All
>>
>>
>> I recently made a change to my
Anyone know what I am doing wrong?
TIA
Steve
gure --with-template=solaris_sparc_gcc --with-tcl --with-perl --with-odbc
and xsubpp reported no error.
Could anybody help me with this problem? Thanks a lot!
Steve
standard debian jdk1.1 and postgres 6.5.3 packages.
I can't seem to find a lot of info on these errors as they might relate
to java.
Any help greatly appreciated!
Thanks,
Steve Doerr
Can anyone tell me where this 'serials' relation is stored?
I had been getting a call handler error, which I was able to resolve by
clearing out pg_proc and I wondered if anyone could tell me how to clear
out the 'serials' relation.
Thanks,
Steve
database, but the "\z" shows
the same thing after that.
When I run a shell script that's supposed to dump and recreate the db and user
w/ java I get:
Trace:
java.sql.SQLException: ERROR: Relation 'serials' already exists
Is that how you're supposed to clear out the serials relation?
Thanks for the input,
Steve
bangh wrote:
> Hi steve,
>
> Your command should be like:
> iosdb=>drop sequence "classtable serials";
>
> Use the real name of the sequence, you cannot use serial to imply your sequence
> name. Your sequence seems having space. this is why you need to use the
.
Thanx, Steve.
y
problems?
|--|
| Steve Sargent, Vox +44 020 7775 3220, Fax +44 020 8980 2001 |
| QMW Computing Services, Mile End Road, London E1 4NS, UK |
| Email : [EMAIL PROTECTED] |
| WWW page: http://www.qmw.ac.uk/~cgaa160/
This is what is returned:-
NOTICE: PerformPortalFetch: portal "c_1" not found
|------|
| Steve Sargent, Vox +44 020 7775 3220, Fax +44 020 8980 2001 |
| QMW Computing Services, Mile End Road, London
un Solaris V2.7
|------|
| Steve Sargent, Vox +44 020 7775 3220, Fax +44 020 8980 2001 |
| QMW Computing Services, Mile End Road, London E1 4NS, UK |
| Email : [EMAIL PROTECTED]
ng and hope someone might have some input.
Thanks,
Steve
esn't seem to distinguish between PRIMARY KEY
and UNIQUE.
That's probably enough for now. Thanks in advance for any help.
-- sgl
--
Steve Lane
Senior Project Manager
Chris Moyer Consulting Inc., Chicago
833 W. Chicago Ave. Suite 203
Chicago, IL 60622
312 433-2421 (V)[EMAI
I saw that outer joins will be supported in ver. 7.1. Does anyone know
when this is expected, or if there is beta support for them currently?
Thanks,
Steve
bunch of CASE statements the
sole point of which is to transform the occasional NULL into a 0.
Object sizes are computed from pg_class.relpages with an assumed page size
of 8192.
Comments and improvements most welcome.
-- sgl
Steve Lane
Vice President
Soliant Consulting, Inc.
(312) 850
ow run the query
select * from myfile;
--Quit and check your results
\q
If you have a very large table you can exhaust memory on the client
side unless you are writing the data directly to a file.
Cheers,
Steve
---(end of broadcast)---
TIP 1: subs
orders of magnitude. Depending on the nature of your data this may
help or do nothing at all.
Of course you are going to hit RAM or disk limitations on any given
machine. Cursors are there for your use and your project may require
them.
Cheers,
Steve
---(end of
st have a shell script that would do that automatically?
Or will postgres 8 rebuild an index if it doesn't find it where it expects?
I recognize, or think I do, that PG 8 tablespaces would be required to
accomplish this.
Would this be insane? Has anyone done it?
Steve Lane
Vi
-- sgl
> From: Chris Travers <[EMAIL PROTECTED]>
> Date: Fri, 29 Jul 2005 09:50:07 -0700
> To: Steve Lane <[EMAIL PROTECTED]>
> Cc:
> Subject: Re: [ADMIN] Indexes on RAM disk = insanity?
>
> Steve Lane wrote:
>
>> All:
>>
>> We have a po
aring on stdout?
Formerly, I would always redirect stdout and stderr to the same logfile. I
tried that here, starting postmaster with 1>&2 (instead of 2>&1 as I used
to) but it doesn't seem to help.
Am I barking up the wrong tree?
-- sgl
Steve Lane
Vice President
Here's an example:
2005-08-12 15:12:43 CDT 12465 LOG: XX000: could not create IPv6 socket:
Address family not supported by protocol
2005-08-12 15:12:43 CDT 12465 LOCATION: StreamServerPort, pqcomm.c:337
These semm to be appearing in the written logs as well.
-- steve
> From: Alvaro
Note, if you use tuples only, you don't need to turn
off the footer separately. You can also use the short versions of all
the command line switches if you prefer. "man psql"
Cheers,
Steve
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Tuesday 08 November 2005 05:10, Lane Van Ingen wrote:
> What does the 'c' part of the -tc command do? It is not documented
> in any information I have.
Show tuples only (per psql --help)
Cheers,
Steve
---(end of broadcast)---
TI
inful to reproduce.
Getting a bit desperate here, 7 years on PostgreSQL and never had a
problem like this before!
Thanks,
Steve
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
and
http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
Why are you using 7.4.8 instead of the current version of PostgreSQL?
Cheers,
Steve
---(end of broadcast)---
TIP 4: Have you
d by the specifics of your setup - I use one
hour).
Cheers,
Steve
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Hi Steve,
Thanks! for the quick reply, I thought about rsync too, but wasnt
sure about completely how it handles partial files. I use rsync for all
the backups, it works fine for all the application except for our mail
application it copies the files but at the end of the job it gives me
the dump
of one of these databases was:
/usr/local/pgsql/bin/pg_dump -Fc -b mydatabasename > /back/mydatabasename.dump
I looked through the docs to see if there was some runtime configuration I was
missing, but saw nothing.
Anyone know what I might be doing wrong?
Thanks,
--
Steve Linabery,
On Thu, Mar 30, 2006 at 11:14:37AM -0500, Tom Lane wrote:
> Steve Linabery <[EMAIL PROTECTED]> writes:
> > Last night during backup, I noticed that I could not get a connection,
> > either remotely via jdbc or locally via psql. Well perhaps that is
> > inaccura
ram and a half-terabyte RAID10 array on a DELL
PERC scsi subsystem, with a load average of around 0.5 - 0.6, so it's
not exactly overstretched.
Thanks,
Steve
round problem. I had to work very hard and was very lucky to
recover it all. Please upgrade ASAP, it will be unpleasant, you may
have to adjust code in some applications because of syntax changes
etc., but that's a lot cheaper than losing your data.
Steve
Tom Lane wrote:
"Shi
Just to say thanks to all for your constructive and helpful replies - I
will build a new server with 8.1 and slony.
Steve
Steve Burrows wrote:
I am struggling to find an
acceptable way of backing up a PostgreSQL 7.4 database.
The database is quite large, currently it occupies
g stderr (add something like 2> ~/pg_dump.err to your
crontab command) and see if any errors are being generated. (Most cron
implementations will send an email if anything is output to stderr or
stdout but this assumes that the crontab user's email is actually routed
to someplace that i
ll need to also determine the order in which to put data back into
the target server in order to avoid violating foreign-key restrictions.
Sounds like a headache. Good luck.
Cheers,
Steve
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
value too long for type character
varying(255)' no matter what I try.
And yes, I inherited this!
Cheers,
Steve
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to
On Thu, 30 Nov 2006 18:12:31 +0200
"Milen A. Radev" <[EMAIL PROTECTED]> wrote:
> We have a big DB that's backuped nightly using pg_dump in the custom
> format. Most of its size are several thousand large objects. During
> the dump of those LO the machine is heavily loaded so we are looking
> for a
===
Steve Lane
Vice President
The Moyer Group
14 North Peoria St Suite 2H
Chicago, IL 60607
Voice: (312) 433-2421 Email: [EMAIL PROTECTED]
Fax: (312) 850-3930 Web: http://www.moyergroup.com
===
On Monday 03 November 2003 5:19 pm, Steve Lane wrote:
> Hi all:
>
> We maintain a number of web-based applications that use postgres as
> the back end
>
> The client responded that surely this problem of monitoring a
> database-backed web app was a known, solved problem,
Thanks to all who gave me responses on this issue. A number of you
recommended Nagios (www.nagios.com), and a quick inspection does suggest
that this is a very useful tool. I plan to look into it further.
-- sgl
===
Steve Lane
Vice President
Hello all:
Are there any known incompatibilities between postgres and RedHat 9? Is
there a minimum version of postgres I should be using on RedHat9?
-- sgl
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan
output is plain text and should
be usable to restore on any other system.
Cheers,
Steve
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ter or different
approach, or other things we should consider?
Any and all thoughts are welcome.
-- sgl
=======
Steve Lane
Vice President
The Moyer Group
14 North Peoria St Suite 2H
Chicago, IL 60607
Voice: (312) 433-2421 Email: [EMAIL PROTE
there anything I should be learning from this?
-- sgl
===
Steve Lane
Vice President
The Moyer Group
14 North Peoria St Suite 2H
Chicago, IL 60607
Voice: (312) 433-2421 Email: [EMAIL PROTECTED]
Fax: (312) 850-3930
On 2/6/04 12:23 AM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Steve Lane <[EMAIL PROTECTED]> writes:
>> Now we want to use COPY to bring the data in. The target table has 6
>> indexes. Without indexes, naturally, we can load 80K rows in 2 seconds. With
>
On 2/6/04 12:30 AM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Steve Lane <[EMAIL PROTECTED]> writes:
>> When I drop and rebuild the indexes, they take oddly varying amounts of time
>> to rebuild. I rebuilt them in the following order, with the following rough
&g
oot. To change on a running system:
echo 256 > /proc/sys/vm/max-readahead
echo 128 > /proc/sys/vm/min-readahead
This advice was specific to the 3Ware card on Linux.
Cheers,
Steve
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Franklin): http://webexhibits.org/daylightsaving/
US Daylight Saving Time starts this year on April 4 when 0200 jumps to
0300. The answers PostgreSQL gave are correct.
Cheers,
Steve
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Wednesday 03 March 2004 3:19 pm, Tom Lane wrote:
> Steve Crawford <[EMAIL PROTECTED]> writes:
> > US Daylight Saving Time starts this year on April 4 when 0200
> > jumps to 0300. The answers PostgreSQL gave are correct.
>
> I suspect what the OP wants is non-timezone
increase the bloat in the other table and the bloat would be small.
Performance would probably improve as well due to smaller file sizes
and less read/write action on the disks.
Cheers,
Steve
---(end of broadcast)---
TIP 3: if posting/reading throu
lesystem, or what posix semantics can be relaxed?
Cheers,
Steve
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
n is the one about RAM per connection. Any
thoughts'd be much appreciated.
-- sgl
===
Steve Lane
Vice President
The Moyer Group
14 North Peoria St Suite 2H
Chicago, IL 60607
Voice: (312) 433-2421 Email: [EMAIL PROTECTED]
Fax: (312)
> From: Tom Lane <[EMAIL PROTECTED]>
> Date: Wed, 12 May 2004 16:13:37 -0400
> To: Steve Lane <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: [ADMIN] RAM usage per connection
>
> Steve Lane <[EMAIL PROTECTED]> writes:
>> I have a custome
Hello all:
I have a database that is exhibiting sluggishness under load. Suspecting
that some queries may be poorly optimized, I turned on a fair amount of
debugging output in the logs. But I could use some help interpreting it.
For the record, this is Postgres 7.2.1. I've already been rightly c
> From: Tom Lane <[EMAIL PROTECTED]>
> Date: Tue, 18 May 2004 21:06:43 -0400
> To: Steve Lane <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: [ADMIN] Interpreting query debug output
>
> Steve Lane <[EMAIL PROTECTED]> writes:
>> I have a d
Apologies in advance for the somewhat off-topic post. This is quite a
sophisticated group so it strikes me as the right group of people to ask.
I'm trying to find someone experienced in scaling open-source,
database-backed web applications. Particularly, I have an application based
on Linux-Apache
Hello all:
I have several customers that I need to upgrade to postgres 7.4.
Unfortunately they are also using somewhat older versions of PHP as well
(4.1 and 4.2). Does anyone know offhand if there are any compatibility
issues between PHP 4.1/4.2 and postgres 7.4?
I'm opening to upgrading PHP as
There's something very much like that: phpPgAdmin.
http://phppgadmin.sourceforge.net/
:-)
-- sgl
> From: Michael Holden <[EMAIL PROTECTED]>
> Date: Tue, 22 Jun 2004 10:09:42 -0700
> To: [EMAIL PROTECTED]
> Subject: [ADMIN] phpmyadmin type thing for postgre?
>
>
> Hey folks
>
> Just getti
Janio:
My experience of various Linux distributions is not very wide. But I'd be
surprised if slackware didn't have some variant of the su -c command, which
is what I generally use to start postgres from rc.* scripts.
A line like
su postgres -c "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsq
running Fedora Core 1 with the vendor provided 7.4.2-1 rpms, and
stock Fedora Core 1 apache and mod_auth_pgsql. PHP is 5.0.0 from
php.net.
So, is my information old, and md5 is "just standard" now? Or is
something else going on?
Thanks,
Steve Bergman
---
Thanks, Tom, that's very helpful. One more clarification: if the underlying
column has no express length limit (for example, it was defined as type
'text'), is this issue moot?
-- sgl
> From: Tom Lane <[EMAIL PROTECTED]>
> Date: Thu, 12 Aug 2004 23:57:11 -0400
> To: slane <[EMAIL PROTECTED]>
> Cc
Hi,
I run fedora rawhide and would like to try out the beta, but I like
keeping things "neat and tidy" using SRPMS where possible, as opposed to
tgz.
Anyone have an SRPM of spec file for the beta?
Thanks,
Steve
---(end of broadcast)---
1 sshd[41006]: error: connect_to localhost
> port 5432: failed.
> ---
>
> Am I missing something obvious?
Is PG set to accept tcp/ip connections? Check postgresql.conf for:
tcpip_socket=true
127.0.0.1 is connecting through tcp/ip, not local domain sockets.
Cheers,
Steve
-
foo set serialnumber = nextval('foo_sequence') where
serialnumber is null;
alter table foo alter column serialnumber set not null;
Cheers,
Steve
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Hello all:
I'm seeing some very odd query behavior on postgres 7.1.3. I know that's way
out of date, and I do have a plan in place to upgrade, but any immediate
help will be, well, very helpful.
I have a server running two instances of postgres: 7.1.3 and 7.4.3. Each
supports a different web appl
> From: Tom Lane <[EMAIL PROTECTED]>
> Date: Wed, 25 Aug 2004 15:16:32 -0400
> To: Steve Lane <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED], Jamie Thomas <[EMAIL PROTECTED]>
> Subject: Re: [ADMIN] Odd query behavior [urgent, but long]
>
> Steve Lane <[E
Hola Edgar:
Spanish is not my native language -- perhaps you can do about as well with
my English as I did reading your post :-)
What exactly happens? PHP doesn't build? Or doesn't even configure
correctly? What's the output from configure?
-- sgl
> From: "Edgar Cante" <[EMAIL PROTECTED]>
> Dat
memory
??
-- sgl
> From: Steve Lane <[EMAIL PROTECTED]>
> Date: Wed, 25 Aug 2004 14:26:52 -0500
> To: Tom Lane <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>, Jamie Thomas <[EMAIL PROTECTED]>
> Subject: Re: [ADMIN] Odd query behavior [urgent, but long]
>
>
My odd "double" queries continue. On the theory that I had some kind of
page-faulting issue tied into large, frequent updates of a table, I vacuumed
the whole database and began to watch it closely this morning. Already,
after very little activity, I get this in the log:
2004-08-26 07:01:26 [22056
miss? The example of sequential reads on a
non-interleaved hard drive comes to mind, but I can't imagine that that's
useful except in some vague metaphorical way ...
-- sgl
> From: Tom Lane <[EMAIL PROTECTED]>
> Date: Thu, 26 Aug 2004 10:51:21 -0400
> To: Steve Lane <[
Hello all:
I'm hoping I'm wrong, but I think I'm looking at a corrupted table or database. We
have a column that's sequence-driven, with a unique index, but we're seeing duplicate
values in that column. We're also seeing duplicate OIDs in the affected table. And
we're seeing this ominous messag
re RAM) and can easily run a count(*)
of a 4+ million row table in well under 4 seconds which makes me
suspicious of your vacuuming.
Cheers,
Steve
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
nly showed pg processes from top. What is the swapping activity
on your machine? Do you have memory left over for caching?
Cheers,
Steve
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
later timestamp had "more" data. So we picked the latest records by
timestamp and brought them back in.
We've found similar instances on other indexes, but let me start there.
Any ideas? Can MVCC "leak" stale rows back into the "live" space?
-- sgl
---
Sorry -- 7.4.5
-- sgl
> From: "Joshua D. Drake" <[EMAIL PROTECTED]>
> Date: Wed, 09 Feb 2005 17:26:12 -0800
> To: Steve Lane <[EMAIL PROTECTED]>
> Cc: , Jesse LaVere <[EMAIL PROTECTED]>
> Subject: Re: [ADMIN] PG 7.4: duplicate rows in violation
while, and only
found them during the checks we did after the process crashes.
Does 7.4.6 incorporate the patch for this?
-- sgl
> From: Tom Lane <[EMAIL PROTECTED]>
> Date: Wed, 09 Feb 2005 23:50:47 -0500
> To: Steve Lane <[EMAIL PROTECTED]>
> Cc: "Joshua D. Drake
> From: Tom Lane <[EMAIL PROTECTED]>
> Date: Wed, 09 Feb 2005 23:50:47 -0500
> To: Steve Lane <[EMAIL PROTECTED]>
> Cc: "Joshua D. Drake" <[EMAIL PROTECTED]>, ,
> Jesse LaVere <[EMAIL PROTECTED]>
> Subject: Re: [ADMIN] PG 7.4: duplicate
server
than you assumed if you have multiple servers.
2) You don't really have 200 connections (did you restart after
changing your config?)
3) Your app is making more connections than you think. (Doing any
pooling??)
4) Your apps aren't closing connections that
more importantly, the best way to keep them under control.
Cheers,
Steve
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Thursday 17 March 2005 3:15 pm, Steve Crawford wrote:
> I'm having trouble with physical growth of postgresql system
> tables
Additional info. The most recent autovacuum entries for the
pg_attribute table are:
[2005...] Performing: VACUUM ANALYZE "pg_catalog"
old so you can't drop the old table till you drop
the view. You will then have to recreate the view. Of course there
can be numerous views referring to the table and other views
referring to some of those views and pretty soon the whole thing can
become a terrible mess.
Cheers,
Steve
---
On Thursday 17 March 2005 3:51 pm, Tom Lane wrote:
> Steve Crawford <[EMAIL PROTECTED]> writes:
> > My autovacuum config is running and I do see regular periodic
> > vacuums of these pg_ tables but still they grow.
>
> Do you have the FSM settings set large enough to
ill leaves you with determining why the connections are there which
will again probably be a question for Jboss or your developers.
Cheers,
Steve
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
k into the new features in 8.x that
allow you to do continuous on-line backups:
http://www.postgresql.org/docs/current/static/backup-online.html
Scheduled tasks are probably best handled from a *nix machine -
perhaps the server itself. The cron+script+psql combo can go a long
way.
Cheers,
1 - 100 of 266 matches
Mail list logo
