Re: [ADMIN] Postgres 9 on 64 bit

2011-09-27 Thread Kevin Grittner
ALEXANDER JOSE wrote: > I want to know the experience of installing postgres 9 in 64 bit, > on suse enterprise linux 11 We're running about 100 development database clusters and about 100 production clusters on about 90 SLES 10 servers -- all 64 bit. No problems; we're quite happy with it

[ADMIN] Postgres 9 on 64 bit

2011-09-27 Thread ALEXANDER JOSE
Hi, I want to know the experience of installing postgres 9 in 64 bit, on suse enterprise linux 11 thank Alexander Angel Venezuela

[ADMIN] timeline X of the primary does not match recovery target timeline Y

2011-09-27 Thread Adam Tistler
I am trying to set up master/slave warm standby streaming replication (9.1). I am not doing archiving/log shipping. I have read that you cannot reverse roles between the master and slave, and that once a slave is "promoted", you need to use pg_basebackup or rsync to copy files from the newly

Re: [ADMIN] PostgreSQL question

2011-09-27 Thread Mridul Mathew
Okay, thanks! -Mridul. On Tue, Sep 27, 2011 at 12:14 AM, Guillaume Lelarge wrote: > On Mon, 2011-09-26 at 16:06 +0530, Mridul Mathew wrote: > > Hello, > > > > I wanted to take a moment here and reach out to the community with a > > question. How does postgreSQL handle schema switching in the dat

Re: [ADMIN] problems logging in through phpPgAdmin

2011-09-27 Thread Davenport, Julie
OK, I see what you are saying. I guess we need to reset the password of the postgres user inside the database. I'm out of the office but will try this next week when I'm back in. Thanks much for your help. Julie From: John DeSoi [de...@pgedit.com] Sent

Re: [ADMIN] Is there a list of pg pre-defined functions?

2011-09-27 Thread Rural Hunter
erh...I'm sorry...I can not understand why I just didn't find this! 于2011年9月27日 17:50:04,Ian Lea写到: great, thanks. is there any other system function besides string functions? Come on, it's not that hard! One click away on the link you were given. http://www.postgresql.org/docs/current/stati

Re: [ADMIN] Is there a list of pg pre-defined functions?

2011-09-27 Thread Ian Lea
> great, thanks. is there any other system function besides string functions? Come on, it's not that hard! One click away on the link you were given. http://www.postgresql.org/docs/current/static/functions.html -- Ian. On Tue, Sep 27, 2011 at 10:44 AM, Rural Hunter wrote: > great, thanks. is

Re: [ADMIN] Is there a list of pg pre-defined functions?

2011-09-27 Thread Rural Hunter
great, thanks. is there any other system function besides string functions? 于2011年9月27日 17:37:29,Thomas Kellerer写到: Rural Hunter, 27.09.2011 11:00: I am looking for something like a string hash function to order a string cloumn randomly. It's all in the manual ;) http://www.postgresql.org

Re: [ADMIN] Is there a list of pg pre-defined functions?

2011-09-27 Thread Thomas Kellerer
Rural Hunter, 27.09.2011 11:00: I am looking for something like a string hash function to order a string cloumn randomly. It's all in the manual ;) http://www.postgresql.org/docs/current/static/functions-string.html Thomas -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)

[ADMIN] Is there a list of pg pre-defined functions?

2011-09-27 Thread Rural Hunter
I am looking for something like a string hash function to order a string cloumn randomly. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin