Hi Ondrej,
> You don't have to do all that stuff on beaglebone -- you need to setup
> toolchain and compiler for target architecture. This is usually
> distribution specific. (check this for your distribution:
> http://www.angstrom-distribution.org/toolchains/ )
thanks for the pointer, I'll look
Hi,
On 17 August 2012 07:14, Tomas Hlavaty 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 limitation?
You
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 d
On Thu, Aug 16, 2012 at 3:54 PM, Wells Oliver 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 at
> an applicatio
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
in
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 subscript
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
Jeff Janes 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 log-switch. 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
soon,
Hey aliosa
2012/8/16 aliosa
> 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
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 po
> 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 (pgsql-general@postgresql.or
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
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
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 was
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.
>
> ---
>
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 mayb
( 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 of
On Thu, Aug 16, 2012 at 11:11 AM, sayeed 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 streaming replication
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 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 (pgsql-gen
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. O
22 matches
Mail list logo
