On 01/07/10 07:49, Howard Rogers wrote:
> Thank you David.
>
> I must say, I find mailing lists extremely confusing, and wish there was
> a "proper" forum type place to go to!
If you prefer web forums, you might want to drop by the EnterpriseDB web
forums. In your case that'll be particularly hel
"Magnus Hagander" writes:
More likely, it's not finding the right one. Probably it's picking up
some completely different version of it because it's earlier in the
search path.
Here is the start of my PATH environment variable.
c:\msys\1.0\bin;C:\mingw\bin;C:\mingw\lib;
If it is findi
Magnus Hagander writes:
> On Thu, Jul 1, 2010 at 00:30, Bidski wrote:
>> configure: error: zlib version is too old
>> Use --without-zlib to disable zlib support.
>>
>> How can the latest version be too old??
> More likely, it's not finding the right one. Probably it's picking up
> some
On Thu, Jul 1, 2010 at 00:30, Bidski wrote:
> Hi all,
>
> I recently had some problems with a pre-built version of PostgreSQL and so I
> decided to try and build my own copy from source, but have run into even
> more problems.
>
> I downloaded a copy of the source, unpacked it into a directory and
On Thu, Jul 1, 2010 at 1:02 PM, Tom Lane wrote:
> Fujii Masao writes:
>> Hmm... you'd like to get the system identifier from the postgres
>> server via SQL rather than starting replication? If so, you can do
>> that by adding replication entry into pg_hba.conf and performing the
>> following
>
>>
Fujii Masao writes:
> Hmm... you'd like to get the system identifier from the postgres
> server via SQL rather than starting replication? If so, you can do
> that by adding replication entry into pg_hba.conf and performing the
> following
> $ psql replication=1 -c "IDENTIFY_SYSTEM"
Cute, but
On Thu, Jul 1, 2010 at 11:35 AM, Zoid wrote:
> Hmm. I tried the replication=1 switch but I was prompted with the below but
> I noticed the "local" requirement assumes a UNIX socket which i'm not using.
> And both databases are actually on the same box (just different ports).
>
> psql: FATAL:
Hmm. I tried the replication=1 switch but I was prompted with the below
but I noticed the "local" requirement assumes a UNIX socket which i'm
not using. And both databases are actually on the same box (just
different ports).
psql: FATAL: no pg_hba.conf entry for replication connection fr
Thank you David.
I must say, I find mailing lists extremely confusing, and wish there was a
"proper" forum type place to go to! My apologies for mailing to the wrong
place: I am now not sure whether to keep it here or not! I only wrote here
after noting that previous questions about DBI-Link (some
Szymon Guz wrote:
> I've got a file with many SQL queries, also some function definitions and so
> on. I'd like to load it to database, but using some library like
> JDBC/ODBC/DBI, not using the obvious psql. Do you know how I could load
> those many queries? Usually there could be loaded only on
On Wed, Jun 30, 2010 at 8:05 PM, Tom Lane wrote:
> rick.ca...@colorado.edu writes:
>> SELECT S.subjectid,STY.studyabrv,labID,boxnumber,wellrow,wellcolumn
>> FROM DNASample D, IBG_Studies STY, Subjects S, ibg_projects P
>> LEFT OUTER JOIN ibg_ps_join IPJ USING (dnasampleid)
>> WHERE
>> D.su
Hi Adrian
I had missed that bit. That makes sense now.
Cheers
Phil Jackson
On 6/30/2010 5:04 PM, Adrian Klaver wrote:
On Thursday 01 July 2010 11:11:29 am Phil Jackson wrote:
Hi Adrian
The link says that;
"Identifier and key word names are case insensitive."
But I have renamed the sour
Adrian Klaver writes:
> On Thursday 01 July 2010 11:11:29 am Phil Jackson wrote:
>> The link says that;
>> "Identifier and key word names are case insensitive."
>>
>> But I have renamed the source table in lowercase and this gets me one
>> step further.
> You need to go to bottom of that section
rick.ca...@colorado.edu writes:
> SELECT S.subjectid,STY.studyabrv,labID,boxnumber,wellrow,wellcolumn
> FROM DNASample D, IBG_Studies STY, Subjects S, ibg_projects P
> LEFT OUTER JOIN ibg_ps_join IPJ USING (dnasampleid)
> WHERE
> D.subjectidkey=S.id
> AND STY.studyindex=D.studyindex
>
On Thursday 01 July 2010 11:11:29 am Phil Jackson wrote:
> Hi Adrian
>
> The link says that;
>
> "Identifier and key word names are case insensitive."
>
> But I have renamed the source table in lowercase and this gets me one
> step further.
>
> I'll carry on and see what happens next.
>
> Cheers
>
On Jun 30, 2010, at 18:45 , Eliot, Christopher wrote:
> I need to read a timestamp from the database and turn that into an integer
> describing how many months ago the event happened, rounding downward. The
> events are guaranteed to be in the past.
=# select timestamp '2010-06-26 00:00:00' -
On Wed, Jun 30, 2010 at 7:01 PM, wrote:
> I have a JOIN error that is rather opaque...at least to me.
>
> I've using other JOIN queries on this project, which seem very similar to
> this one, which looks like:
>
> SELECT S.subjectid,STY.studyabrv,labID,boxnumber,wellrow,wellcolumn
> FROM DNASampl
jsmg...@numericable.fr (John Gage) writes:
> Is there an equivalent of svn/git etc. for the data in a database's
> tables?
>
> Can I set something up so that I can see what was in the table two
> days/months etc. ago?
>
> I realize that in the case of rapidly changing hundred million row
> tables t
I have a JOIN error that is rather opaque...at least to me.
I've using other JOIN queries on this project, which seem very similar to
this one, which looks like:
SELECT S.subjectid,STY.studyabrv,labID,boxnumber,wellrow,wellcolumn
FROM DNASample D, IBG_Studies STY, Subjects S, ibg_projects P
LEF
Hi Adrian
The link says that;
"Identifier and key word names are case insensitive."
But I have renamed the source table in lowercase and this gets me one
step further.
I'll carry on and see what happens next.
Cheers
Phil Jackson
On 6/30/2010 3:18 PM, Adrian Klaver wrote:
On 07/01/2010
I need to read a timestamp from the database and turn that into an integer
describing how many months ago the event happened, rounding downward. The
events are guaranteed to be in the past.
To start with, I tried subtracting a sample timestamp as would be found in the
DB from my benchmark date
Hi all,
I recently had some problems with a pre-built version of PostgreSQL and so I
decided to try and build my own copy from source, but have run into even more
problems.
I downloaded a copy of the source, unpacked it into a directory and had a quick
look at the possible configure options (.
Hi,
I've got a file with many SQL queries, also some function definitions and so
on. I'd like to load it to database, but using some library like
JDBC/ODBC/DBI, not using the obvious psql. Do you know how I could load
those many queries? Usually there could be loaded only one query, I saw that
psql
On 07/01/2010 09:46 AM, Phil Jackson wrote:
We've set up a Sql database for the first time and get an error reported
back to our application from the ODBC session object when we try to open
one of the tables.
[42p01][7]ERROR Relation "SqlAnal" does not exist; table not found!
Here is my databas
We've set up a Sql database for the first time and get an error reported
back to our application from the ODBC session object when we try to open
one of the tables.
[42p01][7]ERROR Relation "SqlAnal" does not exist; table not found!
Here is my database outline in the Admin tool
Servers(1)
Co
Zoid writes:
> Actually, I'm using postgresql beta2 and my replication process is
> connectiong to my primary (or backend) at 5432 via the connect_info line
> of the recovery.conf file.
> I had already saw that the error is identical if I merely connect
> directly to the primary and issue the
On 06/30/2010 02:09 PM, mirthcyy wrote:
Hi there,
I'm a newbie to postgresql and I have some problems working with its
permissions.
For security purpose, I want that my application service account only
has execution permissions to the functions I created. so what I did
is:
Create a group test
Hi there,
I'm a newbie to postgresql and I have some problems working with its
permissions.
For security purpose, I want that my application service account only
has execution permissions to the functions I created. so what I did
is:
Create a group testgroup (not super user)
Create a user testus
Tom,
Actually, I'm using postgresql beta2 and my replication process is
connectiong to my primary (or backend) at 5432 via the connect_info line
of the recovery.conf file.
I had already saw that the error is identical if I merely connect
directly to the primary and issue the command "IDENTIT
Zoid writes:
> Can anyone see why I keep getting the below "IDENTIFY_SYSTEM" error in
> my logs when I start my replication database process?
Are you sure the primary is 9.0? It sure looks like you're getting a
plain backend connection instead of a walsender, which is what I'd
expect to happen
On Jun 29, 3:28 pm, MD wrote:
> I found out the libpq.lib come with Postgres installer (8.4.4) is not
> thread-safe. Where can I find a thread-safe build?
Anyone knows?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgre
On Wed, Jun 30, 2010 at 10:10:02AM +1000, Howard Rogers wrote:
> I am stumped, despite working on this for a week! I am trying to create a
> 64-bit postgresql 8.4 database server which can retrieve data from various
> 64-bit Oracle 10gR2 and 11gR2 databases.
Try downloading the latest version of D
On Tue, Jun 29, 2010 at 8:28 PM, MD wrote:
> I found out the libpq.lib come with Postgres installer (8.4.4) is not
> thread-safe. Where can I find a thread-safe build?
It's always thread-safe on Windows.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company
I found out the libpq.lib come with Postgres installer (8.4.4) is not
thread-safe. Where can I find a thread-safe build?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Is this the most efficient way to write this query? Id like to get a
list of users that have the categories 1, 2, and 3?
SELECT user_id FROM user_categories WHERE category_id IN (1,2,3) GROUP
BY user_id HAVING COUNT(*) = 3
users_categories (user_id, category_id)
1 | 1
1 | 2
1 | 3
2 | 1
2 | 2
3 |
Can anyone see why I keep getting the below "IDENTIFY_SYSTEM" error in
my logs when I start my replication database process?
I use "postgres primary" as my prefix in the syslog and "postgres
replication" as the replication one so their outputs are distinguishable.
Jun 30 14:10:25 postgres prim
2010/6/30 Thom Brown
> On 30 June 2010 19:43, Joshua D. Drake wrote:
> > On Wed, 2010-06-30 at 20:42 +0200, Szymon Guz wrote:
> >> Hi,
> >> in a PHP application working on Postgres normally the new connection
> >> to the database is made per request.
> >>
> >>
> >> This can potentially cause too
On 30 June 2010 19:43, Joshua D. Drake wrote:
> On Wed, 2010-06-30 at 20:42 +0200, Szymon Guz wrote:
>> Hi,
>> in a PHP application working on Postgres normally the new connection
>> to the database is made per request.
>>
>>
>> This can potentially cause too big overhead, so I've got some
>> ques
Can anyone see why I keep getting the below "IDENTIFY_SYSTEM" error in
my logs when I start my replication database?
I use "postgres primary" as my prefix in the syslog and "postgres
replication" as the replication one.
Jun 30 14:10:25 postgres primary[19617]: [2-1] LOG: connection
received:
On Wed, 2010-06-30 at 20:42 +0200, Szymon Guz wrote:
> Hi,
> in a PHP application working on Postgres normally the new connection
> to the database is made per request.
>
>
> This can potentially cause too big overhead, so I've got some
> questions:
>
>
> - is the overhead really noticeable?
Hi,
in a PHP application working on Postgres normally the new connection to the
database is made per request.
This can potentially cause too big overhead, so I've got some questions:
- is the overhead really noticeable?
- could this be solved using persistent connections, or the persistent
connec
On Wed, Jun 30, 2010 at 10:20 AM, sam mulube wrote:
> Inserting directly into the specific partition is interesting, but if
> you're going to go down that route then aren't you starting to
> implement the partitioning yourself in application code. In that case
> what benefit does keeping the Postg
On Wed, Jun 30, 2010 at 2:16 PM, Geoffrey wrote:
> I thought you could use 8.3.* tools against any 8.3.* database, is this not
> correct? I'm getting the following errors:
>
> pg_dumpall -g -p 5436 -h matrix
>
> server version: 8.3.7; pg_dumpall version: 8.3.6
> aborting because of version mismat
I thought you could use 8.3.* tools against any 8.3.* database, is this
not correct? I'm getting the following errors:
pg_dumpall -g -p 5436 -h matrix
server version: 8.3.7; pg_dumpall version: 8.3.6
aborting because of version mismatch (Use the -i option to proceed anyway.)
Would using the
Kelly Burkhart writes:
> RE: stripped symbols, I assume you mean configuring with
> --enable-debug specified, I see from my config.log that I did not
> specify that flag.
Ah, if you built it yourself, that explains why your sysadmins'
installation of symbol packages didn't help. If you're buildi
Silly ideas, but is dropdb confusing the "postgres" user on the host and a
database named "postgres"? (does the 1st database the command was run on
still exist?) Does it do it right if the -U and -W switches are used?
Steve
On 29 June 2010 22:38, Geoffrey wrote:
> Tom Lane wrote:
>
>> Adria
On Wed, Jun 30, 2010 at 05:54:51PM +0200, Anders Steinlein wrote:
> No one with any response on this?
Fun problem, how about:
SELECT x.email, x.segmentid
FROM (
SELECT c.email, t.segmentid, t.tagname, t.tagtype
FROM contacts c, segments_tags t) x
LEFT JOIN contacts_tags t USIN
On Wed, Jun 30, 2010 at 11:07 AM, Tom Lane wrote:
> Best guess from here is that you managed to run into some sort of
> cache-reload bug; those are very sensitive to concurrent operations
> since you only see them when a shared cache inval event happens at
> just the wrong time. I would recommend
Anders Steinlein wrote:
> No one with any response on this?
> [...]
Insert a "LEFT JOIN" in the first subquery?
Tim
(too lazy to test :-))
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gene
Hi Vick,
Currently we aren't deleting anything due to business requirements
though at some point we will have to start deleting out some data. I
suspect when we do it won't be as simple as just dropping the oldest
data; some customers will have data that we want to keep permanently,
while others w
Kelly Burkhart writes:
> I had our system people install the debug symbols and I get the same
> stack trace. I believe the symbols are indeed installed, yesterday
> when I started gdb I saw a bunch of lines like this:
> Missing separate debuginfo for /usr/lib64/libssl.so.0.9.8
> Try: zypper inst
No one with any response on this?
-- a.
Anders Steinlein wrote:
What's the recommended way of storing "tags" in a database, and then
filtering based on the existence, or *non*-existence, of those tags on
some entities?
Our application stores contacts, where each contact may have any number
of
On Tue, Jun 29, 2010 at 9:34 AM, Tom Lane wrote:
> Kelly Burkhart writes:
>> The crash left a core file, does the stack trace indicate anything crucial?
>
>> (gdb) where
>> #0 0x0068d884 in SearchCatCacheList ()
>> #1 0x0001 in ?? ()
>> #2 0x00bbcbe0 in ?? ()
>> #3
On Wed, Jun 30, 2010 at 9:51 AM, Adrian Klaver wrote:
> On Wednesday 30 June 2010 6:41:18 am Andrea Lombardoni wrote:
>> > You need to use EXECUTE for the INSERT statement as well per error:
>> >
>> > CONTEXT: SQL statement "INSERT INTO idmap (oldid, type, newid) VALUES(1,
>> > 1, 1)" PL/pgSQL f
Sim Zacks writes:
>> I haven't consumed enough caffeine today to recall the details, but
>> I think you could have ended up with default expressions like the above
>> if the database had been dumped and reloaded from 8.0 or earlier.
>> nextval(regclass) was introduced in 8.1 precisely to solve thi
John Gage wrote:
> Is there an equivalent of svn/git etc. for the data in a
> database's tables?
> Can I set something up so that I can see what was in the
> table two days/months etc. ago?
> I realize that in the case of rapidly changing hundred
> million row tables this presents an impossible
In response to John Gage :
> Is there an equivalent of svn/git etc. for the data in a database's
> tables?
>
> Can I set something up so that I can see what was in the table two
> days/months etc. ago?
You can use tablelog:
15:53 < akretschmer> ??tablelog
15:53 < pg_docbot_adz> For informati
On Wednesday 30 June 2010 6:41:18 am Andrea Lombardoni wrote:
> > You need to use EXECUTE for the INSERT statement as well per error:
> >
> > CONTEXT: SQL statement "INSERT INTO idmap (oldid, type, newid) VALUES(1,
> > 1, 1)" PL/pgSQL function "test" line 16 at SQL statement
>
> Thanks, this work
Is there an equivalent of svn/git etc. for the data in a database's
tables?
Can I set something up so that I can see what was in the table two
days/months etc. ago?
I realize that in the case of rapidly changing hundred million row
tables this presents an impossible problem.
The best kl
Hello
in PostgreSQL 8.2 and older you have to respect one rule - newer to
drop temp table. You don't must do it. After session end, all temp
tables are removed.
you can execute some initialisation part like
CREATE OR REPLACE FUNCTION check_tab()
RETURNS void AS $$
BEGIN
BEGIN
TRUNCATE TABL
On Wed, Jun 30, 2010 at 2:41 PM, Andrea Lombardoni wrote:
>> You need to use EXECUTE for the INSERT statement as well per error:
>>
>> CONTEXT: SQL statement "INSERT INTO idmap (oldid, type, newid) VALUES(1,
>> 1, 1)" PL/pgSQL function "test" line 16 at SQL statement
>
> Thanks, this works and s
> You need to use EXECUTE for the INSERT statement as well per error:
>
> CONTEXT: SQL statement "INSERT INTO idmap (oldid, type, newid) VALUES(1,
> 1, 1)" PL/pgSQL function "test" line 16 at SQL statement
Thanks, this works and solves my problem.
Still, I find this behaviour to be rather quirk
On Wednesday 30 June 2010 6:21:44 am Andrea Lombardoni wrote:
> >> Am I doing something wrong or is this a bug?
> >
> > The plan is cached, to avoid this problem, use dynamic SQL. In your
> > case:
> >
> > EXECUTE 'CREATE TEMPORARY TABLE idmap ...'
>
> Nice idea, but the problem persists, see log b
>> Am I doing something wrong or is this a bug?
>
> The plan is cached, to avoid this problem, use dynamic SQL. In your
> case:
>
> EXECUTE 'CREATE TEMPORARY TABLE idmap ...'
Nice idea, but the problem persists, see log below.
I am beginning to mentally place this into the 'bug' area :)
CREATE
In response to Andrea Lombardoni :
> Hello.
>
>
> The strange part is that the second time, the OID of the idmap is the
> same as the one in the first invocation!
>
> Am I doing something wrong or is this a bug?
The plan is cached, to avoid this problem, use dynamic SQL. In your
case:
EXECUTE
Hello.
I am trying to use temporary tables inside a stored procedure, but I
get a rather puzzling error.
I am currently using PostgreSQL 8.2.7 and this is my stored procedure:
CREATE OR REPLACE FUNCTION test() RETURNS bigint AS $$
DECLARE
v_oid bigint;
BEGIN
-- create tmp-table used to ma
In my current configuration all queries are sent to the master, i want write
queries to be sent to master, and reads to slave. I have 1 pgpool setuped with
2 postgres servers in master/slave replication with slony1
Can this be done with 1 pgpool or i must use 2 pgpools for writes and reads.
her
On 06/30/10 12:37 AM, RP Khare wrote:
Is there any way to schedule PGSQL databases backups? I want to take
hourly dumps of my production database.
if those are your backup requirements, you should take a look at PITR,
Point In Time Recovery, where you take just an occasional full database
d
Rohit,
yes, there is.
- Click on the Start-Icon (XP) or Windows-Icon(W7) to bring up your
ProgrammsMenu
- click on "Control Panel"
- click on administration icon
- DOUBLE-CLICK on planned tasks
- click on new planned tasks, in the add planned task wizzard you can add
the commands for running pg_
On 30/06/10 8:37 AM, RP Khare wrote:
Is there any way to schedule PGSQL databases backups? I want to take
hourly dumps of my production database.
.
Rohit Prakash
Build a bright career through MSN Education Si
In response to RP Khare :
> Is there any way to schedule PGSQL databases backups? I want to take hourly
> dumps of my production database.
You can use the OS-scheduler, for instance, CRON for UNIX-like systems.
Regards, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/
use cron?
On 6/30/2010 10:37 AM, RP Khare wrote:
> Is there any way to schedule PGSQL databases backups? I want to take
> hourly dumps of my production database.
>
> .
> Rohit Prakash
>
>
> Build a bright career
72 matches
Mail list logo
