[SQL] pg_hba.conf
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? Regards, Craig May
Re: [SQL] pg_hba.conf
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 "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_hba.conf havn't you? > > If that dosn't work check the permissions. The file has to readable by the > pgsql server/backend. > > -- > Sincerely etc., > > NAME Christopher Sawtell > CELL PHONE 021 257 4451 > ICQ UIN45863470 > EMAIL csawtell @ xtra . co . nz > CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz > > -->> Please refrain from using HTML or WORD attachments in e-mails to me <<--
Re: [SQL] pg_hba.conf
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 message is as follows: "No pg_pba.conf entry for host 203.36.78.179, usr root, database reflexions" I'm using the postgresql jdbc driver. The machines are on the same subnet, however, there are no additional relations between the machines. The connection is successful from localhost. Finally, I have restarted the postgresql service between every change. Regards. Craig May Enth Dimension http://www.enthdimension.com.au On Mon, 04 Sep 2000 10:19:35 Jan Wieck wrote: > 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 gave us that > far? > > > Jan > > -- > > #==# > # It's easier to get forgiveness for being wrong than for being right. # > # Let's break this rule - forgive me. # > #== [EMAIL PROTECTED] # >
Re: [SQL] pg_hba.conf
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 > > 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 message is as follows: > > "No pg_pba.conf entry for host 203.36.78.179, usr root, database reflexions" > > I'm using the postgresql jdbc driver. The machines are on the same subnet, > however, there are no additional relations between the machines. The connection > is successful from localhost. Finally, I have restarted the postgresql service > between every change. > > Regards. > Craig May > > Enth Dimension > http://www.enthdimension.com.au > > > On Mon, 04 Sep 2000 10:19:35 Jan Wieck wrote: > > 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 gave us that > > far? > > > > > > Jan > > > > -- > > > > #==# > > # It's easier to get forgiveness for being wrong than for being right. # > > # Let's break this rule - forgive me. # > > #== [EMAIL PROTECTED] # > >
[SQL] Cascading Deletes
Hi, I have a tables having this structure: ID (int) | _ID (int) | Name (String) _ID is the parent of ID. I'm looking for the best method to perform a cascade delete. For example, I delete _ID, it in turn deletes ID, and should ID also be an entry within _ID, it would continue through the chain. For example: 0 0 Base 1 0 Sib1 2 0 Sib2 3 0 Sib3 4 1 Sib1_1 5 1 Sib1_2 Deleting Base would remove all the entries. Deleting Sib1 would delete Sib1_1 and Sib1_2. Can anyone help out here? Regards, Craig May Enth Dimension http://www.enthdimension.com.au
[SQL] Trigger
Could someone send me a quick example of a trigger.
[SQL] Join
Hi, I'm having trouble with this statement, could someone help out please. Select g.ID From Grouping g join Entity_Grouping eg on g.ID=eg.Group_ID where eg.Entity_ID=1 The error message is: ERROR: transfromExpr: does not know hot to transfrom node 501 (internal error) Craig May Enth Dimension http://www.enthdimension.com.au/
[SQL] currval
Hi,
I'm executing the following statements in series.
insert into [tablename] values('a', 'b', 'c');
select currval('serial');
serial being the default index on [tablename]
The statement works fine from the command line, however, when executing via
jdbc, I'm getting no results back (null pointer).
Has anyone experienced this and have a solution?
Regards,
Craig May
Enth Dimension
http://www.enthdimension.com.au
[SQL] createuser
Hi, I'm having trouble with the createuser command. createuser -adq username returns invalid option adq Could someone post an example using these args. Regards, Craig May Enth Dimension http://www.enthdimension.com.au
[SQL] Windows 9X
Hi, Has anyone installed postgresql on a box running Win9X, if so, could you provide some pointers on getting started. Regards, Craig May Enth Dimension http://www.enthdimension.com.au
[SQL] JDBC Performance
Hi, I've been using the postgresql.Driver with JDBC for some time. Initially, I was passing Statement objects through functions to each of the Classes. This was working beautifully. I have since adapted my application to support MS SQL Server. SQL Server doesn't allow a statement object to perform multiple queries, so i have changed the application to create additional Connections. This has reduced it's performance around 400%. I'm using the driver contained with Postgresql 7.1 Does anyone have ideas on increasing performance with multiple connections? Kind Regards, Craig May Enth Dimension http://www.enthdimension.com.au
[SQL] COUNT
Hi, How do I get a row count, like "Select [COUNT] from Table" ?? Regards, Craig May Enth Dimension http://www.enthdimension.com.au
[SQL] Large Objects
Hi, Could someone please provide a demo of creating the type "Lo". Regards, Craig May Enth Dimension http://www.enthdimension.com.au
[SQL] Postgresql Site Search
Considering postgresql performs so well for me here, why is the postgres site search so fucking slow??
[SQL] Like Query on BLOB's
Hi, Does anyone know if it's possible to do a like query on an oid (blob)? Regards, Craig May Enth Dimension http://www.enthdimension.com.au
[SQL] Help on Union Query
Hi, I have an Index table with the following structure: | Node_ID (int) | Word (varchar)| and attempting to perform a query that returns the distinct Node_ID for an occurence of [word] in addition to a count of that [word] within the Node_ID. Here is the query I have atm: select distinct on (Node_ID) Node_ID from NodeIndex where word='[a word]' union select count(*) from NodeIndex where Node_ID in (select distinct on (Node_ID) Node_ID from NodeIndex where word='[a word]') order by count; Any assistance would be appreciated. Craig May Enth Dimension http://www.enthdimension.com.au
[SQL] @@Identity
Does anyone know if there is an equivalent statement to SQL Servers select @@Identity?
[SQL] Database Transfer
Hi, I have two servers running pgsql. Is there a command to transfer the databases between them? Craig May Enth Dimension http://www.enthdimension.com.au
