columns.
>
> Surely this has been done thousands of times. What are the thoughts
> regarding best practices in PG?
I handle this using middleware outside the db. Past revisions of a
record (from any table I want to track) are serialized into a JSON
format and stored in a single table. Postgres
urt to think I may have to turn off
auto-commit and manually commit transactions all throughout my code :(
Still hoping it's a pgpool setup issue, since it's my first time
setting it up and all.
Thanks.
--
Greg Donald
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
Wow.. so now I'm doing it wrong?
I'll pass, thanks for all your "help" guys. It's been a blast.
--
Greg Donald
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
anything.
Those grep calls prove my old backups with 8.4 pg_dump were good to go
and now they are not with 9.1 pg_dump.
> I remain unclear as to what state is actually in the
> database, or what is being dumped,
The whole thing is being dumped. One command /usr/bin/pg_dump cp,
that'
On Wed, Dec 28, 2011 at 4:58 PM, Adrian Klaver wrote:
> What is the pg_dump command, with options, you are using?
My backup shell script contains:
/usr/bin/pg_dump cp | bzip2 > $FILE
--
Greg Donald
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
sequences of the same names in different schemas.
I have one schema and one database on that one database server.
And like I said, it worked fine until 9.1. If it was any of those
reasons you suggest, would I not have experienced the same problem
back in 8.4? I would think so.
--
Greg Dona
On Wed, Dec 28, 2011 at 1:00 PM, Tom Lane wrote:
> Greg Donald writes:
>>> Are you
>>> sure that the sequence is being used to insert those values into the
>>> table?
>
>> When I insert a new row into either of the tables I previously
>> described, t
rticular bug report form.
I may try that version tonight, I actually found 9.1.2 packages
http://www.openscg.org/se/postgresql/packages.jsp
Maybe my fix will be in there.
--
Greg Donald
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
id) FROM table_name);
to fix things up for me on my local setup.
--
Greg Donald
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
back this morning and pulled older backups, from when I was
using pg_dump that came with my PostgreSQL 8.4 install. Those backups
look fine to me, all the setval() calls are there and correct. So it
looks like a problem with the new pg_dump best I can tell.
--
Greg Donald
--
Sent via pgsql
alls in my SQL
file have a '1', like this:
SELECT pg_catalog.setval('company_id_seq', 1, false);
Some do not have a '1', some are actually set correctly.
Thanks.
--
Greg Donald
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
Tom Lane's post from '06 about how 'sequences are
black boxes', but not much else turned up.
Surely I don't have to maintain a separate sequence fix-up script to
keep with my backups, do I?
Thanks.
--
Greg Donald
--
Sent via pgsql-general mailing list (pgsql-genera
r php + some
> Typo3 extension.
>
> Does anyone know of a howto that explains what
> software I'll need for that, and where to get it?
>
> Does anyone here have experience with Typo3+Postgresql that he might
> want to share?
Typo uses migrations, so it should be database a
On Wed, 15 Sep 2004 12:55:24 -0400, Jean-Luc Lachance
<[EMAIL PROTECTED]> wrote:
> Add :
>
> AND count(user_tasks.task_id) > 0 in the where clause.
I get the error:
aggregates not allowed in WHERE clause
--
Greg Donald
http://gdconsultants.com/
h
producing the error?
TIA..
--
Greg Donald
http://gdconsultants.com/
http://destiney.com/
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
I'm thinking of getting this book and was wondering if anyone had
anything bad (or good) to say about it? More than that I'd really
like to know what version of Postgres it covers, the sample pages
don't seem to say.
http://tinyurl.com/5xtpp
TIA..
--
Greg Donald
http
rop old column?
--
Greg Donald
http://destiney.com/
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
t to migrate PHPBB running on a server with mySQL to
> another server running with postgreSQL). Yes PHPBB has postgreSQL
> support.
I found this utility very helpful in a similar situation:
http://freshmeat.net/projects/my2pg/
--
Greg Donald
---(end of broadc
Is it legal syntax to use <> instead of != in a Postgres query?
I didn't see it listed on:
http://www.postgresql.org/docs/7.4/static/sql-syntax.html
but wanted to ask to make sure.
--
Greg Donald
---(end of broadcast)---
TIP 3:
ovide a way for you to add unstable
packages using ACCEPT_KEYWORDS="~x86". I never used the command because
I never _wanted_ unstable packages. Seems I got them anyway.
--
Greg Donald
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
worth the headaches to me personally.
For stability, db/web server usage and such, I'd go with Debian.
For features, desktop systems, etc., I'd go with Suse. 9.1 is
impressive.
For security, firewall, or router usage, I'd go with *BSD.
--
Greg Donald
---
21 matches
Mail list logo
