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
On Thu, Jan 16, 2014 at 4:22 AM, Sébastien Lorion
s...@thestrangefactory.comwrote:
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
On Wed, Jan 15, 2014 at 6:07 PM, Tirthankar Barari tbar...@verizon.com 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,
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 s...@thestrangefactory.com
mailto:s...@thestrangefactory.com wrote:
Hello,
Since ZFS on
On 16 January 2014 12:09, Achilleas Mantzios
ach...@matrix.gatewaynet.com 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
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);
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=?= ygnhz...@gmail.com 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
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 4537
Sparx architect
Regards
On Thursday, January 16, 2014 5:52 PM, Karsten Hilbert
karsten.hilb...@gmx.net 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
On Thu, Jan 16, 2014 at 3:22 AM, Sébastien Lorion
s...@thestrangefactory.comwrote:
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
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?
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
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
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 remi.c...@gmail.com
Hey list,
another tricky C function interface problem :
How to write a set
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 becauseimj...@yahoo.com 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
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 bdmyt...@gmail.com 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 version is
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
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
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
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 t...@sss.pgh.pa.us
发送时间:2014-01-16 23:31
主题:Re: [GENERAL] Breakpoints are not triggered in analyze.c (debugging
Postgresql in
On Thu, Jan 16, 2014 at 10:45 AM, Susan Cassidy
susan.cass...@decisionsciencescorp.com 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
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
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. See
On Thu, Jan 16, 2014 at 6:34 AM, Alban Hertroys haram...@gmail.com wrote:
On 16 January 2014 12:09, Achilleas Mantzios
ach...@matrix.gatewaynet.com wrote:
http://www.unix-experience.fr/2013/2451/
FreeBSD is also a very mature platform for ZFS/postgresql.
More mature than on Linux even,
On Thu, Jan 16, 2014 at 4:42 PM, Clemens Eisserer linuxhi...@gmail.comwrote:
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
On Thu, Jan 16, 2014 at 11:14 PM, Sébastien Lorion s...@thestrangefactory.com
wrote:
On Thu, Jan 16, 2014 at 4:42 PM, Clemens Eisserer linuxhi...@gmail.comwrote:
Hi,
If you really want ZFS, I would highly recommend looking into
FreeBSD (Postgresql works great on it) or if you want to
34 matches
Mail list logo