Re: [ADMIN] plpgsql Regression test fails on Digital Unix

Here is my suggestion: Just for this test, change plpgsql.so access code as 777, after you test, change it back as 640. Macht das schoen? Grusse, --Bangh Reiner Dassing wrote: > Hello! > After installation the PostgreSQL Version 6.5.2 on Digital Unix V4.0F > I did the regression tests. > > T

Re: [ADMIN] New Administrator

Upon his requirement, you also need to grant this administrator as a superuser of postgres when you run shell command createuser. --Banghe "Doran L. Barton" wrote: > Not long ago, Mike Field proclaimed... > > I'm getting a bit confused by the manual on this one, so excuse my > > ignorance. > >

Re: [ADMIN] Grant rule???

> >RULE has special meaning. Other previliges you can grant are: > >select, delete, update > > > >--Banghe > > Ahhh! Just what is the special meaning of RULE? It means you grant a user privilege that he can create RULE on the table. ( you can get more info how to create a rule, see CREATE RU

Re: [ADMIN] Cannot connect to server.

make sure the postmaster on postgres server is running. You can check if it is listening: netstat -an | grep 5432 --Banghe Andrew Higgs wrote: > Hi all, > > I am writing a program in Delphi which connects to my linux postgres box > (6.5.1). This was working just fine until the power fail thre

Re: [ADMIN] Grant rule???

under psql you can get help for SQL statement grant. grant rule on table to someone menas you grant someone on the table previlige: RULE. RULE has special meaning. Other previliges you can grant are: select, delete, update --Banghe hal Lynch wrote: > In the following grant statement what do

Re: [ADMIN] configurate postmaster

Hi , There is no problem to do so. Check this file: pg_hba.conf You can set host-base access control. --Banghe [EMAIL PROTECTED] wrote: > Hello, > > My postgresql base is on machine A. Me I'm on machine B. > I would like > to connect to my postgresql system from machine A (with my > soft in >

[ADMIN] how to add entry in pg_hba.conf?

Hello, Q: how to add entry in pg_hba.conf? I manually added an entry in pg_hba.conf as: host template1 postgres_IP 255.255.255.0 banghe banghe But as I run the code and got msg: the file pg_hba.conf is crashed. I wonder if I can manually edit this file. (to locally connect postmaster seems n

Re: [ADMIN] data problem

Here is a suggestion to identy your problem. Create a very simple table with some reocrds on your old postgres, then pgdump, and restory on your new postgres. See is there a problem? If no, then there must have some functions used in your old database which are different from in the new version.