[ADMIN] Please Help me ???

2003-09-19 Thread utomo restu
To all, I want to ask some questions: 1. I want to changes the posisions of postgres super user with my user, so my user have a function same with postgres super user (I want only one super user in my database). so if i do it, what happens on my database...?? 2.How i now total

Re: [ADMIN] initdb problem

2003-09-19 Thread Robert Treat
On Thu, 2003-09-18 at 09:25, Jaskier wrote: Hi, No it will not work, You have to be owner, or have full access to this directory. Also you should, I think this is necessary to run Initdb as a Postgres user. It can't be run as root, but it can be run as any other user. The key is that

Re: [ADMIN] urgently required: postgresql 7.2.1 for sun sparc solaris

2003-09-19 Thread scott.marlowe
On Fri, 19 Sep 2003, Sam Barnett-Cormack wrote: Well, it might sound obvious, but you could always download the source and compile it... On Fri, 19 Sep 2003, John Clarke wrote: I wonder if you can help I am trying to obtain an older version of postgresql: postgresql 7.2.1 for a sun

[ADMIN] postgres[20563]: [73256] FATAL 1: invalid length of startup packet

2003-09-19 Thread Priya G
Hi all, The following message was found in the postgres logpostgres[20563]: [73256] FATAL 1: invalid length of startup packet what does this mean? Thanks Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage.

Re: [ADMIN] [PERFORM] How to force an Index ?

2003-09-19 Thread Josh Berkus
Rhaoni, ... gsames00.ano_mes = to_char(ftnfco00.data_emissao,'MM') AND ... Then it uses the gsames00 index instead of a SeqScan 'cuz it is camparing same data type, but .. I don't want to create this function 'cuz this aplication is used with Oracle too. You should have said that