atest(6.3, 2.8);
greatest
--
6.3
(1 row)
swampler=#
-----------
--
Steve Wampler -- [EMAIL PROTECTED]
The gods that smiled on your birth are now laughing out loud.
---(end of broadcast)---
T
Hugo wrote:
> Hi, is anybody using psql and CentOS, I just wanted to know your experience
Works just fine, though we're still on 7.4 and haven't tried the 8 series
yet. I don't expect any problems, however.
--
Steve Wampler -- [EMAIL PROTECTED]
The gods that smiled on
found are really for PG7, but they seem
to work alright with PG 8.1.x (after some trickery to get them
to install with and use libpq.so.4 instead of libpq.so.3).
Does anyone know if this version:
libpqxx-devel-2.6.9-1.el4.rf
libpqxx-2.6.9-1.el4.rf
will work with 8.2.4?
Thanks!
--
Steve Wampler
Steve Wampler wrote:
I'd like to update from 8.1.9 to 8.2.4 to take advantage of
the multiple value INSERT but don't see at least two of the
RPMs for 8.2.4 that I need.
>...
I need the Java and Python interfaces supplied with
(from 8.1.9):
postgresql-jdbc-8.1.4-1.centos.1
In our case, the partitioning would be simple list partitioning on
the values of an 'experiment id', so I'm not concerned about trying
to create a range-based WHERE clause in the new rule.
Thanks!
Steve
--
Steve Wampler -- [EMAIL PROTECTED]
The gods that smiled
Steve Wampler wrote:
... Specifically, I'm wondering if it's
possible to add a default rule that would create a new partition
(with indices, etc.) and would add a new rule for this partition
to match the similar ones above (and, of course, then move the
INSERT into the new partition).
his *isn't* a bottom-posted message - it just looks like one because
of the context editing!]
--
Steve Wampler -- [EMAIL PROTECTED]
The gods that smiled on your birth are now laughing out loud.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
rs on what I'm doing
wrong and what I can do to fix it?
Thanks!
Steve
--
Steve Wampler -- [EMAIL PROTECTED]
The gods that smiled on your birth are now laughing out loud.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the
Steve Wampler wrote:
I don't see any errors when starting with
"service postgresql start" - and if I empty out
/var/lib/pgsql, the command initializes the database
with no errors.
To add a bit more information, and correct the above.
I wasn't seeing any errors because PGLOG was
Tom Lane wrote:
Steve Wampler <[EMAIL PROTECTED]> writes:
I'm trying to install PG 7.4.6 (from Fedora rpms) and
keep getting stuck with psql refusing to do anything
useful.
Are you running with SELinux enforcement mode on? We've just isolated
some problems the
rce 0' before intializing database.
Ok to turn back on with '/usr/sbin/setenforce 1' afterwards.
Has to do with the Fedora using SELinux by default now.
Dunno if that is your situation...
--
Steve Wampler -- [EMAIL PROTECTED]
The gods that smiled on your birth are now laughing out
\q to quit
swampler=# \i tmp.sql
count
---
148
(1 row)
swampler=# \q
Have you tried a simple test (like the above)? I haven't upgraded to
8.0 yet because of some dependencies I have with patches on JDBC in
7.4.2, but I wouldn't have expected this to brea
e has some trigger functions attached to one of the tables), but
I have no clue what went wrong.
Any suggestions would be *most* welcome! [Correct ones even more so...]
Thanks!
Steve
--
Steve Wampler -- [EMAIL PROTECTED]
The gods that smiled on your birth are now laughing out loud.
---
Steve Wampler wrote:
I realize 7.2.4 is long in the tooth, but it's an old system that's been
running for several years now. Someday we'll upgrade...
However, part of the upgrade will involve dumping and restoring the
tables. I've just did a little playing with pg_dump on
Tom Lane wrote:
Steve Wampler <[EMAIL PROTECTED]> writes:
->gunzip
I see all the permission denied messages, but why? How can a user
create a dump that they cannot load back in (the user has createdb *and*
createuser permissions)?
Which part of "must be superuser" are you
---
45 21 * * * /u3/SolisDBbackups/fullDump.zsh
-----------
Hope this helps.
--
Steve Wampler -- [EMAIL PROTECTED]
The gods that smiled on your birth are now laughing out loud.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
un *before* actually dumping it.
I suppose:
pg_dump $PGD_OPTIONS | wc -c
isn't efficient enough, right? Without knowing the options you plan
to use with pg_dump (compression? dump just tables?, etc.) this is
going to be hard to get a decent estimate from...
--
Steve Wampler -- [EMAIL P
Andreas Kretschmer wrote:
> What about with Hermaphroditism?
More seriously - is the gender something you always know? There
are situations in the US where you cannot force someone to divulge
their gender. So you may need an 'unreported' value of some sort.
--
Steve Wamp
compiled for?
--
Steve Wampler -- [EMAIL PROTECTED]
The gods that smiled on your birth are now laughing out loud.
---(end of broadcast)---
TIP 6: explain analyze is your friend
devices low-down
in memory. I don't know if that's still an issue or not with 2.6 kernels,
but I could see it still being the case and, if so, seems like it would have
a significant impact on I/O bound tasks (like most DB processing...)
--
Steve Wampler -- [EMAIL PROTECTED]
The go
ore to move a 64-bit pointer around as a 32-bit
one. (Plus, I *think* you get more registers in 64-bit mode.)
However, a good optimizer might figure out it can move two 32-bit pointers
with one 64-bit transfer.
--
Steve Wampler -- [EMAIL PROTECTED]
The gods that smiled on your birth are n
x27;? This solution looks to me as though it might not get ,e.g., 'coast' and
'co.st' in
the desired order except by chance.
--
Steve Wampler -- [EMAIL PROTECTED]
The gods that smiled on your birth are now laughing out loud.
--
Sent via pgsql-general mailing list (pgsql-g
formationweek.com/software/showArticle.jhtml?articleID=180200853&subSection=Open+Source
--
Steve Wampler -- [EMAIL PROTECTED]
The gods that smiled on your birth are now laughing out loud.
---(end of broadcast)---
TIP 1: if posting/reading through
(eventTest.eventTest: [993])}
(10 rows)
--------
--
Steve Wampler -- swamp...@noao.edu
The gods that smiled on your birth are now laughing out loud.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
#x27;m better off with the
serial column in my case - just mildly curious).
--
Steve Wampler -- swamp...@noao.edu
The gods that smiled on your birth are now laughing out loud.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t it from the old one, which didn't
use 'ident' authority. It's working now.
Thanks again!!
--
Steve Wampler -- [EMAIL PROTECTED]
Quantum materiae materietur marmota monax si marmota
monax materiam possit materiari?
---(end of broadcas
LANGUAGE plpgsql HANDLER
plpgsql_call_handler;
but a system I recently upgraded to RH 9 RPMS doesn't seem to
have this library - and the www.postgresql.org search engines
don't find any references to plpgsql.so at all.
Is there some other library that now provides access to plpgsql
)
PG 7.3.4 generates a "pg_atoi: zero-length string" error
when '' can't be coerced to the column type. I understand
the reason for changing this behavior from 7.2...
Can anyone point me to a version of DBIx::SearchBuilder that
checks).
Will this still work with 7.1?
Thanks!
--
Steve Wampler- SOLIS Project, National Solar Observatory
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
nowing that the
options set in "postgresql.conf" have, indeed, been
applied. What's the easiest way to check this?
Thanks!
--
Steve Wampler- SOLIS Project, National Solar Observatory
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if p
ing in a "false positive" from the pidof operation.
I bumped the "sleep 2" up to "sleep 5" and the problem went away.
Surely there's a better fix?
--
Steve Wampler- SOLIS Project, National Solar Observatory
[EMAIL PROTECTED]
-
Tom Lane wrote:
>
> Steve Wampler <[EMAIL PROTECTED]> writes:
> > One of the listed bug fixes is:
> >Disallow INSERT/UPDATE/DELETE on views
> > Can some one give me a little insight on what this
> > implies?
>
> It means that if you try to do INS
Tom Lane wrote:
>
> Steve Wampler <[EMAIL PROTECTED]> writes:
> > Well, it looks like I got bit by this after all. Can someone show
> > me a rule to attach to a view ("attributes") to invoke a trigger function
> > (insert_or_update)?
>
> > Th
at-derived systems. (And then,
> only if you install PostgreSQL from the RPMs, which if you're using
> RedHat, you probably are).
Plus, the file is /etc/rc.d/init.d/postgresql under RedHat (at least
from the rpm-build.)
--
Steve Wampler- SOLIS Project, National Solar Observatory
[EMAIL P
is affected by that.
>
> JDK1.3.0_2 fixed that for me. When I moved from 7.0.3 to 7.1RC4 I
> changed the JDK. Read the JDK changelogs they mention something
I haven't seen a problem since switching from jdk1.3.0 to jdk1.3.1rc2,
either.
--
Steve Wampler- SO
without running pgsql (or equivalent), which
requires a running postmaster.
Thanks for any help!!
--
Steve Wampler- SOLIS Project, National Solar Observatory
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
Steve Wampler wrote:
>
> It looks as though the init.d script "postgres" supplied with
> 7.1.2 no longer propagates environment variables to pg_ctl. Was that
> an intentional change? Or is this something no one else sees?
>
> I put databases off on their own p
had to do was add:
export SOLISDB=.
into /etc/rc.d/init.d/postgres to use createdb --location SOLISDB
but I just noticed that this isn't working with 7.1.2. Instead, I
have to put the export directly into /usr/bin/pg_ctl - which I'm not
particularly fond of doing.
Thanks!
--
S
Trond Eivind Glomsrød wrote:
>
> Steve Wampler <[EMAIL PROTECTED]> writes:
>
> > It looks as though the init.d script "postgres" supplied with
> > 7.1.2 no longer propagates environment variables to pg_ctl. Was that
> > an intentional change? Or is
39 matches
Mail list logo