My mistake, the "-h host_IP" explicitly states which IP address to
listen on.
/usr/bin/postmaster -h your_IP -p 5432 -D /var/lib/pgsql/data –i
I'm not sure if postgresql v7.x.y already used the pg_ctl command which
is essentially a wrapper for postmaster, if so use,
pg_ctl -w -o "-h your_IP
Try using the following format in the pg_hba.conf file:
host all all(or your_user_account) your_IP/32 trust (The 32 is the same
as 255.255.255.255 but in CIDR format)
As for the command line you started postmaster with, doesn't the "-i"
require an interface such as an IP address too? If you l
All,
I have read message after message and searched the internet
for hours, yet I still can’t get a remote computer to connect to port
5432 on my Fedora Core 3 system running Postgresql 7.4.7.
What I have done:
1) Stopped the iptables service
2) Modified postgresql.conf and
"Jimmy Choi" <[EMAIL PROTECTED]> writes:
> Say I have the following parameterized query in a function:
> select * from foo where ($1 = -1 or foo.status = $1) and (...)
> Suppose that at runtime, $1 is supplied a value of -1, does the
> foo.status = $1 condition still have to be evaluated?
The PG
Jim C. Nasby wrote:
On Mon, May 15, 2006 at 12:24:51PM -0700, TJ O'Donnell wrote:
I've written some extensions to postgres to implement
chemical structure searching. I get inquiries about
the performance of postgres vs. oracle. This is a huge
topic, with lots of opinions and lots of facts. Bu
Jim C. Nasby wrote:
On Mon, Jun 12, 2006 at 02:44:34PM -0700, [EMAIL PROTECTED] wrote:
1. How can I store the word doc's in the DB, would it be best to use a
BLOB data type?
Use a bytea field.
2. Does Postgres support full text searching of a word document once it
Nope.
Not natively. It
On Tuesday 2006-06-13 16:19, Jim C. Nasby wrote:
> On Mon, May 15, 2006 at 12:24:51PM -0700, TJ O'Donnell wrote:
> > I've written some extensions to postgres to implement
> > chemical structure searching. I get inquiries about
> > the performance of postgres vs. oracle. This is a huge
> > topic,
On Tuesday 2006-06-13 09:26, David Fetter wrote:
> On Tue, Jun 13, 2006 at 09:18:17AM -0600, Scott Ribe wrote:
> > > What say we just stop right there and call Date's Relational Model
> > > what it is: a silly edifice built atop wrong premises.
> >
> > SQL was a quick and dirty hack (Systems R and
Thank you Joachim,
it woks!
Regards,
Luis A Perez Paz
On 6/13/06, Joachim Wieland <[EMAIL PROTECTED]> wrote:
Luis,On Tue, Jun 13, 2006 at 01:19:32PM -0500, Luis Alberto Pérez Paz wrote:> The program works fine, actually I can verify that it executes the FUNCTION
> 'myFunction', however I
On Mon, May 15, 2006 at 12:24:51PM -0700, TJ O'Donnell wrote:
> I've written some extensions to postgres to implement
> chemical structure searching. I get inquiries about
> the performance of postgres vs. oracle. This is a huge
> topic, with lots of opinions and lots of facts. But,
> today I go
Luis,
On Tue, Jun 13, 2006 at 01:19:32PM -0500, Luis Alberto Pérez Paz wrote:
> The program works fine, actually I can verify that it executes the FUNCTION
> 'myFunction', however I dont know how can I get the return value of the
> FUNCTION 'myFunction' (as you can see in the little example the re
If you're trying to do what I think you're trying to do, you might need
to create the temp table before you create the function (in the same
session).
Posting a test case people could look at somewhere would be easier than
reading a bunch of description about the problem.
On Tue, Jun 13, 2006 at
On Mon, Jun 12, 2006 at 06:58:06PM -0400, Tom Lane wrote:
> "Milen Kulev" <[EMAIL PROTECTED]> writes:
> > What is wrong with random() ?
>
> Not guaranteed to be stable across the multiple evaluations that the
> rule will perform ... remember a rule is a macro and has the usual
> multiple-evaluati
On Mon, Jun 12, 2006 at 02:44:34PM -0700, [EMAIL PROTECTED] wrote:
> 1. How can I store the word doc's in the DB, would it be best to use a
> BLOB data type?
Use a bytea field.
> 2. Does Postgres support full text searching of a word document once it
Nope.
> is loaded into the BLOB column & h
Ron Mayer <[EMAIL PROTECTED]> wrote:
> David Fetter wrote:
>>> the terse mathematical notation commonly used...
>> Again, if you have a piece of software you can point to that does
>> this
>> thing, please do so.
>
> I seriously doubt it follows Date or Pascal religiously, but
> it does have a conv
On 10/6/2006 4:37, "Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
> On Fri, Jun 09, 2006 at 01:51:23PM -0500, Scott Marlowe wrote:
>> On Fri, 2006-06-09 at 12:51, Jim C. Nasby wrote:
>>> On Fri, Jun 09, 2006 at 01:35:44PM -0400, Wei Weng wrote:
Is there any OSS solutions (stable) for postgresql re
On Tue, Jun 13, 2006 at 02:34:36PM -0400, Jimmy Choi wrote:
> Suppose that at runtime, $1 is supplied a value of -1, does the
> foo.status = $1 condition still have to be evaluated?
SQL doesn't offer any kind of guarentees about order of evaluations,
and neither does postgres. It may occasionally
David Fetter wrote:
On Tue, Jun 13, 2006 at 12:51:57PM -0400, Merlin Moncure wrote:
On 6/13/06, David Fetter <[EMAIL PROTECTED]> wrote:
SQL was a quick and dirty hack...
>
If there are better alternatives, they will need to show some
real-world attributes, not mathematically-inspired fantasie
Hi,
In Postgres 8.1, MAX() was rewritten to use index backward search without
doing seq_scan. This achieves a huge performance gain. But I found that when
I use MAX() on a partitioned table, it reverses back to the old seq_scan
plan. Wouldn't it be more efficient to get MAX() from each partition t
Say I have the following parameterized query in a function:
select * from foo where ($1 = -1 or
foo.status = $1) and (…)
where the (…) part consists of more parameterized
conditions similar to the first one.
Suppose that at runtime, $1 is supplied a value of -1, does
the foo.sta
Hi,
Thanks a lot for your answer,
Let me give you a simple example with more detail:
In my postgres database I have a function called "myFunction".
//
CREATE OR REPLACE FUNCTION myFunction(INT) RETURN INT AS '
DECLARE
Thanks,
In my first question I would like to use xmin instead of cmin, even so I
could understand the logic.
Then for each XID you have 2 bilions XIDs that are considered lower than and
the other 2 bi higher than.
About row visibility: are all the rows with xmin higher than my XID be
considered
When using a temp table in plpgsql functions that has columns comprised
from many tables populated by joins, how do you specify a temp table return
type when its generated by select into and dropped dynamically? I get an
error when I specify returns setof temp_table. Also when I specify a
perman
2) Re: "still-vaporware Relational Model"- the relational model is a
mathematical model for data representation. Your comment makes as much
sense as claiming that "Newtonian physics" is vaporware.
If we're discussing the "luminiferous aether", then, yes, vaporware
seems /somewhat/ appropriate.
Yesterday on this list I found out about the nifty setting
custom_variable_classes='global'
which allows the setting and retrieving of arbitrary values that persist
across statements.
I wonder if there is a way to do the same thing within the scope of a
transaction? Is there a "magic" valu
On Tue, Jun 13, 2006 at 12:51:57PM -0400, Merlin Moncure wrote:
> On 6/13/06, David Fetter <[EMAIL PROTECTED]> wrote:
> >> SQL was a quick and dirty hack (Systems R and R* needed some way
> >> to interface with data) with multiple deficiencies recognized and
> >> documented right within the very fi
jqpx37 wrote:
I can envision, broadly, two authentication schemes:
(1) Users authenticate to Apache.
(2) Users authenticate to PG.
This is a little too complicated.
The most accurate and precise security is obtained by having the user
log in with a real postgres account, and to grant tabl
On 6/13/06, David Fetter <[EMAIL PROTECTED]> wrote:
> SQL was a quick and dirty hack (Systems R and R* needed some way to
> interface with data) with multiple deficiencies recognized and
> documented right within the very first paper by its own authors.
Perfection isn't a human attribute. There
> Now, there's another thing that makes it amazingly hard to displace:
> imagining what would be better *enough* to justify the many millions of
> people-years and even more billions of dollars needed to move away from
> it. Despite Date's many whines over the decades, his still-vaporware
> Relati
On Tue, Jun 13, 2006 at 09:18:17AM -0600, Scott Ribe wrote:
> > What say we just stop right there and call Date's Relational Model
> > what it is: a silly edifice built atop wrong premises.
>
> SQL was a quick and dirty hack (Systems R and R* needed some way to
> interface with data) with multiple
Thanks to everyone who replied to my previous post, "PostgreSQL and Apache,"
where I asked about references describing how to get PostgreSQL and Apache
working together.
Here, I'll ask the specific questions which motivated that post.
The setup: I'm working on a database project. We chose Pos
On Tue, Jun 13, 2006 at 12:10:26PM -0300, Carlos H. Reimer wrote:
> When xid overflows (32 bits) the next one will be 3 (1 and 2 are reserved).
>
> In this case, we could have have lines with cmin 4.294.967.295 and lines
> with cmin 3. How are they compared to determine that
> rows with cmin 3 are
"Carlos H. Reimer" <[EMAIL PROTECTED]> writes:
> I would like to understand better the logic to determine when a xid is older
> than another one.
It's circular mod 2^32, with a special case for FrozenXID. It's a
mistake to imagine that XIDs are unsigned ints, really --- the
comparison doesn't wor
> What say we just stop right there and call Date's Relational Model
> what it is: a silly edifice built atop wrong premises.
SQL was a quick and dirty hack (Systems R and R* needed some way to
interface with data) with multiple deficiencies recognized and documented
right within the very first pa
Hi,
I would like to understand better the logic to determine when a xid is older
than another one.
As I could understand, the XID is always incremented, never reset. If it is
true, then we can have rows with cmin ranging
from 1 to 4.294.967.295 (2^32-1).
When xid overflows (32 bits) the next one
[EMAIL PROTECTED] writes:
> I'm experiencing a strange problem with PostgreSQL 7.4.9.
> One of my database production servers has 2 large databases, it's still
> possible to connect to them and pass queries, but the pg_database
> system table is empty, which prohibits such actions as dumping the
>
louis gonzales wrote:
PHP is one alternative, another is PERL with CGI to write web based
programs that can GET/POST with input/output from the browser, and to
interface with *SQL - i.e. postgresql - you can use PERL's DBI interface
Leif B. Kristensen wrote:
On Tuesday 13. June 2006 15:39, j
PHP is one alternative, another is PERL with CGI to write web based
programs that can GET/POST with input/output from the browser, and to
interface with *SQL - i.e. postgresql - you can use PERL's DBI interface
Leif B. Kristensen wrote:
On Tuesday 13. June 2006 15:39, jqpx37 wrote:
I'm wo
On Tuesday 13. June 2006 15:39, jqpx37 wrote:
>I'm working on a project involving PostgreSQL and Apache.
>
>Anyone know of any good books or online how-to's on getting PostgreSQL
> and Apache to work together? (I'm also using PHP.)
AFAIK, there are no dependencies beween Apache and PostgreSQL. PH
On Mon, Jun 12, 2006 at 08:40:29PM -0700, pradeep singh wrote:
> i think this query can be rewritten as
>
> SELECT claim_id,sum(invoices),sum(payments)
> FROM logs
> GROUP BY claim_id
> HAVING sum(invoices) > 0 OR sum(payments) > 0;
>
> having clause can be used with aggregate functions but
>
Hello All.I have installed version 8.1.4 (located in D:/PostgreSQL/8.1 ) on Windows XP and try to create language with command CREATE LANGUAGE or createlang command line tool but in any way got an error:postgres=# create language plperl;
ERROR: could not load library "D:/PostgreSQL/8.1/lib/plperl.
I'm working on a project involving PostgreSQL and Apache.
Anyone know of any good books or online how-to's on getting PostgreSQL and
Apache to work together? (I'm also using PHP.)
TIA
---(end of broadcast)---
TIP 6: explain analyze is your friend
- Original Message -
From: "Chris Browne" <[EMAIL PROTECTED]>
To: pgsql-general@postgresql.org
Sent: Thursday, June 08, 2006 01:30 PM
Subject: [GENERAL] Password for postgresql superuser?
> [EMAIL PROTECTED] ("jqpx37") writes:
>
> > Is there any security risk in the postgresql superuser h
Alban Hertroys wrote:
Hi all,
We're using some 3rd party product that uses inheritence, and the
following query is rather slow on PostgreSQL 7.4.7 (debian stable). Any
suggestions how to speed it up?
A few more datapoints:
- Database was vacuum full analyzed just before the query.
- The same
Title: Re: [GENERAL] delete seems to be getting blocked
however if the for every
occuerence of the foreign key there are some 2000 rows in the table, is it
ok to still have an index on that foreign key.
also will index scan still
take place or postgres will itself choose to do sequential
Hi all,
We're using some 3rd party product that uses inheritence, and the
following query is rather slow on PostgreSQL 7.4.7 (debian stable). Any
suggestions how to speed it up?
explain analyze SELECT
otype,owner,rnumber,dir,number,dnumber,pos,snumber FROM mm_posrel posrel
ORDER BY number D
Fernando Sánchez Cervera wrote:
Every two days, Postgres 8.1 Server is unconfigured without apparent
changes done. The service under windows XP is always stoped.
I work under XP SP2.
has somebody any idea?
What do the logs show? Either PostgreSQL's or Window's logs should show
something hap
Save yourself some effort and use Lucene to index a directory of your 300
word documents. I'm pretty sure that Lucene includes an extension to read
Word documents, and you can use PDFBox to read/write PDF files. Marrying
the searching and displaying of results to your web application should be
triv
Pat Maddox wrote:
Here's my SQL query. I don't think it's too gigantic, but it is kind
of beastly:
SELECT COUNT(r) FROM trainer_hand_results r, trainer_scenarios s,
trainer_scenario_stats stats WHERE r.user_id=1 AND
r.trainer_scenario_id=s.id AND s.id=stats.trainer_scenario_id AND
r.action=stat
[EMAIL PROTECTED] wrote:
Hello,
I'm experiencing a strange problem with PostgreSQL 7.4.9.
One of my database production servers has 2 large databases, it's still
possible to connect to them and pass queries, but the pg_database
system table is empty, which prohibits such actions as dumping the
d
James Watson wrote:
What I was hoping someone could help me out with was identifying the
best possible solution to use.
1. How can I store the word doc's in the DB, would it be best to use a
BLOB data type?
You can use the column type "bytea", which can store (nearly) arbitrary
amounts of binar
On Tue, 13 Jun 2006, John Tregea wrote:
> Thanks Brent,
>
> I will be cautious in my approach. The public schema is the place that I
> wanted to use to store the geometry attributes, so from your points,
> that sounds like the best place. The other schemas contain controlled
> (security) informa
On Tue, 13 Jun 2006, John Tregea wrote:
> Hi Brent,
>
> I will look at postGIS today. I will try and keep the whole GIS
> functionality as a separate schema to avoid confusing myself, so a
> postGIS may be exactly what I am looking for.
>
Ummm... one caution:
The lovely side effect, apart from
On Mon, 12 Jun 2006, John Tregea wrote:
> Hi,
>
> I have recently switched to PostgreSQL and had no problem bringing our
> existing (my)SQL databases and data into the environment. I am now
> extending the functionality of our databases and want to start storing
> spatial information.
>
> The in
Every two days, Postgres 8.1 Server is unconfigured without apparent
changes done. The service under windows XP is always stoped.
I work under XP SP2.
has somebody any idea?
Do the list accept messages in spanish?
---(end of broadcast)---
TIP 9
Hi,I am not 100% sure what the best solution would be, so I was hopingsomeone could point me in the right direction.I usually develop in MS tools, such as .net, ASP, SQL Server etc...,but I really want to expand my skillset and learn as much about Postgresqlas possible.
What I need to do, is desig
Hello,
I'm experiencing a strange problem with PostgreSQL 7.4.9.
One of my database production servers has 2 large databases, it's still
possible to connect to them and pass queries, but the pg_database
system table is empty, which prohibits such actions as dumping the
databases.
For instance:
[
Hi,
I am not 100% sure what the best solution would be, so I was hoping
someone could point me in the right direction.
I usually develop in MS tools, such as .net, ASP, SQL Server etc...,
but I really want to expand my skillset and learn as much about
Postgres
as possible.
What I need to do, is
On Mon, Jun 12, 2006 at 11:14:24PM -0400, Peter L. Berghold wrote:
> what I don't see is how to detect that I've fetched the last row from a
> query. Is there more complete doco on this process somewhere?
You could either handle a NOT FOUND exception, or make use of SQLCODE or
SQLSTATE like thi
On 6/13/06, Chris <[EMAIL PROTECTED]> wrote:
Pat Maddox wrote:
> Here's my SQL query. I don't think it's too gigantic, but it is kind
> of beastly:
>
> SELECT COUNT(r) FROM trainer_hand_results r, trainer_scenarios s,
> trainer_scenario_stats stats WHERE r.user_id=1 AND
> r.trainer_scenario_id=s
Pat Maddox wrote:
Here's my SQL query. I don't think it's too gigantic, but it is kind
of beastly:
SELECT COUNT(r) FROM trainer_hand_results r, trainer_scenarios s,
trainer_scenario_stats stats WHERE r.user_id=1 AND
r.trainer_scenario_id=s.id AND s.id=stats.trainer_scenario_id AND
r.action=stat
Here's my SQL query. I don't think it's too gigantic, but it is kind
of beastly:
SELECT COUNT(r) FROM trainer_hand_results r, trainer_scenarios s,
trainer_scenario_stats stats WHERE r.user_id=1 AND
r.trainer_scenario_id=s.id AND s.id=stats.trainer_scenario_id AND
r.action=stats.correct_action;
62 matches
Mail list logo
