[ADMIN] File system level backup with more than one cluster folders

Dear pg community I am newbie with PostgreSQL. I have separate table space for my databases, which is located in separate folder, which is different to default. I would like to carry out file system level backup. Do I need to backup only folder with my table space or all pg folders. Thank y

Re: [ADMIN] Change user password

On Fri, Dec 5, 2008 at 8:42 AM, Dan Scott <[EMAIL PROTECTED]> wrote: > Hi, > > Is is possible to modify a user password using a command line script? > I know about the ALTER USER command from within the client, but this > looks like it's quite insecure, storing the password in the history. I > know

Re: [ADMIN] Change user password

Hi, Scott It seems no such command exists. --- Quan Zongliang [EMAIL PROTECTED] CIT Japan: http://www.cit.co.jp CIT China: http://www.citbj.com.cn -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscriptio

Re: [ADMIN] Connection Limit Exceeded

On Tue, Dec 9, 2008 at 4:10 PM, Steve Kecskes <[EMAIL PROTECTED]> wrote: > Hi, > > Just wondering what actually happens when the connection limit exceeds. > > Dec 10 05:19:45 pallas1 postgres[373]: [2-1] FATAL: connection limit > exceeded for non-superusers > > Are the requests that are rejected p

Re: [ADMIN] install 8.2.9

On Tue, Dec 9, 2008 at 3:11 PM, rocio mejia <[EMAIL PROTECTED]> wrote: > where are the source to install postgres 8.2.9. ? is someone alive in this > group list? Is there a reason you need a specific older version? is 8.2.10 not old enough? Is there a reasons to avoid 8.2.11 that I don't know of

[ADMIN] Connection Limit Exceeded

Hi, Just wondering what actually happens when the connection limit exceeds. Dec 10 05:19:45 pallas1 postgres[373]: [2-1] FATAL: connection limit exceeded for non-superusers Are the requests that are rejected pooled and processed when connection slots are available? -- Sent via pgsql-admin ma

Re: [ADMIN] uninstall

This is a debian related question Rocio, not a PostgreSQL one. Check this site for further information: http://www.debian.org/doc/manuals/apt-howto/ch-apt-get.en.html gb.- 2008/12/9 rocio mejia <[EMAIL PROTECTED]>: > how to unistall postgres8.3 from debian? > > -- Sent via pgsql-admin mailing

Re: [ADMIN] install 8.2.9

Someone alive? Dunno. Source: http://www.postgresql.org/ftp/source/v8.2.11/ However, you should go to the 8.3.5 source. gb.- On Tue, Dec 9, 2008 at 8:11 PM, rocio mejia <[EMAIL PROTECTED]> wrote: > where are the source to install postgres 8.2.9. ? is someone alive in this > group list? > > --

[ADMIN] install 8.2.9

where are the source to install postgres 8.2.9. ? is someone alive in this group list?

Re: [ADMIN] "PANIC: btree_split_redo: lost left sibling" problem

[EMAIL PROTECTED] writes: > Last night we ran out of disk space on our server and when I tried to > start pg_ctl I got this error: > ** EnterpriseDB Dynamic Tuning Agent > * System Utilization: 66 % * > * Database Versio

[ADMIN] Problem solving e decision making

Caro amico, sperando di far cosa gradita, le indico che può trovare sul sito il materiale informativo relativo al percorso formativo su "Il problem solving e la presa di decisione (decision making) " che terremo ad Asti nel mesi di Ottobre e Nov

[ADMIN] "PANIC: btree_split_redo: lost left sibling" problem

This is my first post so hopefully I can provide all the information to get this solved. Last night we ran out of disk space on our server and when I tried to start pg_ctl I got this error: ** EnterpriseDB Dynamic Tuning Agent * System Utilization: 66 %

[ADMIN] moving users/roles from one server to another?

I'm a newbie to PG administration (although I have experience with other DBs). I need to move a single database to a brand new server. I've set up the new server with initdb, set up pg_hba.conf and postgresql.conf, and I can use dump and restore to move the database to the new environment. What

Re: [ADMIN] Remote access

I restarted my service and the netstat now shows the correct details. TCP0.0.0.0:5432 0.0.0.0:0 LISTENING But its still showing the same error. I am trying to connect with the "Add Server" method in pgAdmin III. I am using postgresql in windows. Thanks, Abubaker

Re: [ADMIN] Remote access

Hi, Thanks for the information. But how do I change the listening ip address to 0.0.0.0 Thanks again, Abubaker --- On Fri, 5/12/08, Tino Schwarze <[EMAIL PROTECTED]> wrote: From: Tino Schwarze <[EMAIL PROTECTED]> Subject: Re: [ADMIN] Remote access To: pgsql-admin@postgresql.org Date: Friday, 5 D

Re: [ADMIN] Remote access

Its working now.. Thanks :) --- On Fri, 5/12/08, Abubaker <[EMAIL PROTECTED]> wrote: From: Abubaker <[EMAIL PROTECTED]> Subject: Re: [ADMIN] Remote access To: pgsql-admin@postgresql.org, "Tino Schwarze" <[EMAIL PROTECTED]> Date: Friday, 5 December, 2008, 1:53 AM I restarted my service and the n

[ADMIN] Change user password

Hi, Is is possible to modify a user password using a command line script? I know about the ALTER USER command from within the client, but this looks like it's quite insecure, storing the password in the history. I know it's possible to insert the encrypted password with ALTER USER but that means g

[ADMIN] uninstall

how to unistall postgres8.3 from debian?

Re: [ADMIN] How to find the position of a characted in a string

2008/12/8 ss_postgres <[EMAIL PROTECTED]>: > > > On Mon, Dec 8, 2008 at 5:44 PM, Pawel Socha <[EMAIL PROTECTED]> wrote: >> >> 2008/12/8 ss_postgres <[EMAIL PROTECTED]>: >> > Hi, >> > >> > I am trying to find the position of a character in a string which >> > appears >> > multiple times. >> > >> > T

Re: [ADMIN] Vacuum Problems

Maybe Could be Check-Points? I have changed the parameters sometime ago. Follow: effective_cache_size = 200MB checkpoint_segments = 40# in logfile segments, min 1, 16MB each checkpoint_timeout = 3min # range 30s-1h #bgwriter_delay = 200ms # 10-1ms