Hi All,
I saw a few days back some spam mails have been sent from this account (was
possibly hacked?). Am taking care of this to my best. I never send any link in
my mails without sufficient contextual information so if you happen to get such
mails from my ids in future please delete it witho
On Sat, Oct 22, 2011 at 9:31 PM, AI Rumman wrote:
> Is there any tools by which I can test out the MVCC feature of postgresql?
The best tool is psql. Just open up two or more sessions and
experiment with transactions, transaction isolation levels and update
/ insert / delete / select and see how
Good way to understand MVCC feature is XID(transaction-id) and with the help
of hidden columns prefixed for each row in a table.
You need to test with doing DML(update/Delete/Insert) statements by opening
multiple sessions to know about MVCC feature.
Eg:-
select xmin,xmax,cmin,cmax,ctid, * from ;
Is there any tools by which I can test out the MVCC feature of postgresql?
2011/10/20 Birta Levente
> Hi
>
> I use postgrsql 9.1.1 and I want to change archive_timeout on a running
> server. My default archive_timeout is 1800s, and nightly I want to change to
> 3600s or more, but I get the following error message:
>
> set archive_timeout='3600';
> ERROR: parameter "arc
On Fri, Oct 21, 2011 at 9:19 PM, Emi Lu wrote:
> Thank you first.
>
> I believe that upate pg_class can only be done by superuser, right?
>
Yes,it's requires superuser privileges.
>
> Besides, if I need the whole schema's foreign keys to be disabled and then
> enabled later.
>
> Is there a sim
On 10/22/2011 04:31 PM, Alexander Farber wrote:
> Hello,
>
> sadly I have to ban few users from my game web
> site daily and so I'm trying to write a procedure for
> first copying their id, name, city, IP into a pref_ban table
> and then erasing their comments and statistics:
>
> create o
Hello,
sadly I have to ban few users from my game web
site daily and so I'm trying to write a procedure for
first copying their id, name, city, IP into a pref_ban table
and then erasing their comments and statistics:
create or replace function pref_delete_user(_id varchar,
_re
On Saturday, October 22, 2011 12:06:25 pm stefan wrote:
> >> Therefore the only solution I see is to drop plpgsql from template1, or
> >> writing a wrapper script that exploits the -l and -L options of
> >> pg_restore.
> >
> > Yes. Though I could see an option to create a template database without
On 22-10-11 18:21, Tom Lane wrote:
Or just ignore the error during restore.
Hi Tom,
for a manual restore I could just live with that, but this is a semi
automated setup and we feel very strongly about acting on pg_restore's
exit code.
Cheers,
Stefan.
--
Sent via pgsql-general mailing
Therefore the only solution I see is to drop plpgsql from template1, or
writing a wrapper script that exploits the -l and -L options of pg_restore.
Yes. Though I could see an option to create a template database without plpgsql
in it for use by non-superuser users and leave template1 as is.
A
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
>> Is it possible to do a full file system level backup of the data
>> directory, say once a week, and differentials or incrementals daily?
...
> taken, so a trigger-based or WAL-based system is necessary.
...
> SQL-level differentials would be
On Oct 21, 2011, at 10:23 PM, Charles Waweru wrote:
> I am looking for a tool in the PostgreSQL database that can help to audit
> fraudulent activities on a PostgreSQL database. Of particular interest is how
> to retrieve say from a PostgreSQL sales database all the deleted rows.
>
> Any sugg
On Oct 22, 2011, at 1:23, "Charles Waweru" wrote:
> I am looking for a tool in the PostgreSQL database that can help to audit
> fraudulent activities on a PostgreSQL database. Of particular interest is how
> to retrieve say from a PostgreSQL sales database all the deleted rows.
>
>
>
> Any
On Saturday, October 22, 2011 8:33:01 am stefan wrote:
>
> Thank you, Adrian for your response.
>
> I have checked your suggestion: in pg_pltemplate, tmpldbacreate is set
> to true. As you state above, this allows a non superuser to create the
> language in any database that does not yet has tha
Hello
2011/10/22 Charles Waweru :
> I am looking for a tool in the PostgreSQL database that can help to audit
> fraudulent activities on a PostgreSQL database. Of particular interest is
> how to retrieve say from a PostgreSQL sales database all the deleted rows.
>
you can use triggers
PostgreSQL
I am looking for a tool in the PostgreSQL database that can help to audit
fraudulent activities on a PostgreSQL database. Of particular interest is
how to retrieve say from a PostgreSQL sales database all the deleted rows.
Any suggestion please would be appreciated.
Charles
stefan writes:
> However, due to the fact that in 9.0, the language is in template1 and
> owned by postgres, a non superuser database owner will not have the
> right to create or replace this language in any newly created database
> owned by himself.
True.
> Therefore the only solution I see
On 22-10-11 16:12, Adrian Klaver wrote:
On Saturday, October 22, 2011 2:12:14 am stefan wrote:
pg_restore: [archiver (db)] could not execute query: ERROR: must be
owner of language plpgsql
Command was: CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql;
Is there a way that this error can be
miesi writes:
> Maybe I'm blind, but where is the difference diff sees?
PST vs PDT. Apparently you're using a system-provided timezone database
that lacks support for wider-than-32-bit time_t, so that dates beyond
2038 aren't handled correctly.
regards, tom lane
--
Sen
On Saturday, October 22, 2011 2:12:14 am stefan wrote:
> Hi,
>
> we run a setup with multiple non superusers who have the option of
> restoring their databases in a semi-automated fashion.
>
> In 9.0, we run into the following error:
>
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
>
Hi,
I've just compiled 9.1.1 in 32bit on Solaris snv_134 ("OpenSolaris
2010.11") with the Solaris Studio Compilers 12.2. The following Problem
is displayed
Maybe I'm blind, but where is the difference diff sees?
Thomas
*** /tmp/postgresql-9.1.1/src/test/regress/expected/timestamptz.out
Thu
Tom Lane wrote on 22.10.2011 05:24:
I'm thinking there is something you haven't told us about that creates a
great deal of overhead for updates on this table. Lots and lots o'
indexes? Lots and lots o' foreign key references?
Why would an add column need to check foreign key references?
--
Hi all,
I have some problems with building pgRouting for PostgreSQL 9.1.1
on Windows XP SP3 with MinGW.
PostgreSQL was compiled successfully, all necessary dependencies
too. But when I try to build pgRouting with TSP and DD features enabled
I get next errors:
Scanning dependencies of target rout
I've just started a virtual box with the Solaris 11 Early Access DVD ISO
and it showed that snv_173 libsocket has the SUNW_1.7 interface.
Could you please modify the Read-me on the download page. It should tell
that the binaries were compiled on Solaris 11 Early Access.
Thanks Thomas
On 22.1
Hi,
Adding the Solaris package maintainer, Bjorn.
On Fri, 2011-10-21 at 22:45 +0200, Thomas Mieslinger wrote:
> Hi,
>
> I'm trying to run the precomplied binaries form postgresql.org for
> solaris 11 intel. The Readme says it has been compiled on opensolaris
> 2010.11 which is (to the best of
Hi,
we run a setup with multiple non superusers who have the option of
restoring their databases in a semi-automated fashion.
In 9.0, we run into the following error:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 1038; 2612 11574
27 matches
Mail list logo
