[ADMIN] initdb.exe error while installing postgres 8.0

Hi all, When I tried to install Postgresql 8.0 on windows xp (ntfs) on my system it gave me the following error: initdb.exe Application error: the application failed to initialize properly (0xc022). Clikc on OK to to terminate the application. then it gave me a message: Failed to run initdb:

Re: [ADMIN] postgres 7.2.1 pg_restore large objects

Dario <[EMAIL PROTECTED]> writes: > I have two different versions of postgres, one compiled by someone here, > and another version, installed via rpm. > unlikely, upgrading to a different version, is not an option, I probably > update to 7.2.(last version), but only if this specific problem is

[ADMIN] postgres 7.2.1 pg_restore large objects

Problem: Not being able to restore a database with lo. I have already read forums and doc. Probably I'm loosing something, but I just can figure. Reading forums I though I finally got a "right" way to do it. I'm running this as OS user "postgres" which is a super user pg_dump -Ft -o -b base > ba

[ADMIN] Logging question

Because of customer requirements, I need to log all database modifying SQL, including the data itself, to a text file. This file will be protected to prevent all but a small, select number of users from viewing because of the secure nature of the data. They also want postgres status messages (sta

Re: [ADMIN] Security Release

Thanks, I think I am clear now: 8.0.1, 7.4.7, 7.3.9, 7.2.7 are fixed versions, while 8.0.0, 7.4.0-6, 7.3.0-8 and 7.2.0-6 are affected ones. If, ie, my PG version is 7.4.3, I need to upgrade to 7.4.7. -Original Message- From: Magnus Hagander [mailto:[EMAIL PROTECTED] Sent: Wednesday, Marc

Re: [ADMIN] Security Release

>> 2. Which versions does the security hole affect? (Back from 7.2 >> till 8.0?) >> >> Link >> http://archives.postgresql.org/pgsql-general/2005-02/msg00384.php >> >> says "Version(s): 8.0.1, 7.4.7, 7.3.9, 7.2.7", >>

Re: [ADMIN] Security Release

On Wed, Mar 30, 2005 at 10:21:00AM -0700, Lee Wu wrote: > I have some questions regarding post date on Feb 1, 2005 > 1.What is "LOAD" option it referred? The SQL command used to load dynamic libraries. > 2.Which versions does the security hole affect? (Back from 7.2 > till 8.0?) > >

Re: [ADMIN] connectivity to database been an issue for me.

You've got a networking problem, not postgresql, I'd bet. Do the logs on the server show anything odd, like crashing backends? I do not see any crashes and when connected from inside the data center I don't have any issues. Times I see an issue are when we pump any data (large result set, rest

[ADMIN] Security Release

Hi all,   I have some questions regarding post date on Feb 1, 2005 http://archives.postgresql.org/pgsql-announce/2005-02/msg0.php   What is “LOAD” option it referred? Which versions does the security hole affect? (Back from 7.2 till 8.0?)   Link http://archives.postgr

Re: [ADMIN] multiple servers updating from/to one

[EMAIL PROTECTED] (Marco Carvalho) writes: > Hi, all > > I need to do this scenario: > > Web Application Web Application Web Application >| | > | > pgsql server 1 pgsql server 2

Re: [ADMIN] connectivity to database been an issue for me.

On Wed, 2005-03-30 at 10:41, Joel Fradkin wrote: > Hi, > > > > We are in development stage of implementing postgres. > > Our data center is in Tampa and we are in Bardenton and I am using DSL > at my office (384 up, 1.5 down). > > Data center is 2 meg ea way. > > When I use pgadmin to connec

Re: [ADMIN] problems with user rights

On Wed, Mar 30, 2005 at 11:14:38AM -0500, John DeSoi wrote: > On Mar 30, 2005, at 10:17 AM, Zouari Fourat wrote: > > >is it really secure in a shared hosting environnement case ? > >do you advise me to offer pgsql in a shared hosting ? > > You can do all of the necessary things to control access

Re: [ADMIN] compilation problem with readline

On Wed, 2005-03-30 at 10:30, Anjan Dave wrote: > Hi, > > > > I need help compiling 7.4.7 pleaseâ Itâs not able to find readline > library, when the package is already installedâ > > > > checking for readline... no > > configure: error: readline library not found It's the readline-devel rp

Re: [ADMIN] compilation problem with readline

you need to install the readline-devel package On Wednesday 30 March 2005 08:30, Anjan Dave wrote: > Hi, > > > > I need help compiling 7.4.7 please... It's not able to find readline > library, when the package is already installed... > > > > checking for readline... no > > configure: error: read

Re: [ADMIN] compilation problem with readline

Thanks guys that did it! Anjan -Original Message- From: Uwe C. Schroeder [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 11:43 AM To: Anjan Dave Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] compilation problem with readline you need to install the readline-devel packag

Re: [ADMIN] problems with user rights

On Wed, 2005-03-30 at 10:14, John DeSoi wrote: > On Mar 30, 2005, at 10:17 AM, Zouari Fourat wrote: > > > is it really secure in a shared hosting environnement case ? > > do you advise me to offer pgsql in a shared hosting ? > > You can do all of the necessary things to control access to the > d

[ADMIN] connectivity to database been an issue for me.

Hi,   We are in development stage of implementing postgres. Our data center is in Tampa and we are in Bardenton and I am using DSL at my office (384 up, 1.5 down). Data center is 2 meg ea way. When I use pgadmin to connect it is ok, but as soon as I do any querry that has much data I g

[ADMIN] compilation problem with readline

Hi,   I need help compiling 7.4.7 please… It’s not able to find readline library, when the package is already installed…   checking for readline... no configure: error: readline library not found If you have readline already installed, see config.log for details on the failure.  It i

Re: [ADMIN] Many persistant client connections

[EMAIL PROTECTED] writes: > i would like to know if there is something like the Oracle "shared > server" possible with PostgreSQL. I have searched the archives but > have not found any real discussion regarding this. > > We have two CTI applications opening 2-3 persistant connections to > the addre

Re: [ADMIN] problems with user rights

On Mar 30, 2005, at 10:17 AM, Zouari Fourat wrote: is it really secure in a shared hosting environnement case ? do you advise me to offer pgsql in a shared hosting ? You can do all of the necessary things to control access to the databases. You just can't hide that they exist if you provide a way

Re: [ADMIN] problems with user rights

is it really secure in a shared hosting environnement case ? do you advise me to offer pgsql in a shared hosting ? On Wed, 30 Mar 2005 08:04:00 -0500, John DeSoi <[EMAIL PROTECTED]> wrote: > > i've just added a new user called xxx : > > > > create user xxx with password zzz; > > > > now am creati

[ADMIN] multiple servers updating from/to one

Hi, all I need to do this scenario: Web Application Web Application Web Application | | | pgsql server 1 pgsql server 2 pgsql server 3 |

Re: [ADMIN] problems with user rights

i've just added a new user called xxx : create user xxx with password zzz; now am creating it's database : create database db_xxx with owner xxx; it works fine althought when logging with the user xxx i can still view other databases contents especially pg_catalog schems. is it the right way to ad

Re: [ADMIN] problems with user rights

no one can help me over here ? On Mon, 28 Mar 2005 15:32:32 +0200, Zouari Fourat <[EMAIL PROTECTED]> wrote: > Hello, > i've just added a new user called xxx : > > create user xxx with password zzz; > > now am creating it's database : > > create database db_xxx with owner xxx; > > it works fin