On Sun, Feb 22, 2009 at 2:32 AM, Tena Sakai tsa...@gallo.ucsf.edu wrote:
Hi,
I am able to revert back to 8.3.3 system. Maybe
I can use 8.3.3 psql to read the dumpall output.
How can I direct the output to data directory of
8.3.6 postgres?
You don't have to dump and restore for a minor
On Sat, Feb 21, 2009 at 12:14 AM, Guillaume Lelarge
guilla...@lelarge.info wrote:
Tino Schwarze a écrit :
[...]
I'm going to pg_restore a database dump of about 220 GiB (uncompressed,
but most data is BLOBs). The machine has 8 GiB of memory and 8 cores.
Is there any advice to speed up
On Fri, Feb 20, 2009 at 10:45 PM, Uwe C. Schroeder u...@oss4u.com wrote:
On Friday 20 February 2009, Tena Sakai wrote:
Hi Scott,
What does explain and (it'll take a while to get
it) explain analyze select ... have to say?
On Sat, Feb 21, 2009 at 1:43 AM, Michael Monnerie
michael.monne...@is.it-management.at wrote:
I managed to recover the data that was still readable. About 650
messageblock entries got lost. What makes me nervous a bit is that
postgres kept running despite (partially) being destroyed. It should
On Sat, Feb 21, 2009 at 1:23 AM, Michael Monnerie
michael.monne...@is.it-management.at wrote:
Also a question: Because I must read all data, the psql client runs out
of memory, trying to cache all the 10GB from that table. I circumvented
this with selecting only parts of the table all the
On Sat, Feb 21, 2009 at 3:11 AM, Tena Sakai tsa...@gallo.ucsf.edu wrote:
Hi Scott,
Thanks for clustering suggestion. I have never used
cluster command and I need to read up before I can
use it.
I have adjusted postgres parameters per your recommen-
dation. Work_mem is now 8GB,
On Fri, Feb 20, 2009 at 7:32 AM, Nicola Mauri nicola.ma...@saga.it wrote:
We run into the following issue with Windows 2003 and Postgres 8.2.6 while
database was running:
FATAL: pg_tblspc/16405/37638 is not a valid data directory
DETAIL: File pg_tblspc/16405/37638/PG_VERSION is missing.
On Thu, Feb 19, 2009 at 9:35 AM, Jessica Richard rjes...@yahoo.com wrote:
I am running vacuum full via a shell script for a list of large databases
now... and I may run out of my scheduled system down time
If I don't finish all databases and kill the script in the middle... am I
going to
On Thu, Feb 19, 2009 at 11:01 AM, Rafael Domiciano
rafael.domici...@gmail.com wrote:
I used to run vacuum full in one of my bases, but now i'm not running
anymore vacuum full, just vacuum analyze in the past 1 month, but the number
of necessary pages is increasing every day, now it's in
On Thu, Feb 19, 2009 at 10:02 PM, Tena Sakai tsa...@gallo.ucsf.edu wrote:
Hi Everybody,
I am running postgres v8.3.3 on redhat linux (del hardware)
with 4 cpu's. This machine is terribly bogged down and I
would like a bit of help as to what can be done.
For last maybe 18+/- hours, there
Look into zero damaged pages setting.
On Wed, Feb 18, 2009 at 2:35 PM, Michael Monnerie
michael.monne...@is.it-management.at wrote:
I have the impression I'm asking the wrong things. Still I try.
Could I do something about this?
psql:/tmp/x:119: ERROR: invalid page header in block 973698 of
2009/2/17 Achilleas Mantzios ach...@matrix.gatewaynet.com:
Στις Tuesday 17 February 2009 10:54:52 ο/η Michael Monnerie έγραψε:
* your daughter with 3.5 years switching off the power supply of the
server
1st line of defense is to set your system to shutdown normally when the power
button is
On Mon, Feb 16, 2009 at 12:52 PM, Rafael Domiciano
rafael.domici...@gmail.com wrote:
Hello for all,
Our bussiness do not tolerate anymore downtime (the downtime is estimate at
10 hour / year - that involves upgrade of hardware, crash of hardware), and
using Slony-I 1.2.15 I have waste time to
On Fri, Feb 13, 2009 at 10:20 AM, Roger Ging rg...@musicreports.com wrote:
Hi,
I'm running vacuum full analyze verbose on a table with 20million rows and
11 indexes. In top, I'm seeing [pdflush] and postgres: writer process each
using diferent cpu cores, with wait time well above 90% on each
On Fri, Feb 13, 2009 at 2:56 PM, Roger Ging rg...@musicreports.com wrote:
Scott,
I can only answer a couple of the questions at the moment. I had to kill
the vacuum full and do a regular vacuum, so I can't get the iostat and
vmstat outputs right now. This message is the reason I was trying
On Fri, Feb 13, 2009 at 2:56 PM, Roger Ging rg...@musicreports.com wrote:
Oh yeah, also, any chance of testing your RAID array in RAID-10 some
day? RAID5 anything tends to be pretty slow at writes, especially
random ones, and RAID-10 may give you a lot more bandwidth where you
need it, on the
On Fri, Feb 13, 2009 at 3:34 PM, Tino Schwarze postgre...@tisc.de wrote:
On Fri, Feb 13, 2009 at 03:13:28PM -0700, Scott Marlowe wrote:
[...]
Yeah, that's pretty bad. ~2 Million live rows and ~18 Million dead
ones is a pretty badly bloated table.
Vacuum full is one way to reclaim
On Fri, Feb 13, 2009 at 5:02 PM, Michael Monnerie
michael.monne...@is.it-management.at wrote:
On Freitag 13 Februar 2009 Roger Ging wrote:
I'm running vacuum full analyze verbose on a table with 20million
rows and 11 indexes. In top, I'm seeing [pdflush] and postgres:
writer process each
On Fri, Feb 13, 2009 at 7:02 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Scott Marlowe scott.marl...@gmail.com writes:
On Fri, Feb 13, 2009 at 5:02 PM, Michael Monnerie
michael.monne...@is.it-management.at wrote:
vacuum_cost_delay = 0
That was the trick for me. It was set to 250(ms), where it took
On Fri, Feb 13, 2009 at 7:24 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Fri, Feb 13, 2009 at 7:02 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Scott Marlowe scott.marl...@gmail.com writes:
On Fri, Feb 13, 2009 at 5:02 PM, Michael Monnerie
michael.monne...@is.it-management.at wrote
On Wed, Feb 11, 2009 at 8:11 AM, Carol Walter walt...@indiana.edu wrote:
Hello,
It seems these functions are not user defined functions, but tsearch
functions. Now, I need to know about tsearch2. I've searched my system and
I don't find the functions that are being called from this database.
On Tue, Feb 3, 2009 at 12:43 AM, A B gentosa...@gmail.com wrote:
Here is mine and yes I have gotten a lot of flack over it. What is the
problem with trying to promote your faith and why do so many people have
problems with it?
I have not looked into exactly what you claim to believe, but
Actually, the ACLU protects CIVIL LIBERTIES, like say, freedom of
speech. I think they'd be on Bruce's side here.
On Tue, Feb 3, 2009 at 7:07 PM, Benjamin Krajmalnik k...@illumen.com wrote:
He must be a card carrying member of the ACLU, and now he thinks he is
the G_d of these lists :)
On Fri, Jan 30, 2009 at 7:52 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Jaume Sabater jsaba...@gmail.com writes:
On Fri, Jan 30, 2009 at 2:22 AM, Tom Lane t...@sss.pgh.pa.us wrote:
We probably should add a caution about this to the manual's discussion
of how to write archiving scripts.
I presume
Really? Really? I'm a Wiccan and I genuinely like Bruce and
appreciate all the work he does for this list. That line is HIS
testimony, it's his truth, and I'm quite happy seeing it go by each
time he writes a message. My girlfriend is Christian (and a few other
things) and I've been to her
Just FYI, searching the mailing list archives, I get 1000+ hits for
Bruce Momjian and the word thanks in the history of the mailing
lists. My name gets 782 or so. Scott Runnion doesn't seem to appear
at all.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to
On Thu, Jan 22, 2009 at 7:50 AM, Jessica Richard rjes...@yahoo.com wrote:
We are going to upgrade our Postgres servers (most 8.2.9 and some 8.2.4) to
the 8.3.x version.
From the postgres web site, I can see the 8.3.5 is the latest version.
Question for people who have been on 8.3.5:
Is
On Mon, Jan 19, 2009 at 5:35 AM, BRAHMA PRAKASH TIWARI
prakashr...@gmail.com wrote:
Hi Francesco
most probabely this is due to the auto vacuum option on and if auto vacuum
is on then the in condition of high transaction on database it slows the
speed of the hole database.Set it off in
On Fri, Jan 16, 2009 at 11:32 AM, Carol Walter walt...@indiana.edu wrote:
Hello,
If I need to rerun configure what else do I have to do. Do I have to run
gmake uninstall? Do I have to run gmake distclean? I've got a running
version of 8.3.4 (on Solaris 10) but I have to reconfigure so
On Tue, Jan 13, 2009 at 10:37 AM, Scott Whitney swhit...@journyx.com wrote:
It ended up locking up about 250 customer databases until I restarted the
postmaster. This is version 8.1.4. Upgrading right now (even to a minor rev)
is not really an option. This box has been up and running for 306
On Mon, Jan 12, 2009 at 2:34 AM, jan-peter.seif...@gmx.de wrote:
Hello,
without success I tried to set the default tablespace via the environment
variable PGOPTIONS.
My tries:
set PGOPTIONS=default_tablespace='pgdata'
set PGOPTIONS=default_tablespace='pgdata'
set
On Mon, Jan 5, 2009 at 6:17 AM, Ygor Degani ygordeg...@gmail.com wrote:
I use postgres-8.3.5. My database has 168 GB in size. Whenever i try to do
vacuum full happens the following error:
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has
What's cybercluster?
On Sun, Jan 4, 2009 at 8:07 PM, Jumping quzhengp...@gmail.com wrote:
i update my database from 8.1.9 to cyberclusterr-1.2.0:
1:dump out my database from 8.1.9
the size of sql file is about 1.3G
the database initdb use /opt/postgresql-8.1.9/bin/initdb -D
Sorry, I was being subtle. I looked it up and it looks interesting.
However, I'm betting there's a mailing list for this software that's
likely to have more people to answer your question than the -admin
list.
I'll have to look it up.
On Sun, Jan 4, 2009 at 9:48 PM, Jumping
On Fri, Jan 2, 2009 at 10:11 AM, Marc Fromm marc.fr...@wwu.edu wrote:
If I gather the sql results with this code
$results = pg_query($dbconn,$query);
I can check if there is no returned data with this code
$rows = pg_fetch_assoc($result);
but if I then use a while loop to display data (if
On Fri, Jan 2, 2009 at 11:09 AM, iog...@free.fr wrote:
pg_fetch_assoc behave like pg_fetch_array: it increments the internal
pointer to the current result.
So if you call it once, then pg_fetch_array will return the 2nd result in
the result set.
Wow, I'm so used to seeing
$rows =
of line;
pg_free_result($result);
pg_close($dbconn);
?
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Friday, January 02, 2009 10:28 AM
To: iog...@free.fr
Cc: Marc Fromm; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] access data in php
On Fri, Jan 2
On Tue, Dec 30, 2008 at 5:28 AM, Bhujbal, Santosh
sbhuj...@starentnetworks.com wrote:
Hi All,
We were getting the following error on executing a COPY command on
postgres8.2.0.
First and foremost, you need to run the latest version of 8.2, not
8.2.0. .0 releases of postgresql tend to have the
On Tue, Dec 30, 2008 at 4:02 AM, Iñigo Martinez Lasala
imarti...@vectorsf.com wrote:
Hi everybody.
Recently our company has been granted with a contract for an on-line store
mainteinance.
The website has been developed under J2EE and Postgres 8.1 as database
backend. The system has been
On Tue, Dec 30, 2008 at 12:56 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Scott Marlowe scott.marl...@gmail.com writes:
On Tue, Dec 30, 2008 at 5:28 AM, Bhujbal, Santosh
sbhuj...@starentnetworks.com wrote:
SQL execution failed, Internal error. SQL Statement: (COPY command failed
with error: ERROR
On Mon, Dec 29, 2008 at 2:23 PM, Carol Walter walt...@indiana.edu wrote:
Hello,
I've just created a new instance of postgres. It's running an a Sun server
running Solaris 10. I configured it with ssl using port 5433. The server
starts and runs. I can connect to it from the local host and
On Wed, Dec 24, 2008 at 9:31 AM, Kevin Kempter
kev...@consistentstate.com wrote:
Hi All;
I'm working on a vacuum monitor script to alert us when tables start to grow
out of control per dead space. Initially I excluded the system catalog
schemas (pg_catalog, pg_toast, etc) however I wonder if
On Wed, Dec 24, 2008 at 12:09 PM, Kevin Kempter
kev...@consistentstate.com wrote:
Thanks for the feedback - where can I find the check_postgresql.pl script ?
http://bucardo.org/check_postgres/
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your
On Tue, Dec 23, 2008 at 11:10 AM, Carol Walter walt...@indiana.edu wrote:
Well, this is sort of interesting. I'm running Solaris 10. The problem was
that I didn't export all of the necessary shared libraries. What's
interesting is that it seems to matter what order these are in, in the path.
On Sun, Dec 14, 2008 at 11:27 AM, Michael Monnerie
michael.monne...@is.it-management.at wrote:
On Samstag 13 Dezember 2008 Matthew T. O'Connor wrote:
Do you have any vacuum delay setting turned on? Perhaps they are too
high?
Oh, I didn't remember there were some for normal vacuum, just the
On Tue, Dec 9, 2008 at 3:11 PM, rocio mejia [EMAIL PROTECTED] wrote:
where are the source to install postgres 8.2.9. ? is someone alive in this
group list?
Is there a reason you need a specific older version? is 8.2.10 not
old enough? Is there a reasons to avoid 8.2.11 that I don't know of?
On Tue, Dec 9, 2008 at 4:10 PM, Steve Kecskes [EMAIL PROTECTED] wrote:
Hi,
Just wondering what actually happens when the connection limit exceeds.
Dec 10 05:19:45 pallas1 postgres[373]: [2-1] FATAL: connection limit
exceeded for non-superusers
Are the requests that are rejected pooled and
On Fri, Dec 5, 2008 at 8:42 AM, Dan Scott [EMAIL PROTECTED] wrote:
Hi,
Is is possible to modify a user password using a command line script?
I know about the ALTER USER command from within the client, but this
looks like it's quite insecure, storing the password in the history. I
know it's
On Mon, Dec 8, 2008 at 6:04 AM, Rafael Domiciano
[EMAIL PROTECTED] wrote:
Hello guys,
I tried to modify my vacuum routine, and started to only run vacuum verbose
analyze diary followed by a reindex weekly.
But I still having problems in my database. The uptime database is hard to
stay below
On Mon, Dec 8, 2008 at 6:04 AM, Rafael Domiciano
[EMAIL PROTECTED] wrote:
Hello guys,
I tried to modify my vacuum routine, and started to only run vacuum verbose
analyze diary followed by a reindex weekly.
Have you tried running autovacuum with a naptime of 10 or 20?
--
Sent via pgsql-admin
On Mon, Dec 8, 2008 at 9:11 AM, Rafael Domiciano
[EMAIL PROTECTED] wrote:
How I do to see my I/O subsystem? vmstat? If so, follow:
No, I mean, how many drives do you have, what kind of RAID controller,
if any, how they're configured, and so on. :) Sorry wasn't really
clear there was I?
The
On Mon, Dec 8, 2008 at 9:29 AM, Rafael Domiciano
[EMAIL PROTECTED] wrote:
1 Drive Only. This server has no RAID.
Do you think that the I/O is very high and I'm needing a RAID?!
Not necessarily. Like I said, my laptop currently is about 25 to 30
times faster writing to disk than your server.
On Mon, Dec 8, 2008 at 10:17 AM, Rafael Domiciano
[EMAIL PROTECTED] wrote:
Here's the output. While the process was running my database get sometime
without doing anything.
You said that I probably get low numbers, but what numbers?
We're looking for MB/s and the bi/bo fields in bmstat (blocks
On Mon, Dec 8, 2008 at 4:27 PM, PJ [EMAIL PROTECTED] wrote:
I am trying to recover postgres databases from a crashed disk.
I have set up a new installation of FreeBSD 7.0 with postgresql8.3.
The old databases are accessible when the repaired disk is mounted :
/oldfsb/local/pgsql/data/base/.
On Sun, Dec 7, 2008 at 1:23 PM, Gerd Koenig [EMAIL PROTECTED] wrote:
Hello,
we're planning an upgrade from Postgres 8.3.1 to latest 8.3.5 via rpm
(Opensuse 10.3 - 64bit).
Is it really that simple ?
1.) stop cluster (e.g. pg_ctl stop)
2.) perform the upgrade (rpm -Uvh *.rpm)
3.) start the
what does explain analyze yourqueryhere say?
On Sat, Dec 6, 2008 at 1:33 PM, Glyn Astill [EMAIL PROTECTED] wrote:
Anyone?
--- On Fri, 5/12/08, Glyn Astill [EMAIL PROTECTED] wrote:
From: Glyn Astill [EMAIL PROTECTED]
Subject: [GENERAL] Planner picking topsey turvey plan?
To: [EMAIL
On Wed, Dec 3, 2008 at 3:34 PM, AmitKumar Jain [EMAIL PROTECTED] wrote:
Hi Team
1. Can we know the how much time will take ongoing vacuum process in DB?
2. Any benchmarking tool for vacuum process.
3. Can we know what exact operations has been done by Vacuum process.
4. I studied that only
On Wed, Dec 3, 2008 at 8:30 AM, Carol Walter [EMAIL PROTECTED] wrote:
Is there a way to tell when the last time a database in a cluster was
accessed? I have a large number of student databases that are probably
inactive, but I don't want to just destroy. I'd like to archive these, but
I need
2008/11/26 Rafael Domiciano [EMAIL PROTECTED]:
The database has around 40 Gb.
If I not use vacuum full everyday the database get very slow.
There is no deadlock on the database.
You didn't mention if you were using autovacuum or not. You also
didn't mention whether or not you'd tried
On Wed, Nov 26, 2008 at 10:21 AM, Rafael Domiciano
[EMAIL PROTECTED] wrote:
I'm not using autovacuum. Regular vacuum goes ok.
To see the last 10 lines of verbose i will need to run vacuum tonight
If a run a reindex before the vacuum full, increase the speed of doing
vacuum? I found something
On Wed, Nov 26, 2008 at 12:54 PM, Matthew T. O'Connor [EMAIL PROTECTED] wrote:
Rafael Domiciano wrote:
I'm not using autovacuum. Regular vacuum goes ok.
To see the last 10 lines of verbose i will need to run vacuum tonight
If a run a reindex before the vacuum full, increase the speed of
2008/11/25 Csaba Együd [EMAIL PROTECTED]:
Hi,
I'm administering a Pg8.3 database with PgAdmin3.
The users need views pre filtered on a session based vairable wich is
stored in a temporary table. Immediately after logging into the database the
client software creates a temporary table and
On Tue, Nov 25, 2008 at 8:48 PM, Jamie Tufnell [EMAIL PROTECTED] wrote:
Hi,
We have been wanting to HA our pgsql server for some time now. We're
actually reaching the limits of our current server now, so there is a
pressing need to do something to ease the load too.
There are several
On Mon, Nov 17, 2008 at 3:35 AM, Gerd König [EMAIL PROTECTED] wrote:
Hello,
we're going to switch from mysql (ver. 5.0.26) to PostgreSQL (OS:
opensuse 10.3).
The mysql database includes several instances, and we only want to
migrate the bugzilla instance to Postgres (yes, it's the bugzilla
On Wed, Nov 19, 2008 at 4:05 PM, Tim Gustafson [EMAIL PROTECTED] wrote:
A workaround: temporarily turn to on the value off the
default_with_oids parameter in your configuration file
(the defaults is off).
I tried that, but still got warning messages about no OID columns when I
imported the
On Tue, Nov 11, 2008 at 5:10 AM, Dilek Küçük [EMAIL PROTECTED] wrote:
On Mon, Nov 10, 2008 at 4:51 PM, Achilleas Mantzios
[EMAIL PROTECTED] wrote:
Στις Monday 10 November 2008 16:18:37 ο/η Dilek Küçük έγραψε:
Hi,
We have a database of about 62000 tables (about 2000 tablespaces) with
On Thu, Nov 6, 2008 at 11:04 PM, Swathi S [EMAIL PROTECTED] wrote:
Hi,
I have a database of size approx 400G. It's a 24/7 database. Only few tables
have regular reads and writes. The other tables just store information.
I would like to upgrade to 8.3 and would like to know the best way to
On Mon, Nov 10, 2008 at 8:50 AM, Dana Holland
[EMAIL PROTECTED] wrote:
Is it at all possible to get pgsql installed on a system without access to a
shell? A friend is wanting me to install a particular bulletin board system
on her website; however, her hosting plan only provides the MySQL
PROTECTED] wrote:
Scott Marlowe schrieb:
On Mon, Nov 10, 2008 at 8:50 AM, Dana Holland
[EMAIL PROTECTED] wrote:
Is it at all possible to get pgsql installed on a system without access
to a
shell? A friend is wanting me to install a particular bulletin board
system
on her website; however, her
On Tue, Nov 4, 2008 at 8:48 AM, Laszlo Nagy [EMAIL PROTECTED] wrote:
Tom Lane wrote:
Huh, that's weird. We've fixed some bugs in the past that led the stats
collector to consume excessive CPU --- but that was all pre-8.3.
The server was rebooting intermittently, so we replaced the RAM (we
On Tue, Nov 4, 2008 at 11:46 AM, Tom Lane [EMAIL PROTECTED] wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
On Tue, Nov 4, 2008 at 8:48 AM, Laszlo Nagy [EMAIL PROTECTED] wrote:
The server was rebooting intermittently, so we replaced the RAM (we got a
kernel page fault). But it was a week ago
On Mon, Nov 3, 2008 at 8:49 AM, Matthieu Roger [EMAIL PROTECTED] wrote:
8.3.3 was also producing the same error, prior version (8.3.1) did not
seem to exhibit it, though we've opened a new universe in the web game
which increased the number of accounts and players in september so
maybe this
On Sun, Nov 2, 2008 at 4:29 PM, Daniel Punton [EMAIL PROTECTED] wrote:
I am dumping postgres 7 tables under the postgres account mydb# pg_dump -O
-a -t mytable mytable.out and am getting either
empty dumps ( actual db tables are populated) or no dump at all.
I have file write permissions and
On Fri, Oct 31, 2008 at 10:02 AM, Alvaro Herrera
[EMAIL PROTECTED] wrote:
Rafael Domiciano escribió:
The vacuum is not full, to run a full vacuum you need to set a cron job;
better to run at the night.
Doing VACUUM FULL on crontab is rarely a good idea. If you find
yourself in a situation
On Wed, Oct 29, 2008 at 11:07 AM, Peter Koczan [EMAIL PROTECTED] wrote:
Hi all,
I'm looking to add an md5-based user to a postgres server, and I can't
seem to get psql to connect using SSL. Normally I use Kerberos to
connect, and that works flawlessly with SSL. I'd much prefer to use
SSL
On Fri, Oct 24, 2008 at 3:00 PM, Robert Young [EMAIL PROTECTED] wrote:
I've solved the issue. pgagent.pga_job.jobhostagent must be blank. Thanks
to this link http://forums.enterprisedb.com/posts/list/1419.page
Anyway, the docs say ... optionally the hostname of a specific machine
running
On Tue, Oct 21, 2008 at 2:29 PM, Scott Whitney [EMAIL PROTECTED] wrote:
It is, is it? I was completely under the impression that it was not. Don't
ask me where I got that impression. :)
No problem whatsoever, in that case!
Thanks for clearing up my inability to comprehend documentation...
On Tue, Oct 21, 2008 at 11:56 AM, Marc Fromm [EMAIL PROTECTED] wrote:
I have the same postgresql databases on two different servers.
Boteh servers have the same version of postgresql, 8.1.
The following backup command creates a file twice as big on one server,
compared to the other server.
On Mon, Oct 20, 2008 at 8:10 AM, Campbell, Lance [EMAIL PROTECTED] wrote:
I would like to have an SQL statement that would move all of the tables and
indexes found within a particular schema to a particular tablespace. Is
there a way I can do this?
I think you'll have to write a script
On Fri, Oct 17, 2008 at 12:24 PM, Isabella Ghiurea
[EMAIL PROTECTED] wrote:
I'm looking for advice in purchasing few good DBA Admin books for
PostgressSQL , any tips?
Well, start with the online docs, they're up to date and have a lot of
good information in them.
--
Sent via pgsql-admin
On Thu, Oct 9, 2008 at 12:56 PM, Marc Fromm [EMAIL PROTECTED] wrote:
I started logging on our server. There are many entries like this:
transaction ID wrap limit is 1073768178, limited by database postgres
transaction ID wrap limit is 1073771864, limited by database sms
Each database has
On Wed, Oct 8, 2008 at 12:08 PM, Kevin Grittner
[EMAIL PROTECTED] wrote:
If the problem is checkpoints (which seems likely but far from a sure
thing based on the information provided), aggressive background writer
setting might be your best bet under 8.2.X. To solve similar problems
we had
On Wed, Oct 8, 2008 at 9:10 AM, Martin Badie [EMAIL PROTECTED] wrote:
Hi,
I have a system that have constant table adds/removes are present. I want to
make a replication between master and slaves but not sure which one is the
best solution for that kind of a situation. Since I am new to
On Wed, Oct 8, 2008 at 5:04 PM, Marc Fromm [EMAIL PROTECTED] wrote:
I just started logging postgresql. In the log are these entries:
478 LOG: transaction ID wrap limit is 1110972072, limited by database
cswe2
479 LOG: transaction ID wrap limit is 1110972072, limited by database
On Mon, Oct 6, 2008 at 5:52 AM, Rafael Domiciano
[EMAIL PROTECTED] wrote:
HI people,
I'm tuning a server that is a long time abandoned, and this server is a
little slow.
What version pgsql is it running? If it's 7.4 or before, you should
look at upgrading it. If you can't then a shared
On Mon, Oct 6, 2008 at 7:56 AM, Rafael Domiciano
[EMAIL PROTECTED] wrote:
I'm using 8.3.3 version in this machine..!
So, the shared_buffers set to 100Mb is ok? Or 500Mb is better?
This server we call Reporter Server, so it's used to do heavy reports for
a few users only (I could say 5 users).
On Mon, Oct 6, 2008 at 12:23 AM, Mohammed Rashid [EMAIL PROTECTED] wrote:
Hi All,
I have use the Postgres database as a client/server architecture.
I mean I want to run the clients on different PCs and want that all
the transactions should get automatically updated in the server.
It should
On Mon, Oct 6, 2008 at 9:00 AM, Rich [EMAIL PROTECTED] wrote:
On Mon, Oct 6, 2008 at 10:08 AM, Scott Marlowe [EMAIL PROTECTED] wrote:
On Mon, Oct 6, 2008 at 12:23 AM, Mohammed Rashid [EMAIL PROTECTED] wrote:
Hi All,
I have use the Postgres database as a client/server architecture.
I mean I
On Sun, Sep 28, 2008 at 2:18 AM, Peter Kovacs
[EMAIL PROTECTED] wrote:
On Mon, Sep 22, 2008 at 4:43 PM, Tom Lane [EMAIL PROTECTED] wrote:
Vladimir Rusinov [EMAIL PROTECTED] writes:
But now I'm getting following error:
pg_dump: WARNING: terminating connection because of crash of another server
On Mon, Sep 29, 2008 at 11:12 AM, Steve Crawford
[EMAIL PROTECTED] wrote:
What it sounds like to me is that you're not vacuuming the system
catalogs, which are getting bloated with dead rows about all those
dropped tables.
Wow, great!
It is not immediately clear from the documentation,
On Fri, Sep 26, 2008 at 2:38 PM, Tena Sakai [EMAIL PROTECTED] wrote:
Hi Scott,
When I issue: /sbin/chkconfig --list | grep postgres
it comes back with:
postgresql_ORG 0:off 1:off 2:off 3:off 4:off 5:off 6:off
postgresql 0:off 1:off 2:on3:on4:on5:on
On Thu, Sep 25, 2008 at 1:59 AM, Claus Guttesen [EMAIL PROTECTED] wrote:
Hi.
I found out by accident that my db-dump, at least in ver. 8.3.3,
automagically converts from iso-8859-1 to utf-8. Our db has been
around since January 2000 and iso-8859-1 was chosen back then as
encoding. When I
On Thu, Sep 25, 2008 at 10:09 AM, BJ Taylor
[EMAIL PROTECTED] wrote:
PANIC: right sibling's left-link doesn't match: block 175337 links to
243096 instead of expected 29675 in index dbmail_headervalue_3
STATEMENT: INSERT INTO dbmail_headervalue (headername_id, physmessage_id,
headervalue)
On Thu, Sep 25, 2008 at 1:42 PM, Tena Sakai [EMAIL PROTECTED] wrote:
Hi Everybody,
About 1.5 month ago, my machine (which runs redhat linux
2.6.9-78.0.1.ELsmp on Dell hardware with postgres 8.3.3)
had a terrible crash. I am mostly recovered, but there
is at least one more thing that's not
I used this very simple little php script to make this
filename: mk55:
#!/usr/bin/php -q
?php
for ($i=0;$i262144;$i++){
print chr(85);
}
?
and ran it:
./mk55 55
ls -l 55
-rw-r--r-- 1 smarlowe smarlowe 262144 2008-09-24 13:41 55
i.e. it's 256k.
And it's attached.
On Wed, Sep 24, 2008 at
No, the file needs to be nothing but hex value 55 throughout. The
attachment I sent earlier is just that:
[EMAIL PROTECTED]:~$ hexdump 55
000
*
004
i.e. all 55s, all the time, not the ascii numbers 5 and 5, but the hex
value. The actual file is
On Tue, Sep 23, 2008 at 2:48 PM, Carol Walter [EMAIL PROTECTED] wrote:
Hi, Folks,
What would cause this error?
SQL error:
ERROR: could not access status of transaction 10274530
DETAIL: Could not open file pg_clog/0009: No such file or directory.
Often it's a problem caused by a virus
On Tue, Sep 23, 2008 at 4:35 PM, Carol Walter [EMAIL PROTECTED] wrote:
Hi, Tena,
Yes, you do recall correctly. It is Solaris 10 and Postgres 8.2.3.
I'm going to run a pg_dumpall and keep my fingers crossed. I'm getting
similar errors when I try to do other things like vacuumdb, so maybe
On Tue, Sep 23, 2008 at 7:59 PM, Walter, Carol Williams
[EMAIL PROTECTED] wrote:
Hi, Tena,
I actually downloaded 8.3.3 last week. The upgrade has been in the plan. I
didn't realize the latest was 8.3.4. I am concerned though. We have so many
dependencies that they never go smoothly.
The
On Tue, Sep 23, 2008 at 10:16 PM, Tena Sakai [EMAIL PROTECTED] wrote:
Hi Carol,
I detect in you some apprehension as to pg_dumpall
won't run or complete. Why is that? Have you already
done it and it didn't work? If that's not the case,
why not run pg_dumpall at a quiet hour and see?
I
401 - 500 of 998 matches
Mail list logo
