Hi,
I'm trying to set up a replica for a postgres 9.3 instance running on an
older i386 debian install, replicating to a 64 bit install.
Having enabled multi-arch** support on the 64 bit debian by running:
dpkg --add-architecture i386
and trying to install:
apt-get install
On Sun, 2014-11-30 at 15:17 +0400, Damian Dimmich wrote:
Hi,
I'm trying to set up a replica for a postgres 9.3 instance running on
an older i386 debian install, replicating to a 64 bit install.
Having enabled multi-arch** support on the 64 bit debian by running:
dpkg
On Sat, 29 Nov 2014 15:27:07 -0500
Benjamin Rutt rut...@osu.edu wrote:
I run autovacuum under
a default configuration, but I suspect ANALYZE is not running frequently
enough for my purposes (when I ran the above command on my table, it
consistently returned 1.4 million for ~20 minutes
On 11/30/2014 06:55 AM, Vincent Veyron wrote:
On Sat, 29 Nov 2014 15:27:07 -0500
Benjamin Rutt rut...@osu.edu wrote:
I run autovacuum under
a default configuration, but I suspect ANALYZE is not running frequently
enough for my purposes (when I ran the above command on my table, it
consistently
Hi Rob,
Thank you for your response:
cat /var/lib/dpkg/arch
gives:
amd64
i386
I did update after adding i386- I don't think it would have found
postgresql-9.3:i386 otherwise.
Further reading indicates that packages can explicitly support
multi-arch and permit (some) dependent packages to
Hello and thank you for reading my post.
I would like to write a C/C++ program which targets a remote PostgreSQL
database.
I don't know what to install, which libraries to link to in this program.
In more details:
Given:
1.1) a PostgreSQL database db on a machine A,
1.2) a machine B.
I would
Me again. Sorry.
This looks good too: Building libpq Programs:
http://www.postgresql.org/docs/9.1/static/libpq-build.html
But what do I need to install on B?
Best regards.
--
View this message in context:
I'm using JSON_AGG to create some arrays, but I get an invalid json (I'm
using the latest postgres 9.4 in debian testing).
Quick explanation: I've got some objects called Things that have Tags
(many-to-many through the table ThingTag); Things also have a single
ThingTemplate, which has
On 11/30/2014 11:44 AM, Léa Massiot wrote:
Hello and thank you for reading my post.
I would like to write a C/C++ program which targets a remote PostgreSQL
database.
I don't know what to install, which libraries to link to in this program.
In more details:
Given:
1.1) a PostgreSQL database db
Hi,
I am have a problem when I format a timestamp in that it is changing the
year. This can't be right, so either I don't understand or I have found
a nasty corner case bug.
This does not happen on all dates
select '2014-12-31 00:00:00'::timestamp without time zone,
On 11/30/2014 01:05 PM, Stephen Woodbridge wrote:
Hi,
I am have a problem when I format a timestamp in that it is changing the
year. This can't be right, so either I don't understand or I have found
a nasty corner case bug.
This does not happen on all dates
select '2014-12-31
On Nov 30, 2014, at 1:05 PM, Stephen Woodbridge wood...@swoodbridge.com wrote:
Hi,
I am have a problem when I format a timestamp in that it is changing the
year. This can't be right, so either I don't understand
You're using IYYY which is the ISO year, which is based on Mondays or
Thank you for your answer :)
Adrian Klaver-4 wrote:
My guess is you want is way to install the minimum necessary to write a
C/C++ file against the Postgres libraries.
Is this correct?
Exactly.
Adrian Klaver-4 wrote:
If so you will need to either install the appropriate -dev package,
Hi Adrain,
Thank you for the explanation. I was trying to send some data to a
Javascript library worked with ISO dates. But you are correct I wanted
not IYYY, that totally sliped by me.
Thanks,
-Steve
On 11/30/2014 4:19 PM, Adrian Klaver wrote:
On 11/30/2014 01:05 PM, Stephen
On 11/30/2014 2:03 PM, Léa Massiot wrote:
I actually asked the question out of curiosity.
(And also because I was working on a machine with no PostgreSQL installed. I
was wondering if I had to install a whole PostgreSQL system or not).
In the RH/CentOS/Fedora world, you CAN install just the
Davide S swept.along.by.eve...@gmail.com writes:
Note that the tags are just fine, but the arrays with the states have an
increasing number of square brackets at the end: the first has 1 (correct),
the second has 2, the third has 3, etc., which is invalid json.
Could you provide a
Hello,
I have a simple database with just a few tables that runs on an embedded Linux
system 2.6.31.8. The OS including postresql 8.4 is loaded directly from
cf-flash media and is not saved in any way across power recycles. It is always
created at startup from the /inittab/rc script and nearly
17 matches
Mail list logo
