blem" to
be persistent.
In your example the backend has been alive and in the pool since 9/11 and
the most recent time it was used was 10/2. In between those two dates there
were many other times the connection was used.
David J.
--
View this message in context:
http://postgresql.1045698
anism that would not be readily partitioned.
David J.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/partitioning-system-tables-tp5773152p5773155.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsq
x27;ve personally experienced, it would be nice
to be able to suppress the warning explicitly (but just that specific one) -
but alas that is not currently possible that I am aware.
David J.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Catch-exceptions-outside-functio
the
documentation.
Exceptions should not occur (or do so rarely) and so they cannot be simply
ignored. If you have code that you expect to throw an exception you should
try to rewrite it to test first and return true/false for availability. not
always possible so catch and savepoints are ther to
sappeared.
> Was that just a wrong database name in the error message?
Likely auto-vacuum kicked in and took care of the wraparound issue while the
system was handling your manual vacuum routines...but that is just a theory
David J.
--
View this message in context:
http://postgresql.1045698
o
allowing new connections. The cost-benefit of such a feature is fairly
small though.
Having done this your decision is to either kill the long-running stuff and
get the reboot over with or let it run and effectively make the server
unavailable for a while but you end up not having to re-do whate
een doing any kind of testing
for this thread so I'm just reporting my existing understanding and what is
shown in the documentation without verification.
David J.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/question-on-the-information-schema-tp57683
nimal example working (even/especially if
incorrectly) and then supply the entirety of that example so we can review
exactly what you are doing. If you can get the example to work then the
system is functioning and it is only your specific configuration that is
broken - which again mean
hose in information_schema and
pg_catalog. Why do you expect the query to return any results?
More generally it is very helpful to explain "why" you are doing something
and not just show - especially incompletely - what you are doing.
David J.
--
View this message in context:
http
SSD disks; he
claims a shortage of Intel SSD drives. I know too little about non-Intel
SSDs to feel comfortable with them.
o One of our two database servers is 200km away, so swapping out SSDs on
a prophylactic basis is not particularly appetizing.
Regards,
David.
--
Sent via
spaces with hand-placed tables and indexes on the
other two, and only 7200 RPM disks.)
So I think 16 10Krpm spinning disks will probably suffice; the failure mode
of SSDs makes me nervous.
Regards,
David.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to
age with SSDs.
3) Our current workload peaks at about 5000 transactions per second;
you can assume about one-third to one-half of those are writes. Do
you think we can get away with 16 10Krpm SATA drives instead of the
SSDs?
Regards,
David.
--
Sent via pgsql-admin mailing list (pgsql-admin@p
Alvaro Herrera-9 wrote
> David Johnston wrote:
>> Wojciechowski, Robert (GE Transportation) wrote
>> > [...] there is a database that shows this connect grant to a user that
>> was
>> > known as foo1_userA (oid 3562339547): 3562339547=c/postgres
>>
>>
a bug. The sentence I quoted above leads me to think
operator-error.
David J.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-was-I-able-to-drop-a-role-even-though-objects-depend-on-it-tp5762049p5762060.html
Sent from the PostgreSQL - admin mailing list arch
what happens.
see:
http://www.postgresql.org/docs/9.1/interactive/release-9-1.html
Section E.10.2.1
for details.
Again, it is impossible to really provide help without knowing exactly what
is being sent to, and more importantly received by, the PostgreSQL server.
The error message you provided i
tract 2 from a byte.
Regards,
David.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
is sufficient
Great! Thanks for your reply.
Regards,
David.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
tive transaction on the master?
I don't really want to set max_standby_streaming_delay very high, but that
will be the action of last resort.
Regards,
David.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
écrit :
>
> On Tue, Apr 2, 2013 at 10:29 AM, David Guyot (English)
> <mailto:david.gu...@europecamions-interactive.com>> wrote:
>
> restore_command = 'rsync -av
> 192.168.0.80:/var/lib/postgresql/WAL/%f %p'
>
>
> You're telling the recovery p
og/postgresql'
log_filename = 'postgresql-requests.log'
log_min_messages = info
log_error_verbosity = verbose
log_line_prefix = '%t '
lc_messages = 'en_GB.UTF-8'
lc_monetary = 'fr_FR.UTF-8'
lc_numeric = 'fr_FR.UTF-8'
lc_time = 'fr_FR.UTF-8'
gAdmin so I cannot really speak to its features and while it
may be able to do some of what you need it is mostly intended to create and
modify the database schema and provide a GUI interface for browsing.
David J.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Data-
o an alternate tablespace and have all the daily tables be created
in that same tablespace.
I suppose similar comments apply to INHERITS.
Thoughts?
Regards,
David.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
This query returns false
select ('2012-11-20 17:00:00-02:00'::timestamp with time zone) =
('2012-11-20 18:00:00-03:00'::timestamp with time zone)
But are exactly same time
Why?
timestamp with timezone just show/hide time zone?
thanks
We have a database of around 700Gb ... its fairly busy with a lot of small
transactions.
We generate some times near 100Gb of WAL files per day, this seems like a
lot !! We are looking at a secondary data center for DR so the connection
would need a large amount of bandwidth based on this volume.
the only thing he can do... Restart the server,
when he restart the postgres server receive a KILL message and then
everything get worse
I live this situation time ago and obviously learn :)
-----Mensaje original-
De: Anibal David Acosta [mailto:a...@devshock.com]
Enviado el: lunes, 17 de se
Yes, is a Bug, sometimes in some circumstances pg_ctl go down but postgres
server still running.
You can easily reproduce.
Go to "task manager", kill the process "pg_ctl" (simulate some kind of crash
or something else).
Now go to services management and try to start again. Start command will
thro
Following a recent database crash, I encountered the following when doing
debug:
[root@my-db myhost]# ps -ef | grep pgsql
postgres 19643 5737 0 09:42 ?00:00:00
/usr/pgsql-9.0/bin/postmaster -p 5432 -D /var/lib/pgsql/9.0/data
postgres 19644 5737 0 09:42 ?00:00:00
/usr/pgsql-9.0/
Dave
On Tue, Sep 11, 2012 at 3:57 PM, Fernando Hevia wrote:
>
> On Mon, Sep 10, 2012 at 5:30 PM, David Morton wrote:
>
>> We have many large tables which contain static historical data, they are
>> auto vacuumed on a regular basis (sometimes to prevent wraparound) which i
&
We have many large tables which contain static historical data, they are
auto vacuumed on a regular basis (sometimes to prevent wraparound) which i
suspect causes a few annoying side effects:
- Additional WAL file generation
- Increased 'changed' data as far as our online rsync based backups are
co
Install Postgres in both server machine
Configure the MS Cluster Service, add the external storage and the Postgres
Service to your cluster group, and configure the postgres service to start
using the directory in the external storage.
Now you have a fail over database.
Add you application to cl
I'm implementing replica servers which will use a trigger file to promote
from hot standby to full read/write. I've configured streaming replication
as well as a recovery.conf which copies old WAL files from a repository if
required.
When placing the trigger file the system assumes the read/write
Is probably that the cause of this behavior are many many dead tuples in the
table.?
De: Anibal David Acosta [mailto:a...@devshock.com]
Enviado el: miércoles, 01 de agosto de 2012 04:27 p.m.
Para: pgsql-admin@postgresql.org
Asunto: Timeout error on pgstat
I have a lot (maybe 1
scan encountering many consecutive pages that contain no live tuples would
not respond to interrupts meanwhile
Maybe in the autovacuum happen something similar?
De: Anibal David Acosta [mailto:a...@devshock.com]
Enviado el: jueves, 02 de agosto de 2012 10:52 a.m.
Para: 'Craig Ringe
to de 2012 10:01 p.m.
Para: Anibal David Acosta
CC: pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] Timeout error on pgstat
On 08/02/2012 04:27 AM, Anibal David Acosta wrote:
I have a lot (maybe 1 every 10 seconds) of this error WARNING: pgstat wait
timeout
A quick search suggests this can
I have a lot (maybe 1 every 10 seconds) of this error WARNING: pgstat wait
timeout
Also this
ERROR: canceling autovacuum task
In the pg_stat_activity show an autovacuum process over a very used table
that runs about 1 hour and then this vacuum is cancelled (according to log)
I have
On Jul 19, 2012, at 9:03 PM, Sergey Konoplev wrote:
> On Fri, Jul 20, 2012 at 1:02 AM, David Kerr wrote:
>> I was looking into this last month and some nice folks on the list pointed
>> me to this formula
>> for calculating lag. (to be run on the slave) simila
On Jul 19, 2012, at 8:17 AM, Ali Pouya wrote:
> Hi,
> I am using a master and a replica with PostgreSQL 9.1.3.
> I would like to measure the replication lag between my servers (in time
> units).
>
> On the replica I can use the function pg_last_xact_replay_timestamp().
> But on the master I onl
or a system for avoiding duplicate
file names, both of which might be relevant in the context of this error.
Can anyone confirm what the presence of the .1 suffix means?
I'm using Postgres 8.3.15 on Windows.
Thanks,
David
password
hostall all 127.0.0.1 255.255.255.255 password
hostall all 0.0.0.0 0.0.0.0
password
And "tcpip_socket = true" is enabled in postgresql.conf.
Any ide
t the preceding CLUSTERs.
Is this a bug? How might I collect more information without shipping the
user a new build? The Postgres log, at least at notice level, doesn't
appear to show anything more useful than the error message.
Thanks,
David
Hi All,
I hope this is the correct mailing list to ask this question.
We are setting up a system using postgresql 9.1 and streaming
replication to copy reference data from a single central location to
several remote sites. The database changes will come in clumps with
long periods of no activity
on't give it to them.
Dave
On Wed, Mar 14, 2012 at 11:46 AM, Scott Ribe wrote:
> On Mar 14, 2012, at 9:28 AM, David Ondrejik wrote:
>
> > So there is some trail to track back to the original user.
>
> Yes, but once he has root shell, the trail ends there, and impersonation
&g
That unadvertised command...if issued...would also
be logged and lists the userid of the person who used the command. So there
is some trail to track back to the original user.
Dave
On Wed, Mar 14, 2012 at 11:14 AM, Scott Ribe wrote:
> On Mar 14, 2012, at 9:01 AM, David Ondrejik wrote:
>
>
In Linux you can setup and use the "sudo" option. For those whom you don't
wish to have root access, simply make them sudousers, then change the root
password. This will force those users to simply type "sudo" (w/o quotes) at
the beginning of each command they want to run (i.e. sudo psql db_name
"i
On 03/06/2012 02:03 PM, Todd Hunt wrote:
Hi,
First let me state that I'm not a DBA, but a developer. I know enough
about databases to be dangerous, but not enough to make any money at
it. ;-)
We are using large objects with OIDs as part of our data model. One
of our processes is to backup th
On 03/07/2012 07:39 AM, Ray Stell wrote:
how I can differentiate these:
oamp=# \z public.c3*
Access privileges
Schema | Name | Type | Access privileges | Column access
privileges
+---+---+---
simply
that you would like a different output than what you are being given?
David J.
Glad to hear that you can spin up the database and get to your data.
Sorry to hear that you did end up losing data on that server.
-David Hornsby
On 1/19/2012 5:46 PM, Samuel Hwang wrote:
correct typo.
We pretty much lost the data for the last two days, but since our
postgresql wereN&#
way if you
don't like what happens you can always go back to the way things were.
Also right now would be a good time to evaluate your backup strategy,
which is a different topic for a different thread, but I can certainly
help with that as well.
-David Hornsby
> version Postgresql 9.1.1 on
me up sooner is because most Windows users either use the
'official' binaries rather than compiling from source, or link against the
dynamic runtime.
Is this something I could expect to be fixed in the near future, or is it
enough of an edge case that I should come up with some solutio
ot in the affairs of Dragons
For you are crunchy and good with Mustard
David M. Gullever
david.gulle...@web.de
-
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Ah, I see; it looks like when logging_collector = 'off', Postgres logs to
the Windows event log. Is this a bug? Given that log_destination has an
'eventlog' option, it seems weird for it to also be logging there based on
the value of a different option.
Since I don't want logging to files, I gue
I have log_destination = 'stderr', but Postgres (8.3.15) writes messages to
the Windows event log. How can I prevent it from doing this? Any insight
into this behavior would be greatly appreciated. Thanks!
But in windows, there are no support for x64.
I fact, if you have a x64 postgres version, pgAgent wont install
De: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] En nombre de Julien Rouhaud
Enviado el: viernes, 02 de diciembre de 2011 01:02 p.m.
Para: Rob Rich
On Mon, Nov 28, 2011 at 9:48 PM, Craig Ringer wrote:
>
> Getting a usable stack trace on Windows isn't actually too hard.
The problem isn't getting the trace - I know how to do that - it's that I
don't have the pdbs for this build, and so the trace wouldn't be very
useful. I may be able to get
-D
"C:\Users\David\Desktop\testdb" -W
pg_ctl -U testuser -D "C:\Users\David\Desktop\testdb" start
CREATE DATABASE testdb OWNER testuser;
CREATE OR REPLACE FUNCTION datastore_unpack(
data_times TIMESTAMP WITH TIME ZONE[],
data_values DOUBLE PRECISION[],
OUT data_time
Sure; the function is created programmatically as part of schema creation,
by the same user who owns (almost) everything else in the database. The
definition looks like this:
CREATE OR REPLACE FUNCTION datastore_unpack(
data_times TIMESTAMP WITH TIME ZONE[],
data_v
I'm seeing pg_dump [8.3.15 Windows] crash reproducibly against a particular
database. Searching the web, I found [
http://grokbase.com/t/postgresql.org/pgsql-general/2001/02/pg-dump-crash/06ss55h5l35jh4bnnqfigxisy534]
with
a response from Tom Lane suggesting that it was probably due to a bug in
pg
On Wed, Nov 16, 2011 at 6:57 PM, Tom Lane wrote:
> They're used for character set encoding conversions, eg when
> database_encoding = UTF8 and client_encoding = LATIN1 (or any other
> non-identical combination).
Thanks, Tom and Craig; that makes perfect sense. I'd rather not assume
anything ab
I bundle Postgres (8.3.15) with another product as a back-end database. On
Windows, the default build includes a bunch of what appear to be codec
libraries, with names like, utf8_and_cyrillic.dll, ascii_and_mic.dll, etc.
But using Microsoft's dependency walker tool, I see no references to any
of
ee what
you get.
It is likely that a simple ANALYZE on the table will solve your problem (ALWAYS
RUN ANALYZE BEFORE POSTING QUESTIONS LIKE THIS); in the unlikely event it does
not please post the “EXPLAIN ANALYZE” results so we can see exactly how many
records each query returned.
David J.
ly do that
simple task you will then be in a better position to decide if such an
architecture is worth expanding upon.
The better question to ask is why wouldn't you want to use something like
Tomcat or Apache+Programming Language?
David J.
--
Sent via pgsql-admin mailing list (pgsq
I think I see a (my) fatal flaw that will cause the cluster to fail.
From the info I received from previous posts, I am going to change
my game plan. If anyone has thoughts as to different process or
can confirm that I am on the right track, I would appreciate your
input.
1. I am going to ru
Thanks to everyone for their response and help. I still have some
more questions that hopefully someone can help me with as I have not yet
been able to solve my vacuumdb problem.
The posting of data to the table in question is extremely
slow...yesterday I saw that it took over 6 min to post
takes on the
vacuum process?
Thanks,
Dave
Tom Lane said the following on 7/15/2011 1:12 PM:
Simon Riggs writes:
On Fri, Jul 15, 2011 at 5:10 PM, David Ondrejik wrote:
Since then, the process has continued to run (for about 20 hrs) without any
additional information being returned.
Probably
Simon - thanks for the response. I checked all the processes and
nothing appears to be holding it up. Any other advice?
Simon Riggs said the following on 7/15/2011 12:21 PM:
On Fri, Jul 15, 2011 at 5:10 PM, David Ondrejik wrote:
Since then, the process has continued to run (for about 20
Hello,
I am new to this list and hope I have chosen the appropriate group to
ask this question.
We are running version 8.2.6 of postgres and I am trying to run a full
vacuum on a single table in our database. I started the vacuum about 24
hours ago and it is still running. Within 2-3 hrs o
Hello,
I am new to this list and hope I have chosen the appropriate group to
ask this question.
We are running version 8.2.6 of postgres and I am trying to run a full
vacuum on a single table in our database. I started the vacuum about 24
hours ago and it is still running. Within 2-3 hrs o
The best way I found is to just treat the image as a BLOB. Create a
column with type OID and do a lo_import and an lo_export as demonstrated
in this page.
http://www.postgresql.org/files/documentation/books/aw_pgsql/node96.html
-David.
On 7/1/11 8:30 AM, francescobocca...@libero.it wrote
Hello, I have a postgres installed on a Windows server machine.
In my country we have daylight saving so my windows OS is configured to
automatically change timezone but the postgres only reload the new timezone
after restart.
Is possible to kept the Postgres in sync with the windows time (time a
Hello, I have a postgres installed on a Windows server machine.
In my country we have daylight saving so my windows OS is configured to
automatically change timezone but the postgres only reload the new timezone
after restart.
Is possible to kept the Postgres in sync with the windows time (time a
am looking at setting up a VPN tunnel to an offsite server and
sending WAL updates to that.
Any and all comments are truly appreciated as well as any nudges in various
directions.
David.
--
David Hornsby
Beechglen Development Inc.
E-Mail: da...@beechglen.com
Phone: 513 922 0509 x432
Fax
backup and restore for postgresql and I believe we have
all of the pieces in place. You both have been a big help.
Thanks,
David
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Monday, April 11, 2011 10:47 AM
To: Ian Lea; David Roland
Cc: pgsql-admin@post
PostgreSQL get the data folder to a stable
state? Is it by the use of the WAL files that may be created during the
backup process and the restore.config file?
-Original Message-
From: Ian Lea [mailto:ian@gmail.com]
Sent: Friday, April 08, 2011 3:55 AM
To: David Roland
Cc: pgsql-admin
Hello.
I have two postgres 9.0 database both can be modified and both must have
same information.
In case of collision (same row changed in both) must win the most recent.
Thanks.
ctions to port 5432 via its standard
rule set. I would install something like pgadmin on the windows client and
see if that will allow you to connect first. If pgadmin connects, then its
likely and odbc config issue.
>
>
> Marc
>
--
David Bear
College of Public Programs at ASU
602-496-0424
orrectly set, causing rows
to appear visible in seqscans when they should not be. This might explain
recent reports of data corruption from Jeff Ross and others.
In passing, do a bit of editorialization on comments in visibilitymap.c.
oy:postgresql machack$ git descr
I think SAN is better for block access instead of file access (NAS)
-Mensaje original-
De: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] En nombre de Bryan Keller
Enviado el: miércoles, 09 de febrero de 2011 05:00 p.m.
Para: pgsql-admin@postgresql.org
Asunto:
clear the error.
Anyone have any pointers?
--
David Bear
College of Public Programs at ASU
602-494-0424
anks again for your help.
David J. Rericha
OSS, LLC
Projects Manager
563-650-5446
On 12/28/2010 09:06 PM, Tom Lane wrote:
> David Rericha writes:
>
>> Thanks, Tom. That was it. After I ran analyze on the table, the error
>> disappeared.
>>
> Yeah, I just
Thanks, Tom. That was it. After I ran analyze on the table, the error
disappeared.
David J. Rericha
OSS, LLC
Projects Manager
563-650-5446
On 12/28/2010 08:45 PM, Tom Lane wrote:
> [ please keep the list cc'd ]
>
> David Rericha writes:
>
>> I am truly typing the
t of range for timestamp
Now, the interesting thing is that this error is not given with any date
parameter prior to 12/10/2010. Also, I selected the entire table into a
temp table without constraints and could not reproduce the error. If
any one has any insight, I would be most appreciative.
Hi everyone.
I have been installed postgresql 9.0.2 on a windows 2008 x64 server.
The postgres is running, without any application accessing the server.
In the log appear : WARNING: pgstat wait timeout
This error appear constantly and some times when I do a query, very simple
query l
like this:
Select column1 from myTable where Column2 between X and Y
I am expecting just one record
De: Michael Holt [mailto:mich...@aers.ca]
Enviado el: jueves, 16 de diciembre de 2010 04:23 p.m.
Para: Anibal David Acosta; pgsql-admin@postgresql.org
Asunto: RE: [ADMIN] using limit
Hi
I really like to do efficient SQL queries so, my question is if I am
expecting no more than one row from a select, using the LIMIT 1 could
improve the performance?
If I use my logic, the LIMIT 1 instruction tell to postgres that stop
searching when found 1 record, but maybe it is unnecessa
On Sun, Dec 12, 2010 at 08:11, Tom Lane wrote:
> David Underhill writes:
> > I have two tables. One has a foreign key referencing a serial field in
> the
> > other table. I've given INSERT privilege to a role other than the owner,
> > but I still can't in
SHARE OF x"
However, the above insert works if I give testowner back the UPDATE
privilege (GRANT UPDATE ON a TO testowner;). Why does testowner need UPDATE
in this case?
Thanks,
~ David
Thanks!!!
I'll download right now :)
-Mensaje original-
De: Radosław Smogura [mailto:rsmog...@softperience.eu]
Enviado el: jueves, 02 de diciembre de 2010 08:22 a.m.
Para: Craig Ringer
CC: Anibal David Acosta; pgsql-admin@postgresql.org;
pgsql-gene...@postgresql.org
Asunt
Hello.
I have a not bootable Windows Server with Postgres 8.1, now I am trying to
recover it but as I can't boot the windows, I can't start the postgres
service and I can't do a "Backup"
So, I only have the postgres directory on my hands. I decide to install the
same database version in another c
-*-*-*-*-*
dwn...@ntlworld.com (David W Noon)
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
signature.asc
Description: PGP signature
Windows server enterprise has the Microsoft Cluster Services.
This enable fail-over scenario between two computers.
So, when one of them go offline, the other is activated, this involve many
steps, including IP changing, the slave become the master IP address .
But you can choose between h
Hello:
I have a DB with 90GB in postgre 8.1 and I want to move to another server.
The new server has postgre 8.3 and I don't know if I can use PITR to do the
replication.
thank you very much.
e; is it best to keep the cluster in a filesystem that is part
of the vm-image or on a mounted file system that exists external to the
image? (in other words, a /dev/sdxx that is really some NAS type of device,
or NFS? CIFS?)
--
David Bear
College of Public Programs at ASU
602-494-0424
g list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
David Bear
College of Public Programs at ASU
602-494-0424
On Wed, Jul 14, 2010 at 05:30:17PM -0400, Burgholzer, Robert (DEQ) wrote:
- >. The options I suggested be turned off just for the load process
- > ...
- > not safe if the other databases are in the same PostgreSQL Cluster
-
- They are, so I won't --- thanks for the heads up on that too.
-
- Jus
On Wed, Jul 14, 2010 at 01:07:48PM -0400, Burgholzer, Robert (DEQ) wrote:
- That said, the time to restore is explainable, but is there something in
- my tuning that is causing all of my memory to be eaten?
-
- We seem to have some undiagnosed issue whereby opening and closing large
- files on the
>
> Is it possible to have the 8.1 and 8.4 ODBC drivers available at the same
> time? If so, how do I install the 8.4 driver so that the 8.1 driver is
> still available?
>
> Thanks very much!
>
> RobR
>
--
David Bear
College of Public Programs at ASU
602-494-0424
Postgres version 8.4.4
Hardware:
12 cpu intel
sda 15K 600GB raid 1
sdb ssd 173GB raid 1 (most tables and indexes on sdb)
adaptec controller
24G of memory
shared buffers 12GB
Machine age 3 months
Normal load 2-4
200-300 Transactions per second
We had a database failure last night after one of
Thank you all. This group is amazingly helpful. The combinations of emails
and the document linked below did the trick.
On Fri, Jun 18, 2010 at 10:40 AM, Greg Smith wrote:
> David Bear wrote:
>
>> I have RHEL 5.4 (64bit) that has a postgresql-lib 8.1 installed to satisfy
>>
the postgresql-lib with the 8.3
lib ?? I'd rather not have to uninstall all the dependancies, install pg,
then reinstall everything I just removed facing more possible dependacy
issue.
any advice much appreciated.
--
David Bear
College of Public Programs at ASU
602-494-0424
1 - 100 of 423 matches
Mail list logo
