On Mon, Jun 01, 2015 at 02:06:05PM -0400, Robert Haas wrote:
> On Mon, Jun 1, 2015 at 12:46 AM, Noah Misch wrote:
> > On Fri, May 29, 2015 at 03:08:11PM -0400, Robert Haas wrote:
> >> SetMultiXactIdLimit() bracketed certain parts of its
> >> logic with if (!InRecovery), but those guards were ineff
On 6/2/15, Jan de Visser wrote:
> On June 1, 2015 11:11:37 PM Arthur Silva wrote:
>> In my opinion a twice a year schedule would be good.
>> The LTS would be every 2 or 4 releases. Keeping 2 LTS versions supported
>> at
>> all moments.
>>
>> Maybe this should be reposted to the hackers list?
>
> P
On June 1, 2015 11:11:37 PM Arthur Silva wrote:
> In my opinion a twice a year schedule would be good.
> The LTS would be every 2 or 4 releases. Keeping 2 LTS versions supported at
> all moments.
>
> Maybe this should be reposted to the hackers list?
Pretty sure this would be shot down pretty qui
On 06/01/2015 07:11 PM, Arthur Silva wrote:
On Sun, May 31, 2015 at 6:44 AM, Zenaan Harkness mailto:z...@freedbms.net>> wrote:
My comments advocating a (ubuntu/debian/linux-kernel/firefox) LTS
release and feature-train release cycle:
https://lwn.net/Articles/646740/
https://lwn
On Sun, May 31, 2015 at 6:44 AM, Zenaan Harkness wrote:
> My comments advocating a (ubuntu/debian/linux-kernel/firefox) LTS
> release and feature-train release cycle:
> https://lwn.net/Articles/646740/
> https://lwn.net/Articles/646743/
>
> The parent article "PostgreSQL: the good, the bad, and t
On 06/01/2015 07:42 AM, Filipe Pina wrote:
Thanks for the reply anyway, it's a pity though, it'd be useful..
Another bump I've found along the pl/python road: insert ROWTYPE in table..
Maybe you have some hint on that? :)
So, in PLPGSQL I can:
DECLARE
my_var my_table;
BEGIN
my_var.col1 :
On 6/1/2015 12:04 PM, Mimiko wrote:
I have several programs which can use mysql,access,oracle DB as a
front-end DB via odbc. Is there a method to emulate or hide the
back-end DB so for program it will be seen as mysql, but real DB will
be on postgres?
ODBC *is* that method. you just need
Hello,
PostgreSQL has a fully standards compliant ODBC driver (See:
https://odbc.postgresql.org/). Any application designed to communicate with
DBMS over ODBC connection should be able to use that driver to communicate
with PostgreSQL. Most applications that interact with databases come with
ODBC
Thank you very much. Well done. Backups it's all)) 01.06.2015, 03:05, "Melvin Davidson" :If you have a pg_dumpall, or a pg_dump of your databases, you "might" be able to get your data back by doing the following.1. If your data directory is corrupted or still exists, rename it.2. Make copies of yo
Alvaro Herrera wrote:
> Anyway here's a quick script to almost-reproduce the problem.
Meh. Really attached now.
I also wanted to post the error messages we got:
2015-05-27 16:15:17 UTC [4782]: [3-1] user=,db= LOG: entering standby mode
2015-05-27 16:15:18 UTC [4782]: [4-1] user=,db= LOG: resto
Alvaro Herrera wrote:
> Robert Haas wrote:
> > In the process of investigating this, we found a few other things that
> > seem like they may also be bugs:
> >
> > - As noted upthread, replaying an older checkpoint after a newer
> > checkpoint has already happened may lead to similar problems. Th
On 06/01/2015 12:04 PM, Mimiko wrote:
Hello.
I have several programs which can use mysql,access,oracle DB as a
front-end DB via odbc. Is there a method to emulate or hide the back-end
DB so for program it will be seen as mysql, but real DB will be on
postgres?
On a theoretical level you could
Thomas Munro wrote:
> > - There's a third possible problem related to boundary cases in
> > SlruScanDirCbRemoveMembers, but I don't understand that one well
> > enough to explain it. Maybe Thomas can jump in here and explain the
> > concern.
>
> I noticed something in passing which is probably n
Salvete!
I'm in a handle for a trigger for TRUNCATE. Is it possible to find out
whether the TRUNCATE TABLE ist called with CASCADE?
regads andreas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/p
On 01.06.2015 16:15, Tom Lane wrote:
Andreas Ulbrich writes:
The question is the todo in the script: Is there a way to find out what
indexes depends on what function?
Direct dependencies would show up in pg_depend. Indirect ones wouldn't,
since we don't analyze function bodies to see what the
In 9.1+ you can monitor the state of your slave easily with
the standby_state field of pg_stat_replication:
SELECT standby_pid,
standby_usesysid,
standby_usename,
standby_client_addr,
standby_client_port,
standby_state
FROM pg_stat_replication;
If the standby is
Hello.
I have several programs which can use mysql,access,oracle DB as a
front-end DB via odbc. Is there a method to emulate or hide the back-end
DB so for program it will be seen as mysql, but real DB will be on postgres?
Thank you.
--
Sent via pgsql-general mailing list (pgsql-general@pos
What about keeping all the dynamic columns of each product in a json(b)
column ?
Maybe you can make constraints that check the product_type and
json->field->type ?
On Mon, Jun 1, 2015 at 4:35 PM, Adrian Stern
wrote:
> Hi, I'm new
>
> I've been working as the sole administrator of various postgre
On Mon, Jun 1, 2015 at 4:58 AM, Andres Freund wrote:
>> I'm probably biased here, but I think we should finish reviewing,
>> testing, and committing my patch before we embark on designing this.
>
> Probably, yes. I am wondering whether doing this immediately won't end
> up making some things simpl
Please, keep the list posted.
2015-06-01 20:09 GMT+02:00 Ivann Ruiz :
> I get 1 row, a walreceiver and my slave IP,
>
>
Then all is good.
> i was expecting something like:
>
> pg_current_xlog_location
> --
> 0/200
> (1 row)
>
>
> When I ran -> psql -c
On Mon, Jun 1, 2015 at 12:46 AM, Noah Misch wrote:
> Incomplete review, done in a relative rush:
Thanks.
> On Fri, May 29, 2015 at 03:08:11PM -0400, Robert Haas wrote:
>> OK, here's a patch. Actually two patches, differing only in
>> whitespace, for 9.3 and for master (ha!). I now think that t
Hi,
2015-06-01 19:57 GMT+02:00 Ivann Ruiz :
> I just setup my databases and got this LOG:
>
> LOG: database system was shut down in recovery at 2015-06-01 13:31:21 EDT
> LOG: entering standby mode
> LOG: redo starts at 0/67000278
> LOG: consistent recovery state reached at 0/67000350
> LOG:
I just setup my databases and got this LOG:
LOG: database system was shut down in recovery at 2015-06-01 13:31:21 EDT
LOG: entering standby mode
LOG: redo starts at 0/67000278
LOG: consistent recovery state reached at 0/67000350
LOG: record with zero length at 0/67000350
LOG: database system
On 06/01/2015 09:09 AM, Rémi Cura wrote:
Hey, thanks to help me with that.
I started fresh to have a truly reproducible process,
so you can have all information and rule out some error possibilities.
- Uninstall all python.
- Check that PythonPath doesn't exist anymore
- check that python
Here is the test code
---
--creating plpython3u
DROP LANGUAGE plpython3u CASCADE;
CREATE LANGUAGE plpython3u ;
--create a test function
DROP FUNCTION IF EXISTS rc_test_python( );
CREATE FUNCTION rc_test_python( )
RETURNS void
AS $$"""
@brief This function test python
"""
import sys
Hey, thanks to help me with that.
I started fresh to have a truly reproducible process,
so you can have all information and rule out some error possibilities.
- Uninstall all python.
- Check that PythonPath doesn't exist anymore
- check that python doesn't exist anymore
- install python 3.2.5
Thanks for the reply anyway, it's a pity though, it'd be useful..
Another bump I've found along the pl/python road: insert ROWTYPE in
table..
Maybe you have some hint on that? :)
So, in PLPGSQL I can:
DECLARE
my_var my_table;
BEGIN
my_var.col1 := 'asd';
INSERT INTO my_table VALUES(my_table
Hi, I'm new
I've been working as the sole administrator of various postgresql projects
for a while now. All of which where django projects.
Since a new project is starting and we've found the need for a more generic
approach I would like to ask a few questions.
I would like to implement a pattern
Andreas Ulbrich writes:
> The question is the todo in the script: Is there a way to find out what
> indexes depends on what function?
Direct dependencies would show up in pg_depend. Indirect ones wouldn't,
since we don't analyze function bodies to see what they call (and if we
tried, there's th
Salvete.
If I have an expression based index (a fucntion call) then the index
will become corrupt, if the function is changed. As the function
developer, I do not know, who uses the function for an index, and as the
user of the function in an index I do not know if the function is
changed. So
On Mon, Jun 1, 2015 at 3:18 AM, Tom Lane wrote:
> Maxim Boguk writes:
> > On the one of databases under my support I found very curious case of the
> > almost endless index bloat (index size stabilises around 100x of the
> > original size).
>
> > The table have 5 indexes and they all have the sa
On 06/01/2015 06:04 AM, Rishi Gokhale wrote:
Hey Adrian and Albe,
Thanks very much for your quick responses. I am indeed using EDB's postgres
plus.
It looks like it has a function thats forcing the date type to change to a
timestamp. I actually deleted that function, but it still didn't help.
Rishi Gokhale wrote:
> Thanks very much for your quick responses. I am indeed using EDB's postgres
> plus.
>
> It looks like it has a function thats forcing the date type to change to a
> timestamp. I actually
> deleted that function, but it still didn't help.
You shouldn't delete any functions
Hey Adrian and Albe,
Thanks very much for your quick responses. I am indeed using EDB's postgres
plus.
It looks like it has a function thats forcing the date type to change to a
timestamp. I actually deleted that function, but it still didn't help.
Thanks,
Rishi
__
Thank your William for your help.
After 1 week, I do not see any improvement. Worse, I have to manually run
"ANALYSE" daily.
Here is my config :
My bloat for this table is 1.04151.
What does it mean exactly ?
Why do we have to analyse the table daily ? Is it normal ?
Thank you so much for y
Hi Glen:
On Mon, Jun 1, 2015 at 1:16 AM, Glen M. Witherington wrote:
> Thanks Francisco, that makes sense. I've started moving my code to that,
> and it eliminates all the performance issues I had.
Happty to hear it. Seems you have a kind of speed-size trade off. If
you can solve it while prese
On 2015-05-31 07:51:59 -0400, Robert Haas wrote:
> > 1) We continue determining the oldest
> > SlruScanDirectory(SlruScanDirCbFindEarliest)
> >on the master to find the oldest offsets segment to
> >truncate. Alternatively, if we determine it to be safe, we could use
> >oldestMulti to f
Alright. I got it running and used
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ ; specifically:
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispell-german-compound.tar.gz
Not sure where to find up-to-date/authorized the ispell dictionaries. I
figured that I ne
Adrian Klaver wrote:
> On 05/30/2015 10:05 PM, Rishi Gokhale wrote:
>> When I create a table with a column whose type is date the type gets
>> forced to timestamp without timezone after it gets created
>>
>> ops=# CREATE TABLE test (
>> ops(# namevarchar(40) NOT NULL,
>> ops(# start dat
I actually wanted to minimize the installation effort. Thus, I used the
hunspell-de-de package of Debian/Ubuntu.
Give me a second for ispell.
Below, see the hunspell variant for
Produktionsintervall/Produktionintervall:
=# select * from ts_debug('public.german_compound', 'Produktionsinterval
40 matches
Mail list logo