[ADMIN] (pgsql-bugs) Ref. No: 3218: Problems in installing Postgresql on Windows

Hello, I am using Windows 2000 Professional and I am trying to install Postgresql 8.2.3. I have created a restricted user under Windows called Postgres8.2.3. When I try to use the Postgresql Installation Wizard, at the Service Configuration step, when I have to enter info like Account name,

[ADMIN] Installing Postgresql on Windows

Hello, I am using Windows 2000 Professional and I am trying to install Postgresql 8.2.3. I have created a restricted user under Windows called Postgres8.2.3. When I try to use the Postgresql Installation Wizard, at the Service Configuration step, when I have to enter info like Account name,

Re: [ADMIN] Increasing the shared memory

Hello! I've tried first to increase the number of shared buffers, I doubled it, from 1000 to 2000 (16Mb) Unfortunately this had no effect. Then I increased the number of max_locks_per_transaction from 64 to 128 (these shoul

Re: [GENERAL] [ADMIN] Increasing the shared memory

In response to Sorin N. Ciolofan [EMAIL PROTECTED]: I've tried first to increase the number of shared buffers, I doubled it, from 1000 to 2000 (16Mb) Unfortunately this had no effect. The difference between 8M and and 16M of shared buffers is pretty minor.

Re: [ADMIN] Increasing the shared memory

Sorin N. Ciolofan [EMAIL PROTECTED] writes: This had also no effect. Because I can't see any difference between the maximum input accepted for our application with the old configuration and the maximum input accepted now, with the new configuration. It looks like nothing

Re: [ADMIN] Where are aliases stored?

Thanks, but this does not meet my needs. Is there not a way to query the pg_ catalog views and get a listing of views with columns (by alias name)? i.e. create view asdf as select xyz as test1 from bogus_table; I need a query that says: view|column|alias asdf|xyz|test1 Thanks, Chris On

Re: [ADMIN] Where are aliases stored?

Am Donnerstag, 12. April 2007 16:46 schrieb Chris Hoover: Is there not a way to query the pg_ catalog views and get a listing of views with columns (by alias name)? The column names (what you call alias names) are in pg_attribute, the views are in pg_class. -- Peter Eisentraut

[ADMIN] question on plpgsql block

Hi Gurus, I tried a plpgsql block from the php. example a='begin insert into table a values (); insert into table b values () insert into table c values (...) select into p_var ... from table where condtion update a set column = new value

Re: [ADMIN] question on plpgsql block

Karthikeyan Sundaram wrote: I tried a plpgsql block from the php. plpgsql blocks only work in a plpgsql function. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[ADMIN] setting up a mirroring or replication database

Hi Team, We are using Postgres 8.1.0 and in the plans to migrate to 8.2.3. Ours is a OLTP application. Publishers, advertisers and consumers use our system world wide. Right now it's not a very big database. But we are expanding our operations to Europe and US where we are expecting

Re: [ADMIN] [SQL] setting up a mirroring or replication database

This may best be asked in the admin group - please don't cross-post. Let's keep all further discussion in the admin group. A good starting place for you would be the PostgreSQL manual, specifically the chapter called High Availability: