nsive for COPY's goal in life.
Maybe the best approach is to switch to a batched insert, which might be
fast enough for my needs.
Thanks for the suggestions!
--
Steve Wampler -- swamp...@noao.edu
The gods that smiled on your birth are now laughing out loud.
--
This mail was scanned by a tri
On 10/16/2014 09:42 AM, Rob Sargent wrote:
On 10/16/2014 10:33 AM, Steve Wampler wrote:
This is with Postgresql 9.3.5.
I'm looking at using a COPY command (via jdbc) to do bulk inserts into a table
that
includes a BIGSERIAL column. Is there a way to mark the data in that
column so it
umn on rows that have one already.
Thanks!
Steve
--
Steve Wampler -- swamp...@noao.edu
The gods that smiled on your birth are now laughing out loud.
--
This mail was scanned by a trial version of BitDefender
For more information please visit http://www.bitdefender.com/
--
Sent via pgsql-general ma
#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
(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;? 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
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
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
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
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
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).
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:
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
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
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
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
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
---
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
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
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
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
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
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.
---
\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
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
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
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
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
)
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
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
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
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
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
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
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
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
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
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
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
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]
-
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
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
42 matches
Mail list logo
