On Wed, Aug 15, 2012 at 01:48:45PM +0200, Wolfgang Keller wrote:
Can anyone advice about a tool to visualize a database schema?
SQLalchemy, a Python module, can produce dot (Graphviz) output
which you can load into your favourite diagramming application such
as e.g. Omnigraffle, yEd
On 16/08/12 04:05, Tomas Hlavaty wrote:
Hi all,
I managed to compile postgresql on BeagleBone.
[snip]
Hi Tomas,
If you install Ubuntu, you can just install postgresql with the package
management software.
$ apt-get install postgresql
-Toby
--
Sent via pgsql-general mailing list
I want to have a master-slave setup mainly for backups (but a hot read
replica would be an added bonus).
I have been using WAL replication earlier using Skytools walmgr utility.
After upgrading to 9.1, I have explored streaming replication and it works
nicely. However, here are some points which
On Thu, Aug 16, 2012 at 11:11 AM, sayeed sayeed.an...@gmail.com wrote:
I want to have a master-slave setup mainly for backups (but a hot read
replica would be an added bonus).
I have been using WAL replication earlier using Skytools walmgr utility.
After upgrading to 9.1, I have explored
( i sent this mail yesterday, but it vanished, this time, I'm making it
smaller by extracting some info and putting it on webserver, maybe it
will be accepted this time )
hi
i have 9.1.4 pg on linux on ext3 system with dedicated disks. xlogs are
on different disks than data directory.
every so
Thanks Magnus for the really fast response.
Your inputs have helped removed my doubts. I now went back and checked my
slave server and the WALs files are being shipped and the streaming
replication is also working. I will try a PITR test this weekend...
I have set wal_keep_segments to 3 but
Neanderthelle Jones wrote:
We are getting a strange thing happening if the lo_export(attr, path)
destination is a fifo.
First, in the normal case, there is output to the file but also
feedback to stdout (or somewhere, appearing on the VT screen) of the
number 1.
---
1
On 08/15/2012 06:45 PM, Andrew Hastie wrote:
As I understand it, I am allowed to redistribute Postgres so long as I
include the copyright notice plus paragraphs as detailed on
http://www.postgresql.org/about/licence/.
What I want to confirm is that the one-click installer (which I
understand
Thanks for your thoughts Craig, the issue with users having an existing
PG installation is a definite concern.
It sounds like you're recommending using the ZIP Binaries, at least
for MS Win installs, and configuring things manually rather than using
the one-click installer. If so, are there
Hello
I am using libpq to find information about fileds of table ( type and size).
I have a problem with getting the sizeof varchar fields.
If a table has a fiels varchar[35] and want to obtain 35.
I used PQgetlength or PQfsize but is not good for my work.
Can someone tell me what function shall
I could not get the script sqlalchemy_schemadisplay3.py to work with
sqlalchemy 0.7.8-1 (on Debian).
Have you asked on the SQLalchemy mailing list?
http://www.sqlalchemy.org/support.html#mailinglist
Sincerely,
Wolfgang
--
Sent via pgsql-general mailing list
On 08/16/2012 06:46 PM, Andrew Hastie wrote:
Thanks for your thoughts Craig, the issue with users having an
existing PG installation is a definite concern.
It sounds like you're recommending using the ZIP Binaries, at least
for MS Win installs
I wouldn't go as far as recommending. At this
Hey aliosa
2012/8/16 aliosa constantinica_a...@yahoo.com
Hello
I am using libpq to find information about fileds of table ( type and
size).
I have a problem with getting the sizeof varchar fields.
If a table has a fiels varchar[35] and want to obtain 35.
I used PQgetlength or PQfsize but
I have a database that only receives updates maybe a few times a week.
It is the storage for some web content where the content is not
changed very often.
I set archive_timeout to 5 minutes, because when an update is made I
would like the log that contains that change to get archived fairly
Jeff Janes jeff.ja...@gmail.com wrote:
archive_timeout and checkpoint_timeout have a pernicious
interaction. Each one individually suppresses needless
operations, i.e. not checkpointing if no WAL was written since
last checkpoint, and not log-switching if no WAL was written since
the last
Since the streaming slave has come back up it appears that we've now hit
the same issue again. With the checkpoint logging on I now have some more
information.
Everything was working as expected for the first 2 days (with a 5 minute
auto checkpoint time the log contains the expected 288 restart
On 08/16/2012 02:45 AM, sayeed wrote:
Thanks Magnus for the really fast response.
Given the nature of your questions, you may want to take a look at
http://www.pgbarman.org/
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Hey folks, a question. We have a table that's getting large (6 million rows
right now, but hey, no end in sight). It's wide-ish, too, 98 columns.
The problem is that each of these columns needs to be searchable quickly at
an application level, and I'm far too responsible an individual to put 98
On Thu, Aug 16, 2012 at 3:54 PM, Wells Oliver wellsoli...@gmail.com wrote:
Hey folks, a question. We have a table that's getting large (6 million rows
right now, but hey, no end in sight). It's wide-ish, too, 98 columns.
The problem is that each of these columns needs to be searchable quickly
Hi Toby,
If you install Ubuntu, you can just install postgresql with the
package management software.
$ apt-get install postgresql
thanks for your reply. I should have mentioned that I was using the
Ångström Distribution where postgresql is not provided via package
manager. I wonder how did
Hi,
On 17 August 2012 07:14, Tomas Hlavaty t...@logand.com wrote:
thanks for your reply. I should have mentioned that I was using the
Ångström Distribution where postgresql is not provided via package
manager. I wonder how did the Ubuntu guys managed to overcome the
insufficient memory
21 matches
Mail list logo