Re: [ADMIN] 8.3.0 postinstallation trouble

2008-02-23 Thread Tena Sakai
Hi Everybody, I found a solution for my problem. What I did was to edit the pg_hba.conf and replaced 'md5' for user postgres with 'trust' which lets me execute: /usr/local/pgsql/bin/psql -d -f saved_file It ran fine and then I put 'md5' back in place of 'trust.' Now all seems fine. I will

Re: [ADMIN] PL/pgSQL memory consumption?

2008-02-23 Thread Tom Lane
"Peter Koczan" <[EMAIL PROTECTED]> writes: > Correct me if I'm wrong, as well, but I believe that Linux (and > probably other modern Unices) does code-sharing, meaning that separate > processes referring to the same code/libraries will refer to the same > copy in physical memory. > So, even though

Re: [ADMIN] PL/pgSQL memory consumption?

2008-02-23 Thread Peter Koczan
On Fri, Feb 22, 2008 at 8:54 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Dawid Kuroczko" <[EMAIL PROTECTED]> writes: > > I have recently found a nice utility called memstat (which shows how > > much of private > > (not shared)) memory each process uses. What kind of surprised me was > > the amo

[ADMIN] 8.3.0 postinstallation trouble

2008-02-23 Thread Tena Sakai
Hi Everybody, I have gotten my postgres upgraded to 8.3.0 (from 8.2.4) or almost. I followed the steps in the manual, section 15.4. I was able to start 8.3.0 by: /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data via step 7. Now I am ready to restore from the saved file and typed: /u