So, I'd like a recommendation.
Mario
--
Mario Splivalo
Mob-Art
[EMAIL PROTECTED]
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Fri, 2006-07-28 at 11:01 -0700, Jeff Frost wrote:
> Mario,
>
> There's also Command Prompt's Mammoth replicator:
> http://commandprompt.com/products/mammothreplicator/
I sent an email asking if they have an evaluation version of some
sort...
> Also, you could batch up PITR restores or even j
I have postgres 8.1 on WindowsXP, installed via postgres installer. I
have the user postgres on the cluster. When I try to create database
from command line:
createdb -U postgres test_db_1
I get error that 'postgres database does not exists'. When I try to
create db from EMS manager, everything w
I'm finaly switching to 8.2. I notice that ugly 'feature' from pg8.1 has
been fixed: logging the parametars of prepared statements. It's a bit
ugly, but it's there :)
But now in my log i have BINDLOG, PARSELOG and others, and my log looks
realy cloged. Here is an example. I'm calling the
'create_m
On Tue, 2007-06-19 at 10:52 -0400, Alvaro Herrera wrote:
> Mario Splivalo wrote:
> > I'm finaly switching to 8.2. I notice that ugly 'feature' from pg8.1 has
> > been fixed: logging the parametars of prepared statements. It's a bit
> > ugly, but it'
cho wrote:
Le Fri, 19 Oct 2007 12:43:40 -0400, Sean Brown a écrit :
Have a look at pgpool-I or pgpool-II in replication mode.
Pgpool proxies SQL requests, so that requests on one server are replayed
on the other. pgpool-I is limited to two nodes, whereas pgpool-II is not.
Latency is importan
I need to check, from a bash script, if certain database exists in a
postgres cluster. When I issue:
psql -U someuser somedatabase
psql returns error code 2 regardless of 'no user' or 'no database'
condition. How could I distinguish from the two?
Mario
--
Sent via pgsql-admin mailing lis
bject into a separate file. Then I could create a script wich will
'load' each object from the file when I want it (so I don't have
dependency problems).
Is there a tool like that, or should I stick with pg_dump/pg_restore, or
maybe even going trough information_schema to see al
e was zero
minutes.
Mike
--
Mario Splivalo
Mob-Art
[EMAIL PROTECTED]
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
; $ ld.so.l: /usr/local/pgsql/bin/initdb: fatal: libreadline.so.4: open
> failed: No such file or directory
>
> Note /usr/local/pgsql/data is owned by postgres
>
>
> Olive
>
> Mario Splivalo <[EMAIL PROTECTED]> wrote:
> On Sun, 2005-11-20 at 02:16 -080
much slower) because I
was missing several 'pg_close()' instructions.
The same thing happened to my developers here, using java/tomcat/jdbc to
connect to postgres. Make sure you close all your postgres connections.
Mike
--
Mario Splivalo
Mob-Art
[EMAIL PROTECTED]
"I can do
On Mon, 2005-11-21 at 10:58 +0100, Marcin Giedz wrote:
> Dnia poniedziałek, 21 listopada 2005 10:34, Mario Splivalo napisał:
> > On Sun, 2005-11-20 at 11:53 -0600, Jim C. Nasby wrote:
> > > Two general comments: most people find that Opterons perform much better
> >
ad design. What do you delete from a 400.000 records
table?
I guess it's ok to be slow.
Mike
--
Mario Splivalo
Mob-Art
[EMAIL PROTECTED]
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
---(end of broadcast)--
the one that client called. Is there a way to tell postgres to
log all the nested functions?
I'm using postgresql 8.1.2.
Thanks in advance.
Mike
--
Mario Splivalo
Mob-Art
[EMAIL PROTECTED]
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
-
o 8.1.2, but so that database on 8.1.2
is with -E UTF8?
Mike
--
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
Mario Splivalo
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: explain analyze is your friend
reate them), and
then restart the application.
But, for now, just a 'dependency tracker' of some sort would be a huge
help.
Mario
--
Mario Splivalo
Mob-Art
[EMAIL PROTECTED]
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
---
values for the
parameters.
Mario
--
Mario Splivalo
Mob-Art
[EMAIL PROTECTED]
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
---(end of broadcast)---
TIP 6: explain analyze is your friend
test database?
Mario
--
Mario Splivalo
Mob-Art
[EMAIL PROTECTED]
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
---(end of broadcast)---
TIP 6: explain analyze is your friend
I'm doing backup on a second, spare server, by backing up WAL files. I'm
using that server for analysis queries and reporting. Every 15 minutes I
need to shut down that server, place in new WAL files, and restart
server. That is ok, except that I need to backup whole database cluster.
That wasnt't
ed-up server).
Mario
--
Mario Splivalo
Mob-Art
[EMAIL PROTECTED]
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
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
> > called up only every 45 minutes or so. Is
Suppose I have 'stupid' database with just one tables, like this:
CREATE TABLE messages (
message_id uuid NOT NULL PRIMARY KEY,
message_time_created timestamp with time zone NOT NULL,
message_phone_number character varying NOT NULL,
message_state type_some_state_enu
Igor Neyman wrote:
>
> Partition your MESSAGES table by week or month (read on table
> partitioning in PG docs).
>
> Pg_dump "old" purtitions from "current" server, when they are not needed
> any more.
> Move backups of dumped partitions to your "auxilary" server, and
> pg_restore them there.
H
I have set up munin monitoring that plots nice graphs using
pg_stat_bgwriter and pg_stat_database views. It has been on for quite
some time now, and the numbers those views return are too big for munin
to handle. I would like to reset those statistics. As explained by
manual, pg_stat_reset() re
On 04/20/2011 10:49 PM, raghu ram wrote:
On Thu, Apr 21, 2011 at 1:01 AM, Mario Splivalo
mailto:mario.spliv...@megafon.hr>> wrote:
I have set up munin monitoring that plots nice graphs using
pg_stat_bgwriter and pg_stat_database views. It has been on for
quite some time now, a
On 04/22/2011 03:20 PM, Cédric Villemain wrote:
2011/4/21 raghu ram:
Heh, I've neglected to mention that i'm using postgres 8.4.5 on Debian
Stable. Is there a way to reset statistics on pg8.4? I've tested it on 9.0
and it works there.
AFAIK, I dont think we can achieve this in PG 8.4 at clus
On 04/22/2011 04:26 PM, Cédric Villemain wrote:
ah yes.
There exist a very brutal way to do it, which will remove all stats.
(you need the server to be down to do that)
move or rm the "global/pgstat.stat" file.
To come back to your original problem : I am surprised you have too
large value for m
Hi, all.
Postgres 8.4.4, quite often I have situation like this:
011-05-26 18:25:38.842 CEST [16163] [192.168.1.5(32431)]
SET LOG: duration: 0.029 ms statement: BEGIN; SET TRANSACTION
ISOLATION LEVEL READ COMMITTED
2011-05-26 18:25:38.843 CEST [16163] [192.168.1.5(32431)]
SELECT LOG: dur
I have user foo that is owner of database dbfoo. Now I need to create
user baz that will have the exact same privileges as user foo on
database baz. I've tried this:
GRANT ALL ON DATABASE dbfoo TO baz;
but I still can't select form tables.
Is there a easier way, or do I need to go trough all
I need to have postgres role to be able to cancel queries run by that
same role.
I know that I can kill the client connection that started the query, but
I also need to have that role connect to postgres and kill some of it's
running queries.
It's on postgres 9.1.1, running on Debian Squeeze.
On
On 12/19/2011 07:46 PM, Craig James wrote:
> Backend Postgres processes run as the Postgres user, so they have
> permission to kill each other. You write an add-on function that just
> kills a process:
>
> select my_kill_backend(pid);
>
> Naturally, this is very dangerous. There are all sorts
I have these errors in my log files, occurring very often:
2012-02-02 01:05:53 CST [4103]: [2-1] user=,db= FATAL: could not
receive data from WAL stream: SSL error: sslv3 alert unexpected message
2012-02-02 01:05:58 CST [20507]: [301-1] user=,db= LOG: invalid magic
number in log fi
How can I get the master server host data from a running slave, without
reading recovery.conf file?
I've tried with SHOW, but that just gives me:
postgres=# show primary_conninfo;
ERROR: unrecognized configuration parameter "primary_conninfo"
Mario
--
Sent via pgsql-admin mailing list
On 02/02/2012 05:16 PM, Tom Lane wrote:
> Mario Splivalo writes:
>> I have these errors in my log files, occurring very often:
>> 2012-02-02 01:05:53 CST [4103]: [2-1] user=,db= FATAL: could not
>> receive data from WAL stream: SSL error: sslv3 alert unexpected message
>
On 02/02/2012 05:15 PM, Mario Splivalo wrote:
> On 02/02/2012 05:16 PM, Tom Lane wrote:
>> Mario Splivalo writes:
>>> I have these errors in my log files, occurring very often:
>>> 2012-02-02 01:05:53 CST [4103]: [2-1] user=,db= FATAL: could not
>>> receive da
35 matches
Mail list logo