Hello,
Since ZFS on Linux (http://zfsonlinux.org/) has been declared production
ready last March (v0.6.1), I am curious if anyone is using it with
PostgreSQL on production servers (either main or backup) and if so, what is
their experience so far ?
Thank you,
Sébastien
Thanks for your reply, i am totally new to Postgis.
we have Database, but not ready for Geocode use. what i understood from
different blog, we should have latitude and longitude either based on
addresses, or postal code we have. However if I will get the lat and long,
need to calculate earth dist
On Thu, Jan 16, 2014 at 4:22 AM, Sébastien Lorion
wrote:
> Hello,
>
> Since ZFS on Linux (http://zfsonlinux.org/) has been declared production
> ready last March (v0.6.1), I am curious if anyone is using it with
> PostgreSQL on production servers (either main or backup) and if so, what is
> their
On Wed, Jan 15, 2014 at 6:07 PM, Tirthankar Barari wrote:
> My tables are:
>
> table test_metric (
> id varchar(255) not null, // just auto generated uuid from app
> timestamp timestamp not null,
> version int4,
> entity_id varchar(255) not null,
> primary k
http://www.unix-experience.fr/2013/2451/
FreeBSD is also a very mature platform for ZFS/postgresql.
On 16/01/2014 11:57, Sébastien Lorion wrote:
On Thu, Jan 16, 2014 at 4:22 AM, Sébastien Lorion mailto:s...@thestrangefactory.com>> wrote:
Hello,
Since ZFS on Linux (http://zfsonlinux.or
On 16 January 2014 12:09, Achilleas Mantzios
wrote:
> http://www.unix-experience.fr/2013/2451/
>
> FreeBSD is also a very mature platform for ZFS/postgresql.
More mature than on Linux even, as far as I know. If I had to choose
an OS to use ZFS with, I'd go with
either FreeBSD or Solaris. That sai
I'll auto-answer ;-)
Based on the function "btoptions" from postgres source, which takes aas a
first arg a text[] :
ArrayType *array;
Datum *dimdatums;
int ndim;
array = DatumGetArrayTypeP(dimensions);
Assert(ARR_ELEMTYPE(array) == TEXTOID);
pcinfo("after assert \n");
deconstruct_ar
Hi all,
I've set up a developing environment on my windows using Visual Studio
2012, everything works fine, except that the breakpoints set in analyze.c
are not triggered in debug mode (breakpoints in main.c and some
initialization code worked well), and I'm sure that line has been executed
since
=?GB2312?B?RmVsaXgu0Ow=?= writes:
> I've set up a developing environment on my windows using Visual Studio
> 2012, everything works fine, except that the breakpoints set in analyze.c
> are not triggered in debug mode (breakpoints in main.c and some
> initialization code worked well), and I'm sure
Is there any free or cheap software that will read in DDL and output a
graphic display of it? Preferably showing links for foreign keys.
I know about Erwin, but it is too expensive.
Thanks,
Susan
On Thu, Jan 16, 2014 at 08:45:44AM -0800, Susan Cassidy wrote:
> Is there any free or cheap software that will read in DDL and output a
> graphic display of it? Preferably showing links for foreign keys.
pg_autodoc
Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 453
Sparx architect
Regards
On Thursday, January 16, 2014 5:52 PM, Karsten Hilbert
wrote:
On Thu, Jan 16, 2014 at 08:45:44AM -0800, Susan Cassidy wrote:
> Is there any free or cheap software that will read in DDL and output a
> graphic display of it? Preferably showing links for foreign key
On Thu, Jan 16, 2014 at 3:22 AM, Sébastien Lorion
wrote:
> Hello,
>
> Since ZFS on Linux (http://zfsonlinux.org/) has been declared production
> ready last March (v0.6.1), I am curious if anyone is using it with
> PostgreSQL on production servers (either main or backup) and if so, what is
> their
Commit fest 2014-01, the fourth and final commit fest in the PostgreSQL
9.4 development cycle, has started. What is a commit fest?
https://wiki.postgresql.org/wiki/CommitFest
As before, we need more people to help review submitted patches. How do
you help reviewing?
https://wiki.postgr
Please see the comment at the bottom of this post.
On 16/01/14 22:52, itishree sukla wrote:
Thanks for your reply, i am totally new to Postgis.
At least you've got into it, I keep meaning do do so myself.
we have Database, but not ready for Geocode use. what i understood
from different blo
Hey list,
another tricky C function interface problem :
How to write a set returning function, that returns for each row an array?
it seems like the main function SRF_RETURN_NEXT takes Datum and so I can't
use PG_RETURN_ARRAYTYPE_P().
Shall I encapsulate the array into a composite field (only 1
another auto-answer :
Suprisingly ,
result = construct_array(...)
SRF_RETURN_NEXT(funcctx, PointerGetDatum(result));
But Datum memory must be allocated
Cheers,
Rémi-C
2014/1/16 Rémi Cura
> Hey list,
>
> another tricky C function interface problem :
>
> How to write a set returning function
On 1/16/2014 1:52 AM, itishree sukla wrote:
we have Database, but not ready for Geocode use. what i understood
from different blog, we should have latitude and longitude either
based on addresses, or postal code we have. However if I will get the
lat and long, need to calculate earth distance
Hi,
try DBVisualizer
--
Regards,
Bartek
Hi,
> If you really want ZFS, I would highly recommend looking into
> FreeBSD (Postgresql works great on it) or if you want to stick with Linux,
> look into mdadm with LVM or some other filesystem solution.
If you want to use ZFS because of its features, take a look at btrfs.
It provides a lot of
I use this script on an Ubuntu system:
#!/bin/bash
set -eu
postgresql_autodoc -d example_dev -u example_dev -h localhost
--password=
dot -Tpng -o example-schema.png example_dev.dot
dot -Tpdf -o example-schema.pdf example_dev.dot
That gives you a schema diagram in pdf, png, dia, and dot
On Thu, Jan 9, 2014 at 2:03 PM, Jeff Amiel wrote:
> I have a maintenance window coming up and using pg_upgrade to upgrade from
> 9.2.X to 9.3.X.
> As part of the window, I’d like to ‘cluster’ each table by its primary
> key. After doing so, I see amazing performance improvements (probably
> most
It doesn't appear that DBVisualizer does an ER type diagram, which is what
I really need.
Thanks,
Susan
On Thu, Jan 16, 2014 at 1:09 PM, Bartosz Dmytrak wrote:
> Hi,
>
> try DBVisualizer
>
>
>
> --
>
> Regards,
>
> Bartek
>
On Thu, Jan 16, 2014 at 2:57 PM, Susan Cassidy <
susan.cass...@decisionsciencescorp.com> wrote:
> It doesn't appear that DBVisualizer does an ER type diagram, which is what
> I really need.
>
>
DBSchema outputs ER diagrams:
http://www.dbschema.com/database-er-diagrams.html
I think the paid versio
What are the "dot" lines for? They don't seem to work on my Linux
installation. I tried adding them to the initial line, and I see no .pdf
output. I just see:
Producing testdb.dia from /usr/share/postgresql_autodoc/dia.tmpl
Producing testdb.dot from /usr/share/postgresql_autodoc/dot.tmpl
Produ
On 01/16/2014 03:12 PM, Susan Cassidy wrote:
What are the "dot" lines for? They don't seem to work on my Linux
installation. I tried adding them to the initial line, and I see no
.pdf output. I just see:
Producing testdb.dia from /usr/share/postgresql_autodoc/dia.tmpl
Producing testdb.dot fr
On 1/16/2014 3:12 PM, Susan Cassidy wrote:
What do I do with a .dot or .dia formatted file?
not sure about .DOT, but .DIA is probably for the Dia drawing program,
which is a simple Vizio like program, free open source.
--
john r pierce 37N 122W
somewhe
Hi Tom,
I'm debugging the /backend/commends/analyze.c.
I've set up a Function breakpoint in visual studio,but seems no luck, T_T
2014-01-17
ygnhzeus
发件人：Tom Lane
发送时间：2014-01-16 23:31
主题：Re: [GENERAL] Breakpoints are not triggered in analyze.c (debugging
Postgresql in Visual studio)
收件人："F
On Thu, Jan 16, 2014 at 10:45 AM, Susan Cassidy
wrote:
> Is there any free or cheap software that will read in DDL and output a
> graphic display of it? Preferably showing links for foreign keys.
>
> I know about Erwin, but it is too expensive.
I want to give a shout out for schemaspy . I think
Mogwai:
http://sourceforge.net/projects/mogwai/?source=directory
Needs JDBC drivers, but most database systems, including Postgres have one.
It is a little fiddly setting it up, but it seems to work with lots of data
sources.
Make sure the PosgreSQL jdbc driver is in the class path before you us
On Thu, Jan 16, 2014 at 6:09 AM, Achilleas Mantzios <
ach...@matrix.gatewaynet.com> wrote:
> http://www.unix-experience.fr/2013/2451/
>
> FreeBSD is also a very mature platform for ZFS/postgresql.
>
It is more mature than Linux for sure, but still not up to par with Solaris
for some features. Se
On Thu, Jan 16, 2014 at 6:34 AM, Alban Hertroys wrote:
> On 16 January 2014 12:09, Achilleas Mantzios
> wrote:
> > http://www.unix-experience.fr/2013/2451/
> >
> > FreeBSD is also a very mature platform for ZFS/postgresql.
>
> More mature than on Linux even, as far as I know. If I had to choose
On Thu, Jan 16, 2014 at 4:42 PM, Clemens Eisserer wrote:
> Hi,
>
> > If you really want ZFS, I would highly recommend looking into
> > FreeBSD (Postgresql works great on it) or if you want to stick with
> Linux,
> > look into mdadm with LVM or some other filesystem solution.
>
> If you want to use
On Thu, Jan 16, 2014 at 11:14 PM, Sébastien Lorion wrote:
> On Thu, Jan 16, 2014 at 4:42 PM, Clemens Eisserer wrote:
>
>> Hi,
>>
>> > If you really want ZFS, I would highly recommend looking into
>> > FreeBSD (Postgresql works great on it) or if you want to stick with
>> Linux,
>> > look into mda
34 matches
Mail list logo
