On Fri, Feb 13, 2009 at 3:43 PM, Bob Pawley wrote:
> In pg_hba there is a reference to reloading postmaster using pg_ctl.
>
> Does postmaster reload when the server is restarted??
Yep. restart shuts down pgsql, and then starts it up fresh, so it has
to read its config files etc. Reload is usefu
On Fri, Feb 13, 2009 at 10:31:49PM +0100, Edoardo Panfili wrote:
> SELECT idSpecie,nome FROM specienomi
> WHERE idspecie=37026 and nome='X Agropogon littoralis (Sm.) C.E. Hubb.';
> idspecie | nome
> --+-
> 37026 | X Agropogon li
Bob Pawley wrote:
In pg_hba there is a reference to reloading postmaster using pg_ctl.
Does postmaster reload when the server is restarted??
depending on your OS, there's a variety of ways of forcing the
postmaster to reload or restart
some changes require a restart, like LISTEN_ADDRES
Sam Mason ha scritto:
On Fri, Feb 13, 2009 at 10:31:49PM +0100, Edoardo Panfili wrote:
The problem arises only with particular records, when the first
character of the string is generated by my function [1].
When the first character is copied from postgres parameter [2] all works
fine.
[1] bu
In pg_hba there is a reference to reloading postmaster using pg_ctl.
Does postmaster reload when the server is restarted??
Bob
- Original Message -
From: "Raymond O'Donnell"
To: "Bob Pawley"
Cc: "John R Pierce" ; "PostgreSQL"
Sent: Friday, February 13, 2009 10:31 AM
Subject: Re: [
On Feb 13, 2009, at 11:59 AM, Ray Stell wrote:
This is probably the wrong place to mention this, but idunno:
I did a search in the docs of pg_standby and was presented this link:
Based on your search term, we recommend the following links:
* http://developer.postgresql.org/cvsweb.cgi/pgsq
On Fri, Feb 13, 2009 at 10:31:49PM +0100, Edoardo Panfili wrote:
> The problem arises only with particular records, when the first
> character of the string is generated by my function [1].
> When the first character is copied from postgres parameter [2] all works
> fine.
>
> [1] buffer[0]='X';
I have this query: (1 result)
SELECT idSpecie,nome FROM specienomi
WHERE idspecie=37026 and nome='X Agropogon littoralis (Sm.) C.E. Hubb.';
idspecie | nome
--+-
37026 | X Agropogon littoralis (Sm.) C.E. Hubb.
The same query
This is probably the wrong place to mention this, but idunno:
I did a search in the docs of pg_standby and was presented this link:
Based on your search term, we recommend the following links:
* http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_standby/
but that link gives a 404
On Fri, Feb 13, 2009 at 4:48 AM, Ashish Karalkar wrote:
> Ashish Karalkar wrote:
>>
>> Abdul Rahman wrote:
>>>
>>> Hi all,
>>>
>>> Can any body tell me about tool for PostgreSQL load testing preferably
>>> freeware.
>>>
>>> Regards,
>>> Abdul Rehman.
>>>
>> I am not sure its a freeware or not but
On 13/02/2009 18:24, Bob Pawley wrote:
> I am not sure what you mean by this IP format 192.168.1.0/24.
Hi Bob,
That's what's called a CIDR address - have a look at
http://en.wikipedia.org/wiki/CIDR - and in this instance it means that
any host in the address range 192.168.1.1 - 192.168.1.254 wit
Hi John
You are right about the router.
I now have PG Admin displaying the server. However it still won't connect
even with the firewall off.
Actually, the message says the the connection was 'actively' rejected.
I am not sure what you mean by this IP format 192.168.1.0/24.
I notice that th
On Fri, Feb 13, 2009 at 11:13:36AM -0700, Scott Ribe wrote:
> > I was hoping to run many thousands of small (i.e. 100ms or less) queries
> > and if it takes a couple of seconds to restart the database I'm not
> > going to be able to do this.
>
> Are you forgetting the OS's file system cache? That
> Isn't there anything faster than this?
>
> I was hoping to run many thousands of small (i.e. 100ms or less) queries
> and if it takes a couple of seconds to restart the database I'm not
> going to be able to do this.
Are you forgetting the OS's file system cache? That will also have a huge
effe
[ Sorry Brad, I didn't mean to delete your response! lets try again. ]
On Fri, Feb 13, 2009 at 12:52:21PM -0500, Brad Nicholson wrote:
> On Fri, 2009-02-13 at 17:49 +, Sam Mason wrote:
> > I was doing some performance checks and wondered what the best way to
> > clear out the shared buffers is
On Fri, Feb 13, 2009 at 12:52:21PM -0500, Brad Nicholson wrote:
> On Fri, 2009-02-13 at 17:49 +, Sam Mason wrote:
> > I was doing some performance checks and wondered what the best way to
> > clear out the shared buffers is? With the recent improvements in buffer
> > management it appears a si
On Fri, 2009-02-13 at 17:49 +, Sam Mason wrote:
> Hi,
>
> I was doing some performance checks and wondered what the best way to
> clear out the shared buffers is? With the recent improvements in buffer
> management it appears a simple SELECT * FROM large_table; doesn't help
> here!
>
> I was
On Fri, 13 Feb 2009 16:59:52 -
"Greg Sabino Mullane" wrote:
> > After googling and downloading some of the most popular open
> > source ecommerce software I didn't find any that works out of
> > the box with PostgreSQL.
>
> Have you looked at Interchange?
>
> http://en.wikipedia.org/wiki/In
Hi,
I was doing some performance checks and wondered what the best way to
clear out the shared buffers is? With the recent improvements in buffer
management it appears a simple SELECT * FROM large_table; doesn't help
here!
I was hoping for a function I could call, or maybe some variable I write
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> After googling and downloading some of the most popular open source
> ecommerce software I didn't find any that works out of the box with
> PostgreSQL.
Have you looked at Interchange?
http://en.wikipedia.org/wiki/Interchange_(software)
http
On Friday 13 February 2009 2:18:32 am Kusuma Pabba wrote:
> i don't know y am i getting this problem
>
> when i try to start off postgres
> it asks me for password:
Are trying to start the Postgres program or are you trying to connect to an
already running server?
>
>
> i did not set any passwo
Hi,
I am using EnterpriseDB(8.1) here is my individual procedure code written as
like:
Create or replace Procedure sp_leaveSummary(
op_viewSummary OUT sys_refcursor,
op_errormessage OUT varchar
Abdul Rahman wrote:
Hi all,
Can any body tell me about tool for PostgreSQL load testing preferably
freeware.
Regards,
Abdul Rehman.
I am not sure its a freeware or not but looks promising
http://bristlecone.continuent.org/HomePage
--Ashish
--
Sent via pgsql-general mailing list (pgsql-g
Ashish Karalkar wrote:
Abdul Rahman wrote:
Hi all,
Can any body tell me about tool for PostgreSQL load testing
preferably freeware.
Regards,
Abdul Rehman.
I am not sure its a freeware or not but looks promising
http://bristlecone.continuent.org/HomePage
--Ashish
And ofcourse the PGben
Hi all,
Can any body tell me about tool for PostgreSQL load testing preferably
freeware.
Regards,
Abdul Rehman.
Kindly let me know two things to answer you. First, Are you trying to start
postgres service or psql prompt? second, what OS is in your use.
i don't know y am i getting this problem
when i try to start off postgres
it asks me for password:
i did not set any password as such
except that when the first day i used template, i ahve used the below
two statements
ALTER USER postgres with encrypted password 'your_password';
ALTER USER
On Fri, 13 Feb 2009 09:55:04 +0300 (MSK)
Oleg Bartunov wrote:
> contrib/btree_gin, which is under review for 8.4, will allow to
> create composite index like (ts_config, tsvector), so queries
> which specified ts_config (language) will uses this index.
Grass Root protectionism of good programmer
In response to Eus :
> Hi Ho!
>
> Is there a way to check whether or not a subquery returns an empty result set?
You can use EXISTS for that:
-- empty result
test=*# select * from (select 1 where 1=2) foo;
?column?
--
(0 rows)
-- check if a result exists
test=*# select exists(select *
Eus wrote:
> Hi Ho!
>
> Is there a way to check whether or not a subquery returns an empty result set?
"EXISTS"
SELECT blah FROM blah WHERE EXISTS (SELECT 1 FROM tablename WHERE ...);
> postgre check "empty result set"
It's not "postgre". It's PostgreSQL, or "postgres". This matters when
you'r
Hi Ho!
Is there a way to check whether or not a subquery returns an empty result set?
Googling with the following keywords does not help:
postgre check "empty result set"
sql check empty result
Thank you.
Best regards,
Eus (FSF member #4445)
In this digital era, where computing technology is
31 matches
Mail list logo
