Hi,
On Fri, Dec 6, 2013 at 4:34 PM, Peter Kroon plakr...@gmail.com wrote:
Thanks, but i need a non command line option.
We can do this with a function which is having the sql queries of pgAdmin
raised against the database.
= Log all the queries by enabling log_minduration_statement=0.
= Do
Hi All,
We have been running our product on PostgreSQL for quite some time now.
Started out with 7.0
I have this situation where i want to migrate my (many) PostgreSQL 8.3
databases to a new server running 9.2
In my case this is not a problem for schema and data.
But i do not want to update
I have a database with views that have rules on them, so that users can do
insert/update/delete on their part of the data.
The rules ore do instead rules that redirect the edits to the table that
actually holds the data, on which the users have no rights.
This works fine in MS Access (at least
Hi Peter,
On Mon, Dec 9, 2013 at 7:03 PM, Peter Kroon plakr...@gmail.com wrote:
Hi Dinesh,
Get all the queries what it has performed.
How and where?
When I run select * from pg_stat_activity I get the same result with and
without log_minduration_statement=0
By setting this parameter
Willy-Bas Loos, 09.12.2013 14:36:
I have a database with views that have rules on them, so that users
can do insert/update/delete on their part of the data. The rules ore
do instead rules that redirect the edits to the table that actually
holds the data, on which the users have no rights.
Hi Dinesh,
SELECT pg_reload_conf();
Did not do the job, I had to restart the server.
I managed to collect the queries and there are a lot of them to show the
SQL that is needed to create the given table.
Does postrgesql have any plan on making their own function for this?
Best,
Peter
2013/12/9
Hello,
could it be possible then to define a custom CTE as the result of a
function?
somthing like :
with first_cte AS (
select blabla)
, second_cte AS (
a_function_returning_a_set(parameters)
)
SELECT blabla
A CTE is much like what you would like bborie :
you can reference previously defined
On 12/09/2013 05:36 AM, Willy-Bas Loos wrote:
I have a database with views that have rules on them, so that users can
do insert/update/delete on their part of the data.
The rules ore do instead rules that redirect the edits to the table
that actually holds the data, on which the users have no
Hi Jeff
This query returns
tmpcarteprotection4
tmpcarteprotection4 is old and useless, it could be dropped. Before
dropping it is there something else I should do?
Thank you very much for your help
Steve
Jeff Janes jeff.ja...@gmail.com
2013-12-02 18:23
A
steve.tout...@inspq.qc.ca
cc
On 11/22/2013 5:57 AM, Albe Laurenz wrote:
Kaushal Shriyan wrote:
I have read on the web that Postgresql DB supports replication
across data centers. Any real life usecase examples if it has been
implemented by anyone.
Well, we replicate a 1 TB database between two locations. It is a
fairly
Hi all,
and sorry if I'm asking a question that has been answered before; has the
PostgreSQL community ever considered different key/value backends (sort of like
MySQL with its many different options)?
We'd be very interested in seeing the effects of integrating LMDB [*] in terms
of
On Dec 9, 2013, at 8:09 AM, Thomas Harold wrote:
On 11/22/2013 5:57 AM, Albe Laurenz wrote:
Kaushal Shriyan wrote:
I have read on the web that Postgresql DB supports replication
across data centers. Any real life usecase examples if it has been
implemented by anyone.
Well, we replicate a
Thomas Harold thomas-li...@nybeta.com wrote:
On 11/22/2013 5:57 AM, Albe Laurenz wrote:
Kaushal Shriyan wrote:
I have read on the web that Postgresql DB supports replication
across data centers. Any real life usecase examples if it has been
implemented by anyone.
Well, we replicate a 1 TB
On 12/9/2013 11:24 AM, Ben Chobot wrote:
Out of curiosity what did you find unclear about
http://www.postgresql.org/docs/9.3/static/different-replication-solutions.html?
Perhaps the Per-table granularity line in the matrix (Table 25-1)
might be better written as:
Synchronization
On Dec 9, 2013, at 2:39 AM, Joek Hondius jhond...@rem.nl wrote:
Hi All,
We have been running our product on PostgreSQL for quite some time now.
Started out with 7.0
I have this situation where i want to migrate my (many) PostgreSQL 8.3
databases to a new server running 9.2
In my case
Hi All,
I have been running Postgresxc 1.1 on a 40 core, 1 TB RAM, Intel(R) Xeon(R)
machine.
The data tables size with which the database is populated is approx 14GB.
The issue is that during the index creation time on the big table of approx
13GB size, the following error occurs:
ERROR: could
On 12/9/2013 10:07 AM, RUSHI KAW wrote:
I have been running Postgresxc 1.1
you'd probably be best off finding the postgresql-xc list, as that is
really a rather different system, even if it is forked from community
postgresql.
--
john r pierce 37N
Agreed. However, the tuple not found error problem seems to happen with
postgres as well, if not in the particular case index creation over large
datasets. It would helpful to know in that scenario what are the fixes and
how to avoid it in the first place.
The solution/fixes for postgres will
No, there's no timestamp.
Here's a screenshot of the error in access 2010.
I'll have tot translate it, it's in dutch (and you can't change the
language like you can in ubuntu.. )
It says:
==write conflict==
As you were editing the record, it was changed by another user.
If you save the record, the
Hello All,
We are trying to trace cause and potential solution of tuple not found
error with postgres-xc. The problem happens when indexing a large file. It
seems the autovaccum locks certain cache pages that the indexer tries to
read. The indexing fails with tuple not found error.
I am sure
Willy-Bas Loos wrote on 09.12.2013 21:44:
But the option to save the record is disabled, the other 2 buttons do not
enable me to save the record.
Anyway, i don't care much for MS Access, any client will do (that is, if it
costs money,
it would be nice if most users own it already or it isn't
Stephan Fabel sfa...@hawaii.edu wrote:
has the PostgreSQL community ever considered different key/value
backends (sort of like MySQL with its many different options)?
We'd be very interested in seeing the effects of integrating LMDB
in terms of performance gains.
You might want to consider
Hello.
Is there a way to compress the traffic between master and slave during the
replication?.. The streaming gzip would be quite efficient for that.
(WAL archiving is not too good for this purpose because of high lag. I just
need to minimize the cross-datacenter traffic keeping the replication
On Tue, Dec 10, 2013 at 7:17 AM, Sandeep Gupta gupta.sand...@gmail.com wrote:
We are trying to trace cause and potential solution of tuple not found
error with postgres-xc. The problem happens when indexing a large file. It
seems the autovaccum locks certain cache pages that the indexer tries
On Tue, Dec 10, 2013 at 8:13 AM, Dmitry Koterov dmi...@koterov.ru wrote:
Hello.
Is there a way to compress the traffic between master and slave during the
replication?.. The streaming gzip would be quite efficient for that.
(WAL archiving is not too good for this purpose because of high lag.
On 12/9/2013 3:13 PM, Dmitry Koterov wrote:
Is there a way to compress the traffic between master and slave during
the replication?.. The streaming gzip would be quite efficient for that.
(WAL archiving is not too good for this purpose because of high lag. I
just need to minimize the
Hi Steve,
On Tue, Dec 10, 2013 at 11:08 AM, Steve Erickson
serick...@digitiliti.comwrote:
While prepping a second server today the /var/lib/postgres/ directory
got deleted. Yes, everything. We’re running on Ubuntu 10.4 and Postgres
8.4. We immediately shutdown everything but now need to
On 12/9/2013 10:17 PM, Dinesh Kumar wrote:
If we’re unsuccessful, we do have a filesystem backup from several
months ago that we can apply and then go through the tedium of trying
to fill in the missing blanks for those months. Since there are so
many rows, is there a tool or procedure we
Hi Peter,
On Mon, Dec 9, 2013 at 7:52 PM, Peter Kroon plakr...@gmail.com wrote:
Hi Dinesh,
SELECT pg_reload_conf();
Did not do the job, I had to restart the server.
I managed to collect the queries and there are a lot of them to show the
SQL that is needed to create the given table.
Does
Dear Colleagues !
I have to return setof values from C-function
I wrote
FuncCallContext *funcctx;
int call_cntr;
int max_calls;
AttInMetadata *attinmeta;
unsigned long il;
if (SRF_IS_FIRSTCALL())
{
MemoryContext oldcontext;
funcctx =
30 matches
Mail list logo
