ase
cluster directory
preserving user and permissions to the new location, update the
$PGDATA variable for the user postgres with the value of the new
location , startup the postmaster, enjoy ;)
Best Regards and Merry Christmas
Federico Campoli
---(end o
The same test on my production machine (debian sarge 3.1, postgresql
8.1.6 from source) don't have problem.
What can be the cause of this crazy behaviour?
Best Regards
Federico Campoli
---(end of broadcast)---
TIP 3: Have you checked our extensive
nsive scsi raid hardware so i need to
have raid software.
Thanks in advance
Best Regards
Federico Campoli
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On 1/16/07, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
On Mon, Jan 15, 2007 at 18:24:19 +0100,
Federico <[EMAIL PROTECTED]> wrote:
> Hi,
> after some test i got that my performance problem described in the
> message http://archives.postgresql.org/pgsql-admin/2007-01/msg001
in the permissions. The customer could restart the PostgreSQL
service manually, without resorting to a backup.
Could this be the result of not enough check_point segments?
SNIP!
Your log is full of "Permission denied" statements.
I suggest you to check the permissions on your data directory.
0..2896.42 rows=33242 width=64) (actual
time=77.027..791.014 rows=37093 loops=1)"
-
rows=37093 is all of the existing rows of table testcase!
(why does it say "never executed"?)
Hi,
a full index scan is even more expensive than a sequential scan.
So the que
and t_cmax stores the insert and delete CID stamps.
the CID (command that operate on item id?) is similar to XID? where I
can find some docs about CID and its meaning?
Thank you very much in advance.
Regards
Federico
--
Federico Campoli is:
@ PGDay -> Committee, http://www.pgday.it
@ PLUG -> C
from
the manual then transfer the archived segments in a second time using a
more reliable system like rsync.
Cheers
Federico
On 26 April 2013 14:06, German Becker wrote:
> Here is the archive part of the config:
>
> archive_mode = on # allows archiving t
e script timeout for each statement in
my maintenance scripts using a temporary table to store the deadline.
Kind Regards
Federico
On 17 September 2013 17:23, Roberto Grandi wrote:
>
> Dear all,
>
> i would set a script timeout from a .net application. My problem regards
> how to make sur
e delay to have effect on the DBMS.
Please help me.
Federico
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
The link for the Beta 2 Windows version of 8.0 is not
working. How do I download it?
Question: is this a real windows version? Not cygwin?
Federico
11 matches
Mail list logo
