Hello all!
I've a small bash script backup.sh for creating dumps on my Postgre db:
#!/bin/bash
time=`date '+%d'-'%m'-'%y'`
cd /home/swkm/services/test
pg_dump mydb mydb_dump_$time.out
I've edited crontab and added a line:
00 4 * * * swkm
: Thursday, November 22, 2007 3:28 PM
To: Sorin N. Ciolofan
Cc: pgsql-admin@postgresql.org; [EMAIL PROTECTED]
Subject: Re: [ADMIN] backup of postgres scheduled with cron
On Nov 22, 2007 2:19 PM, Sorin N. Ciolofan [EMAIL PROTECTED] wrote:
Hello all!
I've a small bash script backup.sh for creating
Thank you all,
Yes, I used the absolute path in my script and now works ok :-)
Thank you again
Sorin
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Frank Wittig
Sent: Thursday, November 22, 2007 4:01 PM
To: Sorin N. Ciolofan
Cc: pgsql-admin
Hello!
I'd like to ask you what line should be added in pg_hba.conf file in order
to grant access to a user with ip
139.100.99.98 to a db named myDB with user scott with password
mikepwd?
After modifying this file is enough to issue
pg_ctl reload
or should I restart postgres?
Thank you
With
Hi again!
It seems that the problem was the max_fsm_relations parameter which was
increased
I still do not understand why in the past I received always the message:
ERROR: out of shared memory
Is this an appropriate message for the need for increasing this parameter?
With best
appropriate to the real cause of the problem or the reason
of the failure is actually other than what is displayed in this message?
With best regards,
Sorin N. Ciolofan
Hello!
Do you know which could be the reasons that could conduce an application to
not release the shared buffers, even after the application was shut down?
I noticed that only if a pg_ctl restart command is issued some of the
buffers are set free.
Thank you very much
With best regards,
Sorin
] On Behalf Of Bill Moran
Sent: Thursday, April 26, 2007 3:32 PM
To: Sorin N. Ciolofan
Cc: [EMAIL PROTECTED]; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] [GENERAL] pg_buffercache view
In response to Sorin N. Ciolofan [EMAIL PROTECTED]:
Hello!
Do you know which could be the reasons that could
Dear all,
About the pg_buffercache view:
I couldn't find the description for this view in the manual at
http://www.postgresql.org/docs/8.2/interactive/catalogs.html
However I found the readme file provided in the /contrib./pg_buffercache of
the source code for version 8.2.3
Here it's written
are used) but in reality only 5% from it is actually used.
With best regards,
Sorin
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Moran
Sent: Tuesday, April 24, 2007 4:03 PM
To: Sorin N. Ciolofan
Cc: pgsql-admin@postgresql.org; [EMAIL PROTECTED
Sent: Thursday, April 12, 2007 4:14 PM
To: Sorin N. Ciolofan
Cc: 'Shoaib Mir'; [EMAIL PROTECTED]; pgsql-admin@postgresql.org;
'Dimitris Kotzinos'
Subject: Re: [GENERAL] [ADMIN] Increasing the shared memory
In response to Sorin N. Ciolofan [EMAIL PROTECTED]:
I've tried first
, for example from n=23 to n=24 but the maximum quantity of data
accepted was the same.
Thank you very much,
With best regards
Sorin
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 12, 2007 5:01 PM
To: Sorin N. Ciolofan
Cc: 'Shoaib Mir'; [EMAIL PROTECTED
, 2007 6:02 PM
To: Sorin N. Ciolofan
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [ADMIN] Increasing the shared memory
An extract from -- http://www.powerpostgresql.com/PerfList/ might help
you
shared_buffers:
As a reminder: This figure is NOT the total memory PostgreSQL has
Hello!
I'd like to ask you if there is any Postgre configuration parameter (like
the ones defined in postgresql.conf file) that could be used for increasing
the shared memory for Postgre?
Thank you very much
With best regards,
Sorin
?!?
In the postgresql.conf file is an ambiguous comment that could induce the
idea that each shared buffer has 8 kb.
So, which is the meaning of this integer?
Thanks.
S.
_
From: Shoaib Mir [mailto:[EMAIL PROTECTED]
Sent: Monday, April 02, 2007 1:01 PM
To: Sorin N. Ciolofan
Cc: pgsql-general
tables of about 4000.
Could be this the problem?
With best regards,
Sorin
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 27, 2007 6:37 AM
To: Sorin N. Ciolofan
Cc: pgsql-general@postgresql.org; pgsql-admin@postgresql.org;
pgsql-performance@postgresql.org
Hello!
I have to manage an application written in java which call another module
written in java which uses Postgre DBMS in a Linux environment. I'm new to
Postgres. The problem is that for large amounts of data the application
throws an:
org.postgresql.util.PSQLException: ERROR:
17 matches
Mail list logo