Go to the server where you are trying to connect, open the file "pg_hba.conf"
and add the IP of the machine that you are using to connect to ..
i hope this post helps
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/FATAL-no-pg-hba-conf-entry-for-host-1-tp1873063p57180
Hallo Tom,
> I believe the problem is that the one-argument form of to_tsquery() uses
> the default TS configuration, which you have probably not got set to
> "simple". For me, the default TS configuration is "english", which will
> stem "polity" as "politi":
>
> regression=# select to_tsquery('
On 26/07/12 04:09, McGehee, Robert wrote:
Very interesting points. Thanks for the documentation link and the point about
alignment.
As a test of Tom's suggestion to group smallints together to avoid alignment
problems, I changed the column order from
smallint, date, smallint, integer, real TO
At 7:51 PM -0700 25/7/12, Adrian Klaver wrote:
On 07/25/2012 07:47 PM, Chris Bartlett wrote:
At 7:37 PM -0700 25/7/12, Adrian Klaver wrote:
I am guessing if you do show search_path; from psql you will see that
the public schema is before the bob schema. The SELECT for the
unqualified people ta
On 07/25/2012 07:47 PM, Chris Bartlett wrote:
At 7:37 PM -0700 25/7/12, Adrian Klaver wrote:
I am guessing if you do show search_path; from psql you will see that
the public schema is before the bob schema. The SELECT for the
unqualified people table in CREATE VIEW bob.people_view will find
pub
At 7:37 PM -0700 25/7/12, Adrian Klaver wrote:
I am guessing if you do show search_path; from psql you will see
that the public schema is before the bob schema. The SELECT for the
unqualified people table in CREATE VIEW bob.people_view will find
public.people first in that case.
I don't thin
On 07/25/2012 07:25 PM, Chris Bartlett wrote:
I am not sure if this is expected behaviour or a bug.
Using PG 9.2 beta 2 and PGAdmin3 1.16 beta 2.
Connect as bob (superuser)
In public schema:
create table people (cols...)
create view people_view as select * from people
Create schema bob
I am not sure if this is expected behaviour or a bug.
Using PG 9.2 beta 2 and PGAdmin3 1.16 beta 2.
Connect as bob (superuser)
In public schema:
create table people (cols...)
create view people_view as select * from people
Create schema bob
create table bob.people (cols...)
create view
On 07/26/2012 07:12 AM, Tom Lane wrote:
It's more or less the same discussion. To do either one you need to
decouple the internal column order from what the user sees. I do not
think we'd bother with building the infrastructure involved if the
only application were squeezing out alignment paddi
Mike Christensen writes:
> On Wed, Jul 25, 2012 at 1:35 PM, Tom Lane wrote:
>> Yeah, this has been discussed multiple times. The sticking point is
>> the extra infrastructure needed to have a physical column numbering
>> different from the user-visible numbering, and the 100% certainty of
>> int
Johann Spies writes:
> I am beginning to use the full text search facilities in Postgresql
> (9.0) and find the result of this query a bit strange:
> query:
> SELECT ts_headline('simple',title, to_tsquery('kerkreg|(church & polity)'))
> from akb_articles A
> where A.tsv@@ 'kerkreg|(church & pol
On Wed, Jul 25, 2012 at 5:20 PM, Mike Christensen wrote:
> On Wed, Jul 25, 2012 at 1:35 PM, Tom Lane wrote:
>> "McGehee, Robert" writes:
>>> One might even imagine a future version of PostgreSQL using an
>>> efficient disk layout that may not match the table layout in order to
>>> avoid wasted s
On Wed, Jul 25, 2012 at 1:35 PM, Tom Lane wrote:
> "McGehee, Robert" writes:
>> One might even imagine a future version of PostgreSQL using an
>> efficient disk layout that may not match the table layout in order to
>> avoid wasted space from padding.
>
> Yeah, this has been discussed multiple ti
Hi Mark,
For me, Pentaho has delivered quite good results in the past, and being an
open source offering it would probably work OK with postgresql. Jasper
reports also seems to have made it into BI space, and I would assume it'd
work with postgresql too or so I recall. Both are open source
project
Thank you. I will look into those projects.
The initiative is at the earliest stage so there is not a lot of detail
available at the moment.
On Jul 25, 2012, at 11:07 AM, Henry Drexler wrote:
> The combination of pandas ipython and psycopg2 work wonders for pulling data
> from db and manipula
"McGehee, Robert" writes:
> One might even imagine a future version of PostgreSQL using an
> efficient disk layout that may not match the table layout in order to
> avoid wasted space from padding.
Yeah, this has been discussed multiple times. The sticking point is
the extra infrastructure neede
Thanks, Merlin. I will give that one a try.
-Original Message-
From: Merlin Moncure [mailto:mmonc...@gmail.com]
Sent: Wednesday, July 25, 2012 1:32 PM
To: Rachel Owsley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] General guidance: Levenshtein distance versus other
similarity
On Mon, Jul 23, 2012 at 11:55 AM, Rachel Owsley
wrote:
> Hi,
>
> I am hoping you can give me some guidance here. I’m using postgresql 9.1.
>
> Basically, I’m trying to create a query on a table of businesses that will
> return all similar matches to a business name. This is a huge table, and
> the
Very interesting points. Thanks for the documentation link and the point about
alignment.
As a test of Tom's suggestion to group smallints together to avoid alignment
problems, I changed the column order from
smallint, date, smallint, integer, real TO
smallint, smallint, date, integer, real
Thi
The combination of pandas ipython and psycopg2 work wonders for pulling
data from db and manipulating/plotting,
although I don't know in more detail of what the client's use cases are.
On Wed, Jul 25, 2012 at 1:41 PM, Mark Phillips
wrote:
> I am seeking suggestions for business intelligence and
I am seeking suggestions for business intelligence and data mining tools
compatible with postgresql. A new manager at a client's shop is leaning toward
the MS offerings. I would like to be able to speak to the issue.
TIA,
- Mark
--
Sent via pgsql-general mailing list (pgsql-general@postgresql
On Wed, Jul 25, 2012 at 11:42 AM, Merlin Moncure wrote:
> On Wed, Jul 25, 2012 at 10:48 AM, BJ Freeman wrote:
>> I apologize, psql is running
>> if I do
>> [root@main jdbc]# psql -U gameserver
>> passwordfromentityengine.xml
>> with out defining the host, it works.
>>
>> I believe it is using U
On Wed, Jul 25, 2012 at 10:48 AM, BJ Freeman wrote:
> I apologize, psql is running
> if I do
> [root@main jdbc]# psql -U gameserver
> passwordfromentityengine.xml
> with out defining the host, it works.
>
> I believe it is using Unix pipes instead of TCP
> I also can manage the psql server throu
Currently we use the postgresql database verion 8.2.15. And We want to
install the pgbench on the client server. I don't have any idea which
pgbench version is compatible with 8.2.15 and How to install it on Linux
server and Sun solaries server. Please helps thanks.
--
View this message in cont
I apologize, psql is running
if I do
[root@main jdbc]# psql -U gameserver
passwordfromentityengine.xml
with out defining the host, it works.
I believe it is using Unix pipes instead of TCP
I also can manage the psql server through webmin.
Merlin Moncure sent the following on 7/25/2012 8:16 AM:
On Wed, Jul 25, 2012 at 9:57 AM, BJ Freeman wrote:
> did a centos 5.6 server upgrade to PostgreSQL version 8.4.12.
> console:
> [root@main jdbc]# psql -h localhost -U gameserver
> passwordfromentityengine.xml
>
> psql: could not connect to server: Connection refused
> Is the server running
did a centos 5.6 server upgrade to PostgreSQL version 8.4.12.
console:
[root@main jdbc]# psql -h localhost -U gameserver
passwordfromentityengine.xml
psql: could not connect to server: Connection refused
Is the server running on host "localhost" and accepting
TCP/IP connections
Yep, that fixed it. Many thanks for the pointer.
From a performance point of view, I did look at using MOVE rather than
FETCH before I call UPDATE as I don't actually need to read the data
before applying the update. However in this situation, the ROW_COUNT is
always zero and can't be used whi
hello:
i know oracle scatter read blocks,can set db_file_multiblock_read_count
every time,
i see postgres,it exists scatter read blocks,it is seq_scan,how to know
scan many bloks every time?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-to-calculate-or-know-
I am beginning to use the full text search facilities in Postgresql
(9.0) and find the result of this query a bit strange:
query:
SELECT ts_headline('simple',title, to_tsquery('kerkreg|(church & polity)'))
from akb_articles A
where A.tsv@@ 'kerkreg|(church & polity)'
Result
"Kerkvereniging en
> On Wed, Jul 25, 2012 at 6:38 AM, Martin Pitt wrote:
>> http://anonscm.debian.org/loggerhead/pkg-postgresql/postgresql-common/trunk/revision/1181
>
http://anonscm.debian.org/loggerhead/pkg-postgresql/postgresql-common/trunk/annotate/1181/pg_ctlcluster
I still see some pid file unlinking there.
I privately pointed Martin Pitt (Debian maintainer) to this
discussion, his response below.
Martin, I believe what happened is:
the original complainer did /etc/init.d/postgresql restart
this called pg_ctlcluster --force restart
this effectively did: pg_ctlcluster --force stop (which removed the
p
jtkells, 25.07.2012 03:43:
Thanks much for your reply, that does the trick quite nicely. But, I just
came to the realization that this only works if your are running the
client and the file both resides on the database server. I thought that
I would be able to do this from a remote server where
33 matches
Mail list logo
