I wrote:
> What I notice about your program is that you connect to the database
> in the main thread, then start a new thread and use the connection in that
> new thread.
>
> I don't know, but I'd expect that since ecpg keeps a thread-specific
> sqlca, this could cause problems. Indeed I find wit
Hi Laurenz,
Thank you for your effort. I appreciate it very much.
I have been trying to figure this thing out myself too, breakpointing and
single stepping my way through some of the ecpg code, but without much
clarification. (More that I learned new things about pthread). I have be
Hi all,
I have this problem today: one thread of our application hung, and
we found the thread waiting for the result of poll() function. poll()
was called by pgSocketCheck(). So is it a bug of pg? I found the bug
report from
website(http://archives.postgresql.org/pgsql-bugs/2008-02/msg00260.
personally they way I do it, is by creating temporary table, in
transaction - and use it in function. Obviously that's very indirect,
and not obvious if you see function's declaration. But works fine.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your su
Hi
When I write the following commands at the prompt,
>createuser -S -d -R user1
> createdb sample
I am asked to enter a password. I have not set any password anywhere. Which
password is it asking for?
Please help.
I have built from source on Windows XP.
Thanks is advance,
Regards
Swati
Ms swati chande schrieb:
Hi
When I write the following commands at the prompt,
>createuser -S -d -R user1
> createdb sample
I am asked to enter a password. I have not set any password anywhere.
Which password is it asking for?
Please help.
I have built from source on Windows XP.
Thanks
Andreas Wenk schrieb:
Ms swati chande schrieb:
Hi
When I write the following commands at the prompt,
>createuser -S -d -R user1
> createdb sample
I am asked to enter a password. I have not set any password anywhere.
Which password is it asking for?
Please help.
I have built from source
Serge Fonville schrieb:
*argh* - more detailed to avoid confusion. The auth method 'password' in
pg_hba.conf means, that you will be asked for a password for the user you
try to create a db with. If no user is given (with createdb -U [username]),
this user is postgres ...
Wasn't it that it uses
l...@crysberg.dk wrote:
> I have been trying to figure this thing out myself too,
> breakpointing and single stepping my way through some of the
> ecpg code, but without much clarification. (More that I
> learned new things about pthread). I have been trying to
> figure out whether this is
On Jul 8, 2009, at 2:50 AM, Yaroslav Tykhiy wrote:
Hi All,
I have a mid-size database (~300G) used as an email store and
running on a FreeBSD + ZFS combo. Its PG_DATA is on ZFS whilst xlog
goes to a different FFS disk. ZFS prefetch was enabled by default
and disk time on PG_DATA was nea
I could manage to identify/describe interval fields by testing the different
values
returned by PQfmod().
Could someone confirm that PQfmod() returns will not change in future versions?
I have seen in the docs that there is a deprecated compile-time option that
defines
how time, timestamp and
On Wed, Jul 8, 2009 at 3:22 PM, Andreas Wenk wrote:
> Andreas Wenk schrieb:
>
>> Ms swati chande schrieb:
>>
>>> Hi
>>> When I write the following commands at the prompt,
>>>
>>> >createuser -S -d -R user1
>>> > createdb sample
>>>
>>> I am asked to enter a password. I have not set any passwor
Ms swati chande schrieb:
--- On *Wed, 7/8/09, Andreas Wenk //* wrote:
From: Andreas Wenk
Subject: Re: [GENERAL] Password?
To: "Ms swati chande" , "PG-General Mailing List"
Date: Wednesday, July 8, 2009, 3:47 PM
Ms swati chande schrieb:
> Thanks Andy,
> I am
Ms swati chande schrieb:
Thanks Andy,
I am working on Windows XP. Have built from source using Visual Studio 2005.
I have made a change in pg_hba.conf to include the ipconfig of my system.
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
*hostall all
>ah ok ..
>Actually it should work if you set listen_addresses to '*' in postgresql.conf.
>Did you >change anything else in postgresql.conf or pg_hba.conf?
>I am not too experienced with Windows so maybe someone with more knowledge is
>able >to find the trick (I installed 8.4 once with the one
On Wed, Jul 8, 2009 at 4:12 PM, Andreas Wenk wrote:
> Ms swati chande schrieb:
>
>> --- On *Wed, 7/8/09, Andreas Wenk //*
>> wrote:
>>
>>
>>From: Andreas Wenk
>>Subject: Re: [GENERAL] Password?
>>To: "Ms swati chande" , "PG-General Mailing List"
>>
>>Date: Wednesday, July 8,
Hello,
Le 8/07/09 0:52, John Cheng a écrit :
> I don't mean to be pesky. I was just wondering if there is anything
> else I should try?
>
> Should I simply rewrite all queries, change the form
>
> WHERE textarr && '{foo, bar}'::text[]
>
> To
>
> WHERE (textarr && '{foo}'::text[]
> OR
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
My server started spitting this out every second!
LOG: could not accept SSL connection: sslv3 alert illegal parameter
"PostgreSQL 8.3.7 on x86_64-redhat-linux-gnu, compiled by GCC gcc
(GCC) 4.1.2 20070925 (Red Hat 4.1.2-33)"
Server key in
Hi!
select * from any where is_deleted = Null
select * from any where is_deleted in (Null)
They are show 0 record.
select * from any where is_deleted is Null
It is show all records.
Some of other DBs are uses Null as Null in >=< comparisons. Is PG not? What
are the rules?
Thanks: dd
Yes,
Its the currently logged on user.
--- On Wed, 7/8/09, Andreas Wenk wrote:
From: Andreas Wenk
Subject: [Re: [GENERAL] Password?]
To: "PG-General Mailing List"
Date: Wednesday, July 8, 2009, 3:54 PM
Serge Fonville schrieb:
>> *argh* - more detailed to avoid confusion. The auth method 'p
On Jul 8, 2009, at 1:30 PM, Durumdara wrote:
Hi!
select * from any where is_deleted = Null
select * from any where is_deleted in (Null)
They are show 0 record.
Correct, that's normal in SQL.
NULL means 'unknown', so you can't say whether is_deleted is true or
false when it's NULL. The resu
Konstantin Izmailov writes:
> However, it is not clear how to determine max rows count that the
> cursor can return. The count is necessary for two purposes: render
> scrollbar and support jumping to the last rows in the grid.
You can MOVE LAST, it'll tell you how many rows are in there, then MO
Durumdara writes:
> Some of other DBs are uses Null as Null in >=< comparisons. Is PG not?
> What are the rules?
PostgreSQL implements SQL, which has a 3-valued logic. There's True,
there's False, and there's NULL. NULL means that we know nothing about
what's in there.
Would you really want to
> Dennis Gearon
> Sent: Tuesday, July 07, 2009 9:46 PM
>
> When locking is involved, does a transaction wait for access to a row
or
> table, or does it just fail back to the calling code? Would it be up
to my
> PHP code to keep hammeing for access to a row/table, or could a user
> defined function
On 2009-07-08, Andreas Wenk wrote:
> Serge Fonville schrieb:
>>> *argh* - more detailed to avoid confusion. The auth method 'password' in
>>> pg_hba.conf means, that you will be asked for a password for the user you
>>> try to create a db with. If no user is given (with createdb -U [username]),
>>
Jasen Betts schrieb:
On 2009-07-08, Andreas Wenk wrote:
Serge Fonville schrieb:
*argh* - more detailed to avoid confusion. The auth method 'password' in
pg_hba.conf means, that you will be asked for a password for the user you
try to create a db with. If no user is given (with createdb -U [use
On Wed, Jul 8, 2009 at 6:03 AM, Alban
Hertroys wrote:
> This is exactly the reason the 'is null' operator exists. It's exclusively
> for checking for null values. You can't say 'is_deleted is true' for
> example.
Uh, yes you can. is false also works. and is not true and is not false.
--
Sent vi
I believe the documentation (Data Types section) is missing one INTERVAL
"field":
HOUR TO SECOND
http://www.postgresql.org/docs/8.4/static/datatype-datetime.html
The interval type has an additional option, which is to restrict the set of
stored fields by writing one of these phrases:
We are running our PostGres db on Windows 2008 Server but have several
clients who are running various other versions of Windows (XP, Vista, etc).
Is there are binary install for just the client side install so that we do
not have to install everything?
If there isn't one available how do we run
hello
2009/7/8 Michael Gould :
> We are running our PostGres db on Windows 2008 Server but have several
> clients who are running various other versions of Windows (XP, Vista, etc).
> Is there are binary install for just the client side install so that we do
> not have to install everything?
yo
Sebastien FLAESCH writes:
> I believe the documentation (Data Types section) is missing one INTERVAL
> "field":
> HOUR TO SECOND
Hmm, you're right. IIRC I copied and pasted that list straight from the
grammar, but I must have lost one line somehow. Thanks for noticing!
On Jul 8, 2009, at 6:19 AM, Andreas Wenk wrote:
Jasen Betts schrieb:
On 2009-07-08, Andreas Wenk wrote:
Serge Fonville schrieb:
*argh* - more detailed to avoid confusion. The auth method
'password' in
pg_hba.conf means, that you will be asked for a password for the
user you
try to create
On 08/07/2009 18:14, Steve Atkins wrote:
> Typically the postgres operating system user is allowed to
> connect to the database as the postgres database user without a
> password.
Is this really so? I don't think so - I think it depends on pg_hba.conf
settings, just like any other user.
Ray.
---
Since no one else seems to have sent it yet, I'll do the obligatory annual
Happy Birthday email. Happy Birthday, PostgreSQL. You're a teenager now. The
pimples will go away, in time.
- Josh / eggyknap
signature.asc
Description: Digital signature
On Jul 8, 2009, at 10:25 AM, Raymond O'Donnell wrote:
On 08/07/2009 18:14, Steve Atkins wrote:
Typically the postgres operating system user is allowed to
connect to the database as the postgres database user without a
password.
Is this really so? I don't think so - I think it depends on
pg
I'm running a steady state test where I am pushing about 600 queries
per second through a Posgres 8.3 system on an 8 CPU Linux system.
It's a mix of inserts, updates, and deletes on a few tables - the two
biggest ones probably have about 200,000 rows.
Harddrive is just a simple, run-of-the-mill de
On 08/07/2009 18:30, Steve Atkins wrote:
> On Jul 8, 2009, at 10:25 AM, Raymond O'Donnell wrote:
>> Is this really so? I don't think so - I think it depends on pg_hba.conf
>> settings, just like any other user.
>
> It does, yes. But most of the distributions I've seen tend to set it
> up that way
a quite interesting read.
http://www.codingthewheel.com/archives/stranger-than-fiction-story-online-poker-tracker-postgresql
especially as an explanation of the growing number of questions from
Windows-Users of PostgreSQL
And ... for a tag line: "PostgreSQL. Thousends bet on it."
Harald
--
GH
Steve Atkins schrieb:
On Jul 8, 2009, at 6:19 AM, Andreas Wenk wrote:
Jasen Betts schrieb:
On 2009-07-08, Andreas Wenk wrote:
Serge Fonville schrieb:
*argh* - more detailed to avoid confusion. The auth method
'password' in
pg_hba.conf means, that you will be asked for a password for the
u
Dan Armbrust writes:
> However, once the checkpoint process begins, I get a whole flood of
> queries that take between 1 and 10 seconds to complete. My throughput
> crashes to near nothing. The checkpoint takes between 45 seconds and
> a minute to complete.
You sure this is 8.3? It should spre
On Wed, Jul 8, 2009 at 12:50 PM, Tom Lane wrote:
> Dan Armbrust writes:
>> However, once the checkpoint process begins, I get a whole flood of
>> queries that take between 1 and 10 seconds to complete. My throughput
>> crashes to near nothing. The checkpoint takes between 45 seconds and
>> a min
On Wed, 8 Jul 2009 19:39:16 +0200
"Massa, Harald Armin" wrote:
> a quite interesting read.
>
> http://www.codingthewheel.com/archives/stranger-than-fiction-story-online-poker-tracker-postgresql
There are a couple of comments comment that maybe someone could
correct:
"The popularity of PostgreS
On Wed, Jul 8, 2009 at 1:23 PM, Tom Lane wrote:
> Dan Armbrust writes:
>> With checkpoint_segments set to 10, the checkpoints appear to be
>> happening due to checkpoint_timeout - which I've left at the default
>> of 5 minutes.
>
> Well, you could increase both those settings so as to put the
> ch
Hi all,
I'm trying to select an offset timestamp at a given time zone, but I
can't seem to get the syntax right.
What I am *trying* to do, which doesn't work:
SELECT
now() AT TIME ZONE 'America/Toronto',
now() + '4d' AS future AT TIME ZONE 'America/Toronto';
Which generates
I think I can understand what you both have discussed.
But I am unable to unearth my mistake.
Regards
Swati
--- On Wed, 7/8/09, Andreas Wenk wrote:
From: Andreas Wenk
Subject: Re: [GENERAL] [Re: Password?]
To: "Steve Atkins"
Cc: "pgsql-general List"
Date: Wednesday, July 8, 2009, 11:20 PM
Dan Armbrust writes:
> On Wed, Jul 8, 2009 at 1:23 PM, Tom Lane wrote:
>> Well, you could increase both those settings so as to put the
>> checkpoints further apart, and/or increase checkpoint_completion_target
>> to spread the checkpoint I/O over a larger fraction of the cycle.
> Wouldn't increa
Madison Kelly writes:
> SELECT
> now() AT TIME ZONE 'America/Toronto',
> now() + '4d' AS future AT TIME ZONE 'America/Toronto';
You've got "AS future" in the wrong place.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Hi,
I started everything again from scratch.
1. Created a new user("Swati"), with limited/ restricted rights.
Ensured that no password is set anywhere.
2. Ran initdb from the new user.
c:\postgresql\bin>initdb -D c:\postgresql\data2
It displayed the DEBUG: start transact
Try moving your "as future"
SELECT
now() AT TIME ZONE 'America/Toronto',
CAST ((SELECT now() + '4d') AS TIMESTAMP) AT TIME ZONE
'America/Toronto' as future;
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Be
Hi,
Do we have anything like "Oracle Help for Java" in Postgresql?
Thanks
Ms swati chande schrieb:
Hi,
I started everything again from scratch.
1. Created a new user("Swati"), with limited/ restricted rights.
Ensured that no password is set anywhere.
2. Ran initdb from the new user.
c:\postgresql\bin>initdb -D c:\po
Tom Lane wrote:
Madison Kelly writes:
SELECT
now() AT TIME ZONE 'America/Toronto',
now() + '4d' AS future AT TIME ZONE 'America/Toronto';
You've got "AS future" in the wrong place.
regards, tom lane
Thank you both, Chris and Tom. That was indeed my
>> Wouldn't increasing the length between checkpoints result in the
>> checkpoint process taking even longer to complete?
>
> You don't really care how long it takes. What you want is for it not to
> be chewing a bigger fraction of your I/O bandwidth than you can spare.
> Hence, you want it to tak
Ms swati chande wrote:
Made the following change in the postgresql.conf file:
listen_addresses = 'xxx.xxx.x.x' (my current ip)
and in pg_hba:
host all all 'xxx.xxx.x.x' trust
...
6.Opened another command
abdelhak benmohamed wrote:
> Hellow
> I like to track the number of committed transaction for my database
> So I use the following command
> Select pg_stat_get_db_xact_commit(16384)
>
> (16384 is the oid of my database)
>
> It gives me 35
>
> But if I execute the same command another time, i
On Wed, 8 Jul 2009, Dan Armbrust wrote:
With checkpoint_segments set to 10, the checkpoints appear to be
happening due to checkpoint_timeout - which I've left at the default
of 5 minutes.
OK, then that's as far upwards as you probably need to tweak that for your
workload, even though most sys
On Wed, 8 Jul 2009, Dan Armbrust wrote:
My takeaway is that starting the checkpoint process is really
expensive - so I don't want to start it very frequently. And the only
downside to longer intervals between checkpoints is a longer recovery
time if the system crashes?
And additional disk spa
On Wed, Jul 8, 2009 at 12:27 PM, Ivan Sergio
Borgonovo wrote:
> On Wed, 8 Jul 2009 19:39:16 +0200
> "Massa, Harald Armin" wrote:
>
>> a quite interesting read.
>>
>> http://www.codingthewheel.com/archives/stranger-than-fiction-story-online-poker-tracker-postgresql
>
> There are a couple of comment
On Wed, Jul 8, 2009 at 12:53 PM, SHARMILA JOTHIRAJAH wrote:
> Hi,
> Do we have anything like "Oracle Help for Java" in Postgresql?
Not being familiar with what "Oracle Help for Java" it might help if
you tell us what that is.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Some DB's say that an empty string is the same as null, it doesn't mean
they're right. In fact, it can be rather inconvenient if an empty string
in your data also has a meaning (namely 'known to be an empty string'
instead of 'unknown')!
This is the behavior in Oracle. And I found that out
Greg Smith writes:
On Wed, 8 Jul 2009, Dan Armbrust wrote:
>> What I observe now is that I get a short (1-2 second) period where I
>> get slow queries - I'm running about 30 queries in parallel at any
>> given time - it appears that all 30 queries get paused for a couple of
>> seconds at the momen
Tom Lane wrote:
He's only got 100MB of shared buffers, which doesn't seem like much
considering it's apparently a fairly beefy system.
a beefy system with...
Harddrive is just a simple, run-of-the-mill desktop drive.
which is going to severely limit random write throughput
--
Se
On Wed, 8 Jul 2009, Ivan Sergio Borgonovo wrote:
Someone more knowledgeable about licenses and with a better English
than mine should correct the comments.
Someone named Bogdan already commented adequately about the license stuff.
I just debunked the idea that SQLite would be usable here. Al
On Wed, 8 Jul 2009 13:22:14 -0600
Scott Marlowe wrote:
> On Wed, Jul 8, 2009 at 12:27 PM, Ivan Sergio
> Borgonovo wrote:
> > On Wed, 8 Jul 2009 19:39:16 +0200
> > "Massa, Harald Armin" wrote:
> >
> >> a quite interesting read.
> >>
> >> http://www.codingthewheel.com/archives/stranger-than-fictio
John R Pierce writes:
> a beefy system with...
>> Harddrive is just a simple, run-of-the-mill desktop drive.
> which is going to severely limit random write throughput
True, which is why he's having to flail so hard to keep the checkpoint
from saturating his I/O. However, the latest report s
On Wed, 8 Jul 2009, Tom Lane wrote:
He's only got 100MB of shared buffers, which doesn't seem like much
considering it's apparently a fairly beefy system. I definitely
don't see how one CPU spinning over the buffer headers in BufferSync
is going to create the sort of hiccup he's describing.
A
> However, the latest report says that he
> managed that, and yet there's still a one-or-two-second transient of
> some sort. I'm wondering what's causing that. If it were at the *end*
> of the checkpoint, it might be the disk again (failing to handle a bunch
> of fsyncs, perhaps). But if it rea
alot of Oracle experts answer t...@yahoogroups.com
what is your oracle question?
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
Oracle help for java is nothing at all to do with oracle the database,
I don't think.
It's just html-based online docs, with a web-based and standalone java
based browser.
So I'm not sure I understand the original posters question. Postgresql
is documented in docbook, and there are downlo
On Wednesday 8. July 2009, Scott Marlowe wrote:
>I'm not sure the comments need correction really, although the
>"alleged" bit kind of rubs me the wrong way, but you're not gonna
>convince a MySQL fanboi about anything anyway.
A MySQL fanboi will take offense of the mere fact that anybody will
a
Accidentally sent to nha only
--- On Wed, 7/8/09, John Cheng wrote:
> From: John Cheng
> Subject: Re: [GENERAL] Problem search on text arrays, using the overlaps (&&)
> operator
> To: "nha"
> Date: Wednesday, July 8, 2009, 4:24 PM
> Hi nha,
>
> I will try out your suggestion about a materia
Dan Armbrust writes:
> Almost all of the slow query log messages are logged within about 3
> seconds of the checkpoint starting message.
> LOG: checkpoint complete: wrote 9975 buffers (77.9%); 0 transaction
> log file(s) added, 0 removed, 15 recycled; write=156.576 s, sync=0.065
> s, total=156.6
I was wondering if I was going to use any of the replication
available (I'm thinking especially to pgpool but I'm also interested
in any other tool as slony, pgcluster...), should I take into
account any side effect on temp tables?
I'm currently using php and pg_connect for a web application.
I'm
On Jul 8, 2009, at 1:20 PM, Greg Smith wrote:
On Wed, 8 Jul 2009, Ivan Sergio Borgonovo wrote:
Someone more knowledgeable about licenses and with a better English
than mine should correct the comments.
Someone named Bogdan already commented adequately about the license
stuff. I just debun
On Wednesday 08 July 2009 11:48:08 am Ms swati chande wrote:
> Hi,
>
> I started everything again from scratch.
> 1. Created a new user("Swati"), with limited/ restricted rights.
> Ensured that no password is set anywhere.
How limited? Can this user do administrative tasks, i.e create databa
On 08/07/2009, at 8:39 PM, Alban Hertroys wrote:
On Jul 8, 2009, at 2:50 AM, Yaroslav Tykhiy wrote:
Hi All,
I have a mid-size database (~300G) used as an email store and
running on a FreeBSD + ZFS combo. Its PG_DATA is on ZFS whilst
xlog goes to a different FFS disk. ZFS prefetch was en
On Wed, 8 Jul 2009, Ivan Sergio Borgonovo wrote:
You can actually build up closed source software with MySQL as a
server, it depends on how you do it.
I seriously doubt that: http://www.mysql.com/about/legal/licensing/oem/
The terms under which you can treat MySQL as a more open piece of sof
Hello,
I'm thinking of making a program in C++ (API)
that will connect, read, and write to a PostgreSQL database. I honestly
have no idea where to start and how to implement it in C++ using Dev C++ IDE.
Any help would be greatly appreciated.
Thanks.
Sincerely,
Rhey
New Email addresses av
ramon rhey serrano wrote:
Hello,
I'm thinking of making a program in C++ (API) that will connect, read,
and write to a PostgreSQL database. I honestly have no idea where to
start and how to implement it in C++ using Dev C++ IDE.
Any help would be greatly appreciated.
C++ easily calls C liba
On Wed, Jul 8, 2009 at 10:05 PM, Greg Smith wrote:
> On Wed, 8 Jul 2009, Ivan Sergio Borgonovo wrote:
>
>> You can actually build up closed source software with MySQL as a
>> server, it depends on how you do it.
>
> I seriously doubt that: http://www.mysql.com/about/legal/licensing/oem/
>
> The te
On Wed, Jul 8, 2009 at 7:53 PM, Yaroslav Tykhiy wrote:
> Are you a local FreeBSD expert? ;-) Jokes apart, I don't think this topic
> has to do with FreeBSD as such; it is mostly about making the advanced
> technologies of Postgresql and ZFS go well together. Even ZFS developers
> admit that in d
On Wed, 8 Jul 2009, Yaroslav Tykhiy wrote:
My conclusion is that although ZFS prefetch is supposed to be adaptive and
handle random access more or less OK, in reality there is plenty of room for
improvement, so to speak, and for now Postgresql performance can benefit from
its staying just disa
Pedro Doria Meunier wrote:
> My server started spitting this out every second!
>
> LOG: could not accept SSL connection: sslv3 alert illegal parameter
>
> "PostgreSQL 8.3.7 on x86_64-redhat-linux-gnu, compiled by GCC gcc
> (GCC) 4.1.2 20070925 (Red Hat 4.1.2-33)"
>
> Server key in place..
>
>
83 matches
Mail list logo
