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: [EMAIL PROTECTED
: Thursday, November 22, 2007 3:28 PM
To: Sorin N. Ciolofan
Cc: [EMAIL PROTECTED]; pgsql-general@postgresql.org
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
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 /home/swkm/services/test
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
Wi
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 rega
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
]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Moran
Sent: Thursday, April 26, 2007 3:32 PM
To: Sorin N. Ciolofan
Cc: pgsql-general@postgresql.org; [EMAIL PROTECTED]
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 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
the buffers 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: [EMAIL PROTECTED]
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 the
Moran
Sent: Thursday, April 12, 2007 4:14 PM
To: Sorin N. Ciolofan
Cc: 'Shoaib Mir'; pgsql-general@postgresql.org; [EMAIL PROTECTED];
'Dimitris Kotzinos'
Subject: Re: [GENERAL] [ADMIN] Increasing the shared memory
In response to "Sorin N. Ciolofan" <[EMAIL PROTECTED]>
little one, 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
Of Shoaib Mir
Sent: Monday, April 02, 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 t
megabytes?!?
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. Ciolo
cording to the
error message, or is the error message irrelevant and improper in this
situation?
With best regards,
Sorin
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 27, 2007 4:59 PM
To: Sorin N. Ciolofan
Cc: pgsql-general@postgresql.org; pgsql-admin@p
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
eated 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@postgresq
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: ou
18 matches
Mail list logo