"Does the server log say anything about broken
connections or client not responding?"
Nope, no errors in server log, just high I/O and no free slots remaining.
We are thinking of adding more RAM to the server what should speed up the
queries..
--
Best regards,
Viktor
Hello,
It's me again..
Log_connection inspection didn't help to find the cause, the connections come
from our app-servers as usual..
Btw we have the max pool size of web application 50 connections and since we
have 4 instances of application running it makes max 200.
I don't really g
On 10/1/2013 4:45 PM, Igor Neyman wrote:
Did you try using any kind of connection pooler, e.g. PgBouncer?
Should help.
Our Java application uses c3p0 connection pooler and we don't think that
it's the issue.
On 10/1/2013 6:15 PM, Albe Laurenz wrote:
Looks like something tries to open lots
Hello,
We are experiencing database random overloads caused by IDLE processes.
Their count jumps from normal ~70 connections to 250-300 with high I/O
(30-40% wa, when normal ~ 1 % wa).
The overload isn't long and lasts about 5 -10 minutes just a couple of
times during the month.
Please sug
Hei,
I think, that it can be done just via RSYNC with stopped both of databases:
http://www.debian-administration.org/article/How_to_setup_Postgresql_9.1_Streaming_Replication_Debian_Squeeze
Just like in the "*Getting it working*" part.
On 5/9/2013 6:45 PM, German Becker wrote:
Hello Everyon
Ook, thanks =)
On 2/20/2013 5:56 PM, Gilberto Castillo wrote:
Hello,
Could explain somebody what will happen, if the slave server fails ?
Will it affect the master functionality/availability ?
nothing!!! the Master continuo work. ;-)))
I'm using simple master-slave replication with 2 serve
Hello,
Could explain somebody what will happen, if the slave server fails ?
Will it affect the master functionality/availability ?
I'm using simple master-slave replication with 2 servers.
--
Best regards
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to
013 at 8:31 PM, Viktor <mailto:vik...@okservers.eu>> wrote:
Hello,
I have "archive_mode = on" in my configuration and wals are sent
via NFS to another server.
Could you please explain what will happen if the partition where
are wals kept gets full or t
Hello,
I have "archive_mode = on" in my configuration and wals are sent via NFS
to another server.
Could you please explain what will happen if the partition where are
wals kept gets full or the NFS server goes down ? Can it cause the
database disfunction ?
Command is:
archive_command =
Hello,
I have running postgresql maste-slave replication with activated
archiving-mode on the master.
Question: is it safe to clean older archived logs or it may corrupt the
slave replication ? And what is the best way to clean them (by making
snapshots)?
--
Regards.
--
Sent via pgsql-a
ted=not( lanpltrusted ) where lanname='plr';
thanks in advance
--
-------
Viktor Bojović
---
Wherever I go, Murphy goes with me
On Wed, Aug 31, 2011 at 11:53 PM, Kevin Grittner <
kevin.gritt...@wicourts.gov> wrote:
> Viktor Bojovi* wrote:
>
> > i don't know why it doesn't use index scan.
>
> Because it thinks your query will return 81226 rows. We need more
> information to make m
gt;= 36805)
(2 rows)
Thanx in advance
--
-------
Viktor Bojović
---
Wherever I go, Murphy goes with me
>
> where x is the number of cores you have in your microprocessor. It then
> divides the restore script into different jobs and goes faster using
> multithreading.
> example:
> pg_restore --username postgres --jobs=4 --dbname=your_db_name
> your_dump_file
>
> Here is if you ha
Hi,
im trying to restore 250GB database, but indexing takes too long, so restore
takes more then 12h.
Is it possible to disable indexing while restoring database?
Thanx in advance
--
---
Viktor Bojović
---
Wherever I go
ch
> > is not of type integer,smallint or varchar.
>
> > How can i find out which table has that unknown type?
>
> Try something like
>
> select attrelid::regclass, attname from pg_attribute where atttypid =
> 'unknown'::regtype;
>
>
s i didn't find any field which
is not of type integer,smallint or varchar.
How can i find out which table has that unknown type?
Thanx in advance
--
-------
Viktor Bojović
---
Wherever I go, Murphy goes with me
ght through the cracks
> Would You find Yourself.. Find Yourself afraid to see"
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsq
ready objects inside.
functions inside that schema had references to objects inside that schema.
some functions still had reference to old schema name.
so i renamed it again to drop those objects.
It was 8.3.13 or prior version @ 32bit debian linux .
--
---
Viktor Bojović
---
Wherever I go, Murphy goes with me
ish in 9 hours, abort it, run pg_stop_backup() and
> continue next day - I assume most of the data won't change, so rsync won't
> re-transfer it (but will calculate hash and compare).
>
> --
> Vladimir Rusinov
> http://greenmice.info/
>
>
>
--
---
Viktor Bojović
---
Wherever I go, Murphy goes with me
idea.
>
> it is possible?
>
>
>
> anybody?
>
>
>
Maybe you can use custom types and store different results into that custom
type container which will be returned by your function.
--
---
Viktor Bojović
---
Wherever I go, Murphy goes with me
s
>
try to scan ports for each address. you can use nmap scanner for that
purpose.
--
-------
Viktor Bojović
---
Wherever I go, Murphy goes with me
ny of you recommend specific tools, preferences, etc?
>
> Regards, Lou Picciano
>
i prefer EMS postgre manager. but it is not free
--
---
Viktor Bojović
---
Wherever I go, Murphy goes with me
addressee please notify the writer immediately and destroy the e-mail. UCS
> Group Limited and its subsidiaries distance themselves from and accept no
> liability for unauthorised use of their e-mail facilities or e-mails sent
> other than strictly for business purposes.
>
--
---
Viktor Bojović
---
Wherever I go, Murphy goes with me
--
---
Viktor Bojović
---
Wherever I go, Murphy goes with me
25 matches
Mail list logo
