| 552 |258460 |
2007-06-29| foobing
999 | 552 |258460 |
2007-06-29| foobing
Which is the most recent transaction update.
-jason
Jason L. Buberel wrote:
I now have a working xlogdump, which has allowed me to put together
the following
emove from pg_xlog all of the log files containing transactions that
come after the selected xid?
- Other?
-jason
Tom Lane wrote:
"Jason L. Buberel" <[EMAIL PROTECTED]> writes:
## stopped and started postgres, following syslog output:
You seem to have omitted all the inte
7; is and instead to step back to the selected xid and make
that the new version of 'now'?
-jason
Jason L. Buberel wrote:
I am now learning that fact, but recall the original scenario that I
am trying to mimic:
1. Person accidentally deletes contents of important table.
2. Admin (me) w
to effectively
'roll back' the database state to what it was just prior to the accident.
Thanks again for all the helpful comments and clarifications. I am now a
more clueful person as a result ;)
-jason
Erik Jones wrote:
On Jul 2, 2007, at 11:58 PM, Jason L. Buberel wrote:
I am no
ar - is there
any other tricks I can or should be using to speed up my bulk data loading?
Thanks,
jason
1.2M records into an indexed table:
- pg_bulkload: 5m 29s
- copy to: 53m 20s
These results were obtained using pg-8.2.4 with pg_bulkload-2.2.0.
-jason
hubert depesz lubaczewski wrote:
On Mon, Sep 10, 2007 at 05:06:35PM -0700, Jason L. Buberel wrote:
I am considering moving to date-based
t; '2007-01-01' ) to '/tmp/bar.out';
...that would lead me to use one method vs. the other on large data sets
(1M+ records)?
Just wondering,
Jason
The index looks like this:
# \d city_summary_pkey
Index "public.city_summary_pkey"
Column | Type
+-
date | text
state | text
city_master_id | bigint
zip_master_id | integer
res_type_master_id | bigint
to 'force' postgres to
treat the jasper report parameter as a number and not text, thereby
allowing the correct index to be used:
select * from city summary where city_master_id =
$P{city_master_id}::bigint ...
Query times went from 300+ seconds back down to ~100ms.
-jason
Tom
more
appropriate.
If I figure something out, I'll post to the list.
Regards,
jason
Tom Lane wrote:
Hmm ... if Postgres were just given the parameter symbol with no type
information, I believe it would have assumed it was bigint (or in
general, the same type as what it's being compared
mplish
this, if possible.
Thanks,
Jason
A4' and fill it with 256k zeros. Is there a quick and
easy linux-way of creating such a beast?
-jason
And thank you to Kevin - this did the trick perfectly. I've been able to
recover everything successfully.
Regards,
Jason
Kevin Hunter wrote:
The tool is 'dd' and /dev. /dev/zero in this case. The summary of what
you asked:
$ dd if=/dev/zero of=./zblah count=1 bs=256k
1+0
returns no results.
Any quick syntax fix for this?
Thanks
Jason
template_id | bigint|
Indexes:
"rs_pkey" PRIMARY KEY, btree (report_specification_id)
"fki_rs_rt_fkey" btree (report_template_id)
Regards,
Jason
Tom Lane wrote:
[EMAIL PROTECTED] writes:
Seems as though I've gotten myself into something of a pickle:
it.
Later,
Jason C. Wells
---(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
ome confirmation that wasn't some
mirror problem. I'll have to dig deeper on my end.
Thanks!
Jason C. Wells
---(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
--On Saturday, November 20, 2004 7:13 PM -0700 Scott Marlowe
<[EMAIL PROTECTED]> wrote:
Maybe your hard drive is filling up?
I had not thought of that. Thankfully, I don't have to admit to that much
silliness. I have plenty of space.
Later,
Jason C. Wells
---
in terms of postgres? if this has an
answer
Have you considered something other than linux? Try FreeBSD. I think one
of FreeBSD's active developers is also a PostgreSQL developer. (Fournier
IIRC) FreeBSD is great software and it shares the BSD license with
PostgreSQL.
Later
hi,
Why not put pg_hba.conf in a pg table? Seems like it would be much
easier to work with. After all, if we can keep users in the db
tables, why not this?
Thanks,
J.
--
Jason C. Leach
PGP Key: 0x62DDDF75
Keyserver: gpg.mit.edu
=0 -DFMC_DRA=0 -DFMC_HCI=1 -DFMC_PFM=0 -DFMC_RMS=0 -DFMC_UCD=1
-DFMC_EAA=1 -DFCI_TCP=1 -DFCI_UDP=1 -DFCI_UDG=1 -DFCI_TSS=0 -DFCI_LWS=0
-I- -I. -I/usr/local/include/ucd-snmp -I/usr/local/include -I/usr/include
-I/usr/include/pgsql -I/home/jalburger/opt/hadds/src/hdr -I/usr/include
DbPg_cre_sect_buf.pgc
>I think you should omit the word "RELEASE" after the
> "ROLLBACK".
Will this still result in the closed DB connection that the "ROLLBACK
RELEASE" used to give me?
Jason Alburger
HID/NAS/LAN Engineer
L3/ATO-E En Route Peripheral Systems Support
609-4
is (don't just assume it will be the OID).
J.-- .... Jason C. Leach PGP Key: 0x62DDDF75 Keyserver:
gpg.mit.edu
is that a closed
list?
I need to access PostgreSQL data from FileMaker Pro (which is what
X-Base would look like if Mac heads thought it up, except it has
ODBC support).
-Jason M. Felice
([EMAIL PROTECTED])
date field? I hope the answer isn't too
obvious. I did do some looking into this, but I'm fairly new to Postgres.
Thanks in advance for the help.
Jason
regards, tom lane
Thanks again for all the work on PostgreSQL.
Jason
e <--|
or--->php
DB2/Oracle in the future
Thank you
--
Jason J. Czerak ([EMAIL PROTECTED])
Linux Systems Evangelist
Jasnik Services, LLC
http://www.Jasnik.net
e talked about before :)
ohh and the size of hte DB is now 14megs.
-- Jason
kinda ppl that are 2 lazy to
set up their clients correctly to omit mailing lists.
--
Jason J. Czerak ([EMAIL PROTECTED])
Linux Systems Evangelist
Jasnik Services, LLC
http://www.Jasnik.net
ut the one you want to remove
INTO TABLE new_table
FROM old_table;
DROP TABLE old_table;
ALTER TABLE new_table RENAME TO old_table;
Thank you,
Jason C. Wells
ependent on how many requests you server will need to deal with. On
equal machines, could pg handle more or less requests that MS SQL?
Thanks,
Jason
--
.
. Jason C. Leach
.. University College of the Cariboo
... [EMAIL PROTECTED]
.. http://www.ocis.net/~jcl
.
The Search
hi,
I'm wondering if I can set a trigger or stored procedure that will run a
perl script?
Thanks,
Jason.
--
.
. Jason C. Leach
.. University College of the Cariboo
... [EMAIL PROTECTED]
.. http://www.ocis.net/~jcl
.
The Search for Extraterrestrial Intelligence
il
arrives?
Thanks,
Jason
--
.
. Jason C. Leach
.. University College of the Cariboo
... [EMAIL PROTECTED]
.. http://www.ocis.net/~jcl
.
Debain!Linux!
How can I fix my
sequence?
Thank You, | http://students.washington.edu/jcwells/
Jason Wells
info to a Perl script to stick in in the DB.
Anyone know of such a script? Or an example I can work with?
Thanks
Jason
--
.
. Jason C. Leach
.. University College of the Cariboo
... [EMAIL PROTECTED]
.. http://www.ocis.net/~jcl
.
Debian!Linux!
On Sat, 4 Dec 1999, Ross J. Reedstrom wrote:
>Jason -
>Jesse's sugestion should work, but there's a setval() function for
>this exact use:
>
>SELECT setval('people_id_seq',44);
>
>I usually use it like this:
>
>SELECT setval('"Experiment
hi,
Is PG done in C or C++?
--
.
. Jason C. Leach
.. University College of the Cariboo
... [EMAIL PROTECTED]
.. http://www.ocis.net/~jcl
.
Debian!Linux!
hi,
That looks promising. Any idea where the mail reformatted 'formail' gets
the input email? From STDIN?
J
Ed Loehr wrote:
> "Jason C. Leach" wrote:
>
> > :0
> * ^Subject:.*Digest
> |formail +1 -d -s procmail
>
> This sounds like a
omething obvious in the documentation that I missed,
but I'm not much of a database guru, and am relatively new to pgsql in general.
Jason Antman
PS - The slightly-less-abstract explanation:
We're spinning up nearly 100 (maybe 150) new test environments. We simply don't
have th
databases?
Thanks,
Jason
On 02/13/2014 04:41 PM, Antman, Jason (CMG-Atlanta) wrote:
I have a bunch of test/development databases which we currently refresh with
production data as-needed using a NetApp filer's snapshot capabilities - we
have a production slave with its datadir on a filer m
postgres supports balooning of memory?
Thanks,
Jason
On 02/15/2014 01:20 PM, Tom Lane wrote:
> "Antman, Jason (CMG-Atlanta)" writes:
>> Perhaps there's a postgres internals expert around, someone intimitely
>> familiar with pg_xlog/pg_clog/pg_control, who can comment o
On 02/15/2014 01:22 PM, John R Pierce wrote:
> On 2/15/2014 10:15 AM, Antman, Jason (CMG-Atlanta) wrote:
>> I also asked this question on dba.stackexchange.com, where it
>> received a very detailed enumeration of the associated problems from
>> Craig Ringer:
>> h
On 02/15/2014 02:00 PM, Francisco Olarte wrote:
> Hi:
>
> On Sat, Feb 15, 2014 at 7:31 PM, Antman, Jason (CMG-Atlanta)
> wrote:
>> Well thanks for someone at least sending a reply, though I suppose I
>> should have asked "how do I do this", or "what are the
of documentation or best practices for running multiple
postgres instances on the same host, and how to maximize resource
sharing between them?
Thanks,
Jason
On 02/15/2014 04:26 PM, Adrian Klaver wrote:
> On 02/15/2014 10:31 AM, Antman, Jason (CMG-Atlanta) wrote:
>> Well thanks fo
On 02/15/2014 05:27 PM, Karsten Hilbert wrote:
> On Sat, Feb 15, 2014 at 10:17:05PM +, Antman, Jason (CMG-Atlanta) wrote:
>
>> [...] I see how my original "brilliant" idea
>> (multiple DBs per postgres instance on one host, [...]) is insane,
>> without some sp
On 02/15/2014 04:55 PM, Antman, Jason (CMG-Atlanta) wrote:
> On 02/15/2014 02:00 PM, Francisco Olarte wrote:
>>
>> If I NEEDED to be able to provide 100-150 snapshots to test/dev
>> environments 20% of which maybe active, I'll setup a cluster, buy
>> somewhere above
", then something's amiss and the
backup won't be clean (error in shutdown, etc.)
5) `sync`
6) now take the backup
-Jason
On 02/17/2014 08:32 AM, Jürgen Fuchsberger wrote:
> Hi all,
>
> I have a master-slave configuration running the master with WAL
> archiving enable
re that we use an intermediate host for this. i.e. we stop a
slave, copy PGDATA *and* ALL WAL files over to another machine, start
the slave back up, and then do the recovery to a consistent state there,
to end up with a standalone PGDATA directory that can be copied wherever
we need it wi
On 03/12/2014 01:13 PM, bobJobS wrote:
> Understood and I agree.
>
> I will check to see how much contact detail I can divulge in an open forum.
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/High-Level-Committers-Wanted-tp5795695p
ething in postgres that sends detailed, well-structured log messages
to a message queue than put the alerting logic in it (syslog works with
everything, but it's so horribly obsolete).
-Jason
On 04/05/14 11:47, Andy Colson wrote:
> Hi All.
>
> I've started using replication, an
301 - 350 of 350 matches
Mail list logo
