Hi,
On Fri, Dec 6, 2013 at 4:34 PM, Peter Kroon 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 SELECT pg_rel
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 v
Hi Peter,
On Mon, Dec 9, 2013 at 7:03 PM, Peter Kroon 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 log_mi
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 CTE
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 r
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
2013-12-02 18:23
A
steve.tout...@inspq.qc.ca
cc
"pgsql-general@postgres
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 ac
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 performanc
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,
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 1 TB database
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 Granular
On Dec 9, 2013, at 2:39 AM, Joek Hondius 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 this is
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 122W
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 ca
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 sur
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 ve
Stephan Fabel 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 writing a For
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 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 to
> read. The inde
On Tue, Dec 10, 2013 at 8:13 AM, Dmitry Koterov 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. I just
> ne
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 cross-dat
Hi Steve,
On Tue, Dec 10, 2013 at 11:08 AM, Steve Erickson
wrote:
> 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 recover the
> directory
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 ca
Hi Peter,
On Mon, Dec 9, 2013 at 7:52 PM, Peter Kroon 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 postrgesql h
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 = SRF_FIRSTCALL_IN
30 matches
Mail list logo
