I've renamed the file to "pg_hba.conf". It's owner and groug are now postgres.
The file is located in /usr/lib/pgsql/. I'm still receiving the same error.
On Mon, 04 Sep 2000 07:47:08 Christopher Sawtell wrote:
> On Tue, 05 Sep 2000, Craig May wrote:
> > Hi,
> >
> > I'm recieving an error
On Tue, 05 Sep 2000, Craig May wrote:
> Hi,
>
> I'm recieving an error "No pg_hba.conf entry for host XXX, usr XXX, database
> XXX." I've modified the pg_hba.conf.sample file to allow all access, however
> still getting the same message. Any suggestions?
you have copied pg_hba.conf.sample to pg
Craig May wrote:
>
> I've renamed the file to "pg_hba.conf". It's owner and groug are now postgres.
> The file is located in /usr/lib/pgsql/. I'm still receiving the same error.
>
if you are running redhat 6.X as i suspect
you should place that file in /var/lib/pgsql
not /usr/lib/pgsql
ch
Craig May wrote:
> I've renamed the file to "pg_hba.conf". It's owner and groug are now postgres.
> The file is located in /usr/lib/pgsql/. I'm still receiving the same error.
Network setup? Contents of pg_hba.conf? How should someone
tell you what's wrong with the information you
Hello
I have a litle problem with sequences.
I use drop sequence in transaction, is this possible?
If yes, then i have done:
1. begin
2. get some data
3. drop sequence s_acc
4. create sequence s_acc...
5. rollback
And after this the database responds like this:
test=# \d s_acc
Sequence "s_
Andreas Tille <[EMAIL PROTECTED]> writes:
> I've got the following error message:
> ERROR: function declared to return varchar returns multiple values in
> final retrieve
This is a bug that has already been fixed in current sources: the check
that makes sure your select produces only one varchar
Ok,
Here are all the details:
Redhat 6.1
pgsql 7.0
Firewall open on port 3456
pg_hba.conf contains the following line
host all0.0.0.0 0.0.0.0 trust
and is now located in both:
/usr/lib/pgsql/ and /var/lib/pgsql/
This file is owned by "postgres".
The error m
Found it!
The file should be located in /var/lib/pgsql/data/
Thanks for your help all =)
Craig May
Enth Dimension
http://www.enthdimension.com.au
On Tue, 05 Sep 2000 11:11:25 Craig May wrote:
> Ok,
>
> Here are all the details:
>
> Redhat 6.1
> pgsql 7.0
> Firewall open on port 3456
>
>
On Mon, 4 Sep 2000, Tom Lane wrote:
> This is a bug that has already been fixed in current sources: the check
> that makes sure your select produces only one varchar column is
> mistakenly counting the hidden IdSort column that's needed to sort by.
Is there any patch against 7.0.2 sources which m
