thanks for this tip, but as far as I understand it libpqtypes is not
part of the original lipq libary .
This will result in the same problem as with the Qt libraries, it will
add another dependecy to my plugin, which is not allowed.
Chris
On 2010/09/30 10:59 PM, Merlin Moncure wrote:
On
Gabriele Bartolini ha scritto:
Ciao Michele,
Ciao ;)
both server (master and standby) need a common directory where
read
and write the wal files?
Not necessarily. You can use for instance scp to ship the WAL file
from the master to the standby using the network.
Thanks for the
P.s. Glad to see that also in Italy there are PostgreSQL guru ;)
Glad to see that more people are using Indian words (Guru) :)
http://en.wikipedia.org/wiki/Guru
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it
On 09/30/10 11:58 PM, GOO Creations wrote:
thanks for this tip, but as far as I understand it libpqtypes is not
part of the original lipq libary .
This will result in the same problem as with the Qt libraries, it will
add another dependecy to my plugin, which is not allowed.
take the source
On Fri, Oct 1, 2010 at 4:02 PM, Michele Petrazzo - Unipex
michele.petra...@unipex.it wrote:
- why in my tests, _whitout_ common direcotory, master and slave keep in
sync also if I shutdown slave, add (in my last tests) something about
100k record (although little ones) on the master and then
On Thu, Sep 30, 2010 at 17:45, Turner, John J jjtur...@statestreet.com wrote:
It sounds like I'm in quite a fix here. If PGXS is currently a no-go in
Windows, then that renders the temporal extension incompatible with Windows
since it uses PGXS to install...
It's not entirely a no-go. If
On Thu, Sep 30, 2010 at 7:29 PM, Willy-Bas Loos willy...@gmail.com wrote:
One thing that i think works is to create a table from your results.
That is, if your result is not one big chunk in one row that won't fit
in memory, but lots of rows.
On second thought, that helps for the scenario
2010/9/30 Vincenzo Romano vincenzo.rom...@notorand.it:
2010/9/30 Tom Lane t...@sss.pgh.pa.us:
Vincenzo Romano vincenzo.rom...@notorand.it writes:
create or replace function session_init()
returns void
language plpgsql
as $body$
declare
t text;
begin
select valu into t from session
For the benefit of the list, I've raised this issue with the people
who supply the installer technology, as I can't see any reason why our
code would get this wrong.
On Thu, Sep 30, 2010 at 9:53 PM, Dr. Peter Voigt pvo...@uos.de wrote:
Dave Page dp...@pgadmin.org writes:
A couple of questions
Fujii Masao ha scritto:
On Fri, Oct 1, 2010 at 4:02 PM, Michele Petrazzo - Unipex
michele.petra...@unipex.it wrote:
- why in my tests, _whitout_ common direcotory, master and slave
keep in sync also if I shutdown slave, add (in my last tests)
something about 100k record (although little ones)
(This is the second time I send this, as the first message apparently did not
make it)
Dr. Peter Voigt, 30.09.2010 14:42:
If there are no other users out there with comparable problems I could
give the ZIP-installer a try under:
http://www.enterprisedb.com/products/pgbindownload.do
There is a
* Dave Page wrote:
Thats very odd, but it explains why things are going wrong -
essentially, the prerequisites are being unpacked to:
C:\Users\Administrator\AppData\Local
But the installer expects to find them in:
C:\Users\Administrator\Lokale Einstellungen\
Which is a link to the first
We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5
Navigator, where one can enable logging of SQL statements and then it will
recommed indexes that should/could be created to increase speed...
Does there exist a similar tool for PostgreSQL?
Regards,
BTJ
--
On Fri, Oct 1, 2010 at 11:01 AM, Christian Ullrich ch...@chrullrich.net wrote:
* Dave Page wrote:
So, it sounds like there are two questions for me to figure out - why
is the installer not able to follow the link and find the files (which
is probably a question for BitRock), and why isn't it
2010/10/1 Bjørn T Johansen b...@havleik.no:
We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5
Navigator, where one can enable logging of SQL statements and then it will
recommed indexes that should/could be created to increase speed...
Does there exist a similar tool
Hi all,
I might not be understanding this correctly, but does Postgres, when
VACUUM ANALYZE-ing a table, perform separate scans for each index?
And if so, is this necessary? Can't it update indexes parallel? This
would be particularly useful when rebuilding all indexes on a table.
Thanks
Thom
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Le 01/10/2010 11:53, Bjørn T Johansen a écrit :
We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5
Navigator, where one can enable logging of SQL statements and then it will
recommed indexes that should/could be created to
I want to migrate a lot of single user databases onto a single server
to allow the users to access them remotely, instead of on the
workstations. The databases are quite small and even the most heavily
used ones only have at most a few hundred records added to them
everyday.
The problem is they
On Fri, 1 Oct 2010 11:30:59 +0100
Thom Brown t...@linux.com wrote:
2010/10/1 Bjørn T Johansen b...@havleik.no:
We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5
Navigator, where one can enable logging of SQL statements and then it
will recommed indexes that
2010/10/1 Bjørn T Johansen b...@havleik.no:
On Fri, 1 Oct 2010 11:30:59 +0100
Thom Brown t...@linux.com wrote:
2010/10/1 Bjørn T Johansen b...@havleik.no:
We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5
Navigator, where one can enable logging of SQL statements and
On 10/01/2010 06:51 PM, Frank Church wrote:
I want to migrate a lot of single user databases onto a single server
to allow the users to access them remotely, instead of on the
workstations. The databases are quite small and even the most heavily
used ones only have at most a few hundred records
On Fri, Oct 1, 2010 at 1:06 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
On 10/01/2010 06:30 PM, Dave Page wrote:
As for 2, I suspect that somewhere in the installer, it walks down the
path
to the TEMP directory, and fails at the junction because it cannot read
the
contents of its
On Fri, Oct 1, 2010 at 3:08 AM, John R Pierce pie...@hogranch.com wrote:
On 09/30/10 11:58 PM, GOO Creations wrote:
thanks for this tip, but as far as I understand it libpqtypes is not part
of the original lipq libary .
This will result in the same problem as with the Qt libraries, it will
Will it set optimal configuration so that manual editing of
postgresql.conf
is not required ?
It will generate a starter configuration, that will be based on your
selected workload type and machine resources. That may be fine for
your needs, or you may need to tune it to more precisely meet
Hi,
I have trying to create a new Slony-Cluster using pgAdmin. When I
clicked the OK button the following Error message is shown.
An error has occurred:
ERROR: could not access file $libdir/xxid: No such file or directory
The configured Slony-I path is C:\Program
Hi,
I have trying to create a new Slony-Cluster using pgAdmin. When I
clicked the OK button the following Error message is shown.
The configured Slony-I path is C:\Program Files\PostgreSQL\8.4\share (
where the slony script files are present.)
Thanks Regards,
Vishnu S
On Fri, Oct 1, 2010 at 2:24 PM, Andrus kobrule...@hot.ee wrote:
Will it set optimal configuration so that manual editing of
postgresql.conf
is not required ?
It will generate a starter configuration, that will be based on your
selected workload type and machine resources. That may be fine
On 1/10/2010 9:24 PM, Andrus wrote:
How to configure remote servers where only port 5432 is open ?
You can't. You need to be able to modify postgresql.conf .
Why pgAdmin postgresql.conf editor does not contain automatic
configurator ?
Because nobody has written one for PgAdmin. The
On 01/10/2010 10:14, Vishnu S. wrote:
Hi,
I have trying to create a new Slony-Cluster using pgAdmin. When I
clicked the OK button the following Error message is shown.
“An error has occurred:
ERROR: could not access file $libdir/xxid: No such file or directory”
The configured Slony-I path is
Then to get all statements would one simply set log_min_duration to some
arbitrarily small value?
On 10/01/2010 04:30 AM, Thom Brown wrote:
2010/10/1 Bjørn T Johansen b...@havleik.no:
We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5
Navigator, where one can enable
On 1 October 2010 14:43, Rob Sargent robjsarg...@gmail.com wrote:
Then to get all statements would one simply set log_min_duration to some
arbitrarily small value?
Well, 0 will do, although if you're got a busy cluster, this'll slow
it down. Its default is -1 which means disabled.
--
Thom
How do you copy a column from table please?
I'm trying with PostgreSQL 8.1.21/CentOS 5.5:
# psql -a -f clean-forum.sql
start transaction;
START TRANSACTION
create temp table old_topics (topic_id integer) on commit delete rows;
CREATE TABLE
create temp table old_posts (post_id integer) on commit
Hi Alex,
Of course select ... into doesn't work, but how should I do it?
Can't find in http://www.postgresql.org/docs/8.1/static/
You might want to look at the CREATE TABLE AS command. You might even
use the temporary definer.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
On Friday 01 October 2010 6:54:09 am Alexander Farber wrote:
How do you copy a column from table please?
I'm trying with PostgreSQL 8.1.21/CentOS 5.5:
# psql -a -f clean-forum.sql
start transaction;
START TRANSACTION
create temp table old_topics (topic_id integer) on commit delete rows;
How to configure automatically Linux and Mac servers ?
Run the tuning wizard on them?
Where to find installation packages for Debian and Ubuntu ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Fri, Oct 1, 2010 at 3:04 PM, Andrus kobrule...@hot.ee wrote:
How to configure automatically Linux and Mac servers ?
Run the tuning wizard on them?
Where to find installation packages for Debian and Ubuntu ?
Installers can be downloaded in StackBuilder.
--
Dave Page
Blog:
Where to find installation packages for Debian and Ubuntu ?
Installers can be downloaded in StackBuilder.
How to run StackBuilder from Debian bash command line ?
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Fri, Oct 1, 2010 at 10:02 AM, Adrian Klaver adrian.kla...@gmail.comwrote:
On Friday 01 October 2010 6:54:09 am Alexander Farber wrote:
How do you copy a column from table please?
I'm trying with PostgreSQL 8.1.21/CentOS 5.5:
select topic_id from phpbb_topics where forum_id=5 and
On Fri, Oct 1, 2010 at 3:13 PM, Andrus kobrule...@hot.ee wrote:
Where to find installation packages for Debian and Ubuntu ?
Installers can be downloaded in StackBuilder.
How to run StackBuilder from Debian bash command line ?
On RHEL/CentOS, I'd use the following from a root command prompt:
Rob Sargent skrev 2010-10-01 15.43:
Then to get all statements would one simply set log_min_duration to some
arbitrarily small value?
From default postgresql.conf comments:
-1 is disabled, 0 logs all statements and their durations, 0 logs only
statements running at least this number of
On Friday 01 October 2010 7:13:09 am Andrus wrote:
Where to find installation packages for Debian and Ubuntu ?
Installers can be downloaded in StackBuilder.
How to run StackBuilder from Debian bash command line ?
Andrus.
http://www.enterprisedb.com/learning/pginst_guide.do
--
Adrian
Ouch! I've loaded my backup while being connected
to the wrong database - to the dafeult postgres database.
Is there a way to restore it? I currently have:
postgres=# \l
List of databases
Name| Owner | Encoding
---+--+--
postgres | postgres | UTF8
2010/10/1 Thom Brown t...@linux.com:
But to find out what indexes you'll need, getting used to reading
query plans will help as it will show you more than just where
sequentials scans are taking place. It will also show you what the
planner believes a query will cost compared to how much it
On Fri, Oct 1, 2010 at 10:52 AM, Alexander Farber
alexander.far...@gmail.com wrote:
Thank you, I've created the following script which seems to work ok.
I just hope, that it won't be hit by the max_stack_depth-problem
which actually forced me to look for a custom solution -
SQL ERROR [
On 10/01/2010 10:40 PM, Alexander Farber wrote:
Ouch! I've loaded my backup while being connected
to the wrong database - to the dafeult postgres database.
Is there a way to restore it?
Sure. Just drop it and re-create it. The postgres database is just a
convenience, and is typically empty.
[sorry, I didn't intend to send my prev. reply off-list]
Hello Gurjeet,
thanks for you interest! I've just summarized my problem at the
http://www.phpbb.com/community/viewtopic.php?uid=221190f=46t=2105913start=0
I log protocols of card games into forum_id=5 as Anonymous user_id=1
at my site
First of all: Thanks to all who contributed to this issue. There are
many helpful and interesting comments.
I am going to reply to Christian's first question: How did TEMP end up
with this value?
I have just scanned my installation protocol which says, that I made a
registry backup of the
2010/10/1 bricklen brick...@gmail.com:
2010/10/1 Thom Brown t...@linux.com:
But to find out what indexes you'll need, getting used to reading
query plans will help as it will show you more than just where
sequentials scans are taking place. It will also show you what the
planner believes a
novnovice wrote:
My use case would involve a primary postgresql database and several
postgresql databases on disconnected notebook computers. All dbs need to be
able to support updates inserts etc; and then hopefully the replication
software would help with things like conflict resolution.
Thanks Greg. I'd had a quick look at bucardo and while it seems capable of
doing the job (or helping to do that job), I was hoping there was something
simpler. But I will have a closer look.
Have you ever evaluated rubyrep (http://www.rubyrep.org/)? It's also multi
master.
--
View this message
I have two tables and want to attach and return the most recent data from
the second table.
Table 1 has a counter ID and name. Table 2 has a counter ID, Reference (to
Table 1 ID), Date, and Like. I want to do a query that gets each name and
their most recent like. I have a unique key setup on
EXPLAIN SELECT count(DISTINCT catalog.id) FROM catalog WHERE flag=false;
QUERY PLAN
-
Aggregate (cost=1615927.27..1615927.28 rows=1 width=8)
- Seq Scan on catalog
On 20 Sep 2010, at 19:25, Steve Atkins wrote:
On Sep 20, 2010, at 10:06 AM, Alban Hertroys wrote:
Hey all,
I'm tossing an idea around again, namely using bit positions and values as
foreign key references. Let's start with a bit of background information:
I'm currently parsing a log-file
On Thursday 30 September 2010, Dann Corbit elucidated thus:
I installed the 64 bit PostgreSQL 9.0 on Windows Server 2008 and it
seems to perform wonderfully. I moved 1.5 million records that are 3K
wide from SQL*Server into PostgreSQL and rebuilt 6 indexes all in
less than 6 minutes.
I was
-Original Message-
From: Joshua J. Kugler [mailto:jos...@eeinternet.com]
Sent: Friday, October 01, 2010 10:36 AM
To: pgsql-general@postgresql.org
Cc: Dann Corbit
Subject: Re: Kudos on the 64 bit PostgreSQL for Windows
On Thursday 30 September 2010, Dann Corbit elucidated thus:
I
How to see what SQL queries are associated with pg_locks, please?
Could somebody help with the query? I can then add it to
http://wiki.postgresql.org/wiki/Lock_Monitoring
Best,
-at
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Fri, Oct 1, 2010 at 9:13 AM, Michal Politowski mpol...@meep.pl wrote:
EXPLAIN SELECT count(DISTINCT catalog.id) FROM catalog WHERE flag=false;
1: Try running explain analyze select ... here. It's far more informative.
2: select distinct is generally slower than using group by.
Hi All
I am planning to upgrade postgres to avoid this autovacuum problem.
From the release notes of postgres-8.1.x it seems this issue
has been solved in postgres-8.1.6 and hence upgrading
to latest 8.1 release i.e 8.1.21 will solve this issue.
But I was just wondering if postgres-8.4 will
Andrew E. Tegenkamp wrote:
I have two tables and want to attach and return the most recent data from
the second table.
Table 1 has a counter ID and name. Table 2 has a counter ID, Reference (to
Table 1 ID), Date, and Like. I want to do a query that gets each name and
their most recent like. I
On Fri, Oct 1, 2010 at 2:06 PM, tamanna madaan
tamanna.ma...@globallogic.com wrote:
Hi All
I am planning to upgrade postgres to avoid this autovacuum problem.
From the release notes of postgres-8.1.x it seems this issue
has been solved in postgres-8.1.6 and hence upgrading
to latest 8.1
Thanks a lot Scott ...
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Saturday, October 02, 2010 3:14 AM
To: tamanna madaan
Cc: Michael Glaesemann; pgsql-general@postgresql.org
Subject: Re: [GENERAL] error while autovacuuming
On Fri, Oct 1, 2010 at 2:06
On 2/10/2010 2:06 AM, Dann Corbit wrote:
SQLite can
deliver several thousand inserts per second if inside of a transaction.
If you were only getting a few inserts per second, then you were not
using transactions, thus SQLite was on autocommit mode, and thus
committing after every insert, thus
On 2/10/2010 5:44 AM, Scott Marlowe wrote:
On Fri, Oct 1, 2010 at 2:06 PM, tamanna madaan
tamanna.ma...@globallogic.com wrote:
Hi All
I am planning to upgrade postgres to avoid this autovacuum problem.
From the release notes of postgres-8.1.x it seems this issue
has been solved in
-Original Message-
From: Dann Corbit
Sent: Friday, October 01, 2010 11:06 AM
To: 'Joshua J. Kugler'; pgsql-general@postgresql.org
Subject: RE: Kudos on the 64 bit PostgreSQL for Windows
-Original Message-
From: Joshua J. Kugler [mailto:jos...@eeinternet.com]
Sent:
-Original Message-
From: Craig Ringer [mailto:cr...@postnewspapers.com.au]
Sent: Friday, October 01, 2010 6:08 PM
To: Dann Corbit
Cc: 'Joshua J. Kugler'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Kudos on the 64 bit PostgreSQL for Windows
On 2/10/2010 2:06 AM, Dann
On 2/10/2010 9:41 AM, Dann Corbit wrote:
The inserts are processed via an INSERT/SELECT statement.
A custom driver has been written that performs this operation
using the COPY API.
Aaah, so it's not really sending individual INSERT statements to the
database at all, you're using COPY behind
66 matches
Mail list logo