Heyho!
On Sunday 27 June 2010 08.22:09 RP Khare wrote:
I downloaded PostgreSQL plus advanced server from EnterpriseDB website.
Should I go with the original community PGSQL edition or EnterpriseDB
edition?
If you work on a Linux/BSD/... OS distribution with a sane package manager,
I always
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 through
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:
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
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
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
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.
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
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
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 OR
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 below.
I am
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 quirky.
On Wed, Jun 30, 2010 at 2:41 PM, Andrea Lombardoni and...@lombardoni.ch 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
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
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
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 works and solves
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 information about
John Gage jsmg...@numericable.fr 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
Sim Zacks s...@compulab.co.il 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
On Wed, Jun 30, 2010 at 9:51 AM, Adrian Klaver adrian.kla...@gmail.com 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)
On Tue, Jun 29, 2010 at 9:34 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Kelly Burkhart kelly.burkh...@gmail.com writes:
The crash left a core file, does the stack trace indicate anything crucial?
(gdb) where
#0 0x0068d884 in SearchCatCacheList ()
#1 0x0001 in ?? ()
#2
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
Kelly Burkhart kelly.burkh...@gmail.com 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
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
Anders Steinlein and...@steinlein.no 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:
On Wed, Jun 30, 2010 at 11:07 AM, Tom Lane t...@sss.pgh.pa.us 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
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
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 li...@serioustechnology.com wrote:
Tom
Kelly Burkhart kelly.burkh...@gmail.com 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
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
On Wed, Jun 30, 2010 at 2:16 PM, Geoffrey li...@serioustechnology.com 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
On Wed, Jun 30, 2010 at 10:20 AM, sam mulube sam.mul...@gmail.com 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
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
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?
It can
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 30 June 2010 19:43, Joshua D. Drake j...@commandprompt.com 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
2010/6/30 Thom Brown thombr...@gmail.com
On 30 June 2010 19:43, Joshua D. Drake j...@commandprompt.com 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
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
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 |
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
On Tue, Jun 29, 2010 at 8:28 PM, MD mingdeng2...@gmail.com 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
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
On Jun 29, 3:28 pm, MD mingdeng2...@gmail.com 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
Zoid z...@the-lounge.us 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
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
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
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
Zoid z...@the-lounge.us 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
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)
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 database
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
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
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
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 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
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 this
On Wed, Jun 30, 2010 at 7:01 PM, rick.ca...@colorado.edu 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
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 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
Phil Jackson
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
Adrian Klaver adrian.kla...@gmail.com 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
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
On Wed, Jun 30, 2010 at 8:05 PM, Tom Lane t...@sss.pgh.pa.us 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
Szymon Guz mabew...@gmail.com 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
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
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
On Thu, Jul 1, 2010 at 11:35 AM, Zoid z...@the-lounge.us 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).
Fujii Masao masao.fu...@gmail.com 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
On Thu, Jul 1, 2010 at 1:02 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Fujii Masao masao.fu...@gmail.com 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
On Thu, Jul 1, 2010 at 00:30, Bidski bid...@bigpond.net.au 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
Magnus Hagander mag...@hagander.net writes:
On Thu, Jul 1, 2010 at 00:30, Bidski bid...@bigpond.net.au 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.
Magnus Hagander mag...@hagander.net 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.
72 matches
Mail list logo