On 10/8/14, 2:24 PM, Israel Brewster wrote:
Agreed. and no, I don't need all the data. But pg_dump doesn't give me an
option to, say, only grab the last week of data.
You might want to check out pg_sample. It lets you get a referentially
consistent sample of a database. You specify the
.
Thanks for any insight!
Jeff Ross
On 1/17/14, 11:02 AM, Tom Lane wrote:
Jeff Ross jr...@openvistas.net writes:
I had to move our production database to a new server with virtually
identical hardware. At the same time I went to 9.3.2 from 9.3.
Queries on the old server (nirvana) run many magnitudes faster than on
the new server
On 11/6/13, 12:26 PM, Jeff Ross wrote:
On 11/6/13, 11:32 AM, Jeff Janes wrote:
On Wed, Nov 6, 2013 at 9:40 AM, Jeff Ross jr...@wykids.org
mailto:jr...@wykids.org wrote:
_postgresql@nirvana:/var/postgresql $ cat start_hot_standby.sh
#!/bin/sh
backup_label=wykids_`date +%Y-%m-%d
checkpoint record
2013-11-06 07:50:23.495858500 % LOG: invalid secondary checkpoint record
2013-11-06 07:50:23.495862500 % PANIC: could not locate a valid
checkpoint record
I'm sure I'm missing something simple here, but I'm not seeing what it is.
Thanks!
Jeff Ross
--
Sent via pgsql-general
On 11/6/13, 11:32 AM, Jeff Janes wrote:
On Wed, Nov 6, 2013 at 9:40 AM, Jeff Ross jr...@wykids.org
mailto:jr...@wykids.org wrote:
_postgresql@nirvana:/var/postgresql $ cat start_hot_standby.sh
#!/bin/sh
backup_label=wykids_`date +%Y-%m-%d`
#remove any existing wal files
Maybe some of these folks can chime in?
http://cds.u-strasbg.fr/
Simbad (and I think VisieR) runs on PostgreSQL. A friend of mine is a
grad student in astronomy and he told me about them.
Jeff Ross
On 10/1/13 3:49 PM, Mark Jones wrote:
Hi all,
We are currently working with a customer who
Hi,
I'm having a hard time figuring out how to use split_part with a
carriage return (hex 0a) as the delimiter.
Would someone please offer me a clue?
Thanks!
Jeff Ross
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
On 11/19/12 12:58, Tom Lane wrote:
Jeff Ross jr...@wykids.org writes:
Hi,
I'm having a hard time figuring out how to use split_part with a
carriage return (hex 0a) as the delimiter.
Um, 0x0a is line feed last I checked. But you should be able to write
the literal as E'\r' (if you wanted CR
On 7/10/12 8:39 PM, Adrian Klaver wrote:
On 07/10/2012 07:30 PM, Jeff Ross wrote:
On 7/10/12 6:21 PM, Adrian Klaver wrote:
On 07/10/2012 01:06 PM, Jeff Ross wrote:
Hi all,
Thanks for any and all ideas!
For your initial attempt everything was done in one session?
All the inserts were
On 7/11/12 2:07 PM, Adrian Klaver wrote:
On 07/11/2012 07:01 AM, Jeff Ross wrote:
On 7/10/12 8:39 PM, Adrian Klaver wrote:
On 07/10/2012 07:30 PM, Jeff Ross wrote:
On 7/10/12 6:21 PM, Adrian Klaver wrote:
On 07/10/2012 01:06 PM, Jeff Ross wrote:
Hi all,
Thanks for any and all ideas
On 7/11/12 3:52 PM, Adrian Klaver wrote:
On 07/11/2012 02:41 PM, Jeff Ross wrote:
On 7/11/12 2:07 PM, Adrian Klaver wrote:
On 07/11/2012 07:01 AM, Jeff Ross wrote:
On 7/10/12 8:39 PM, Adrian Klaver wrote:
On 07/10/2012 07:30 PM, Jeff Ross wrote:
On 7/10/12 6:21 PM, Adrian Klaver wrote
On 7/11/12 4:24 PM, Marcin Mańk wrote:
On Tue, Jul 10, 2012 at 10:06 PM, Jeff Ross jr...@wykids.org
mailto:jr...@wykids.org wrote:
2012-06-19 15:37:36.283752500 www%wykids LOG: statement: update
survey_response set srv_resp_submitted = now() where
srv_resp_srv_id = 2
On 7/11/12 5:13 PM, Adrian Klaver wrote:
On 07/11/2012 04:02 PM, Jeff Ross wrote:
On 7/11/12 3:52 PM, Adrian Klaver wrote:
Is there an index on this table?
If so have you tried a REINDEX?
Here's the table definition:
jross@nirvana:/home/jross $ psql wykids
psql (9.1.4, server 9.1.3
) that this is some sort of hardware
problem as I see no indication of that anywhere else.
Thanks for any and all ideas!
Jeff Ross
Wyoming Children's Action Alliance
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
On 7/10/12 6:21 PM, Adrian Klaver wrote:
On 07/10/2012 01:06 PM, Jeff Ross wrote:
Hi all,
I have an anomaly on my hands that I'm at a loss to understand.
We recently ran a small survey where participants were required to
answer all the questions. After validation for skipped questions,
mis
On 08/30/11 18:03, Fujii Masao wrote:
On Wed, Aug 31, 2011 at 5:51 AM, Jeff Rossjr...@wykids.org wrote:
Is there a setting in this or something else that I should tweak so this
query can complete against the replica? Google turned up some threads on
the error code associated with the error
.
Thanks,
Jeff Ross
Wyoming Children's Action Alliance
Cheyenne, Wyoming
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 02/01/11 08:55, Herouth Maoz wrote:
As a result of my recent encounter with table bloat and other tuning issues
I've been running into, I'm looking for a good resource for improving my tuning
skills.
My sysadmin ran into the following book:
PostgreSQL 9.0 High Performance, by Gregory
it yet.
Thanks,
Jeff Ross
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 01/31/11 17:13, Tom Lane wrote:
Jeff Rossjr...@wykids.org writes:
In the meantime, I now have 242 16MB files in pg_xlog/. The
archive_status directory in pg_xlog/has a matching .done file for all
but the most recent of those pg_xlog files.
What have you got checkpoint_segments set to?
and shows me some, um, interesting things in my database that probably
need addressing.
Warm regards from snowy Wyoming!
Jeff Ross
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Stratum doesn't work and you (or anyone else
for that matter) would like my slightly modified version let me know off
list and I'll get it to you.
Jeff Ross
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
On 10/04/10 15:55, Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
This is more of an odd anoyance than anything, but for the past month or
so when I \q out of psql I have to wait 20-25 seconds for the return to
the shell prompt. This is the only copy of psql
On 10/05/10 10:35, Tom Lane wrote:
Jeff Rossjr...@wykids.org writes:
Thanks for the hint, Greg! It was indeed the .psql_history file.
Although I'm using the default history size, the file was over 5MB in
size and full of a table dump. I truncated the file and no more delay
quitting psql.
and
primarily PostgreSQL is powering Drupal.
Searching Google turned up nothing. I can live with it but I'd be more
interested in fixing it.
Thanks!
Jeff Ross
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
)
In fact, every join combination (left|right|full|inner|outer) I've tried gives
me the same result.
Clearly I'm missing something obvious and will welcome all hints,
clue-by-fours and so on.
Thanks,
Jeff Ross
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Tom Lane wrote:
Jeff Ross jr...@wykids.org writes:
To get the output I want above, I'd think I'd need to do a left outer join
like this:
jr...@wykids localhost# select ed_cat_name as Level, pp_ed_cat_subject as
Subject, pp_ed_cat_institution as Institution from
education_categories left
staring at it so long
now I can't see the forest for the trees.
Thanks!
Jeff Ross
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 04/25/10 12:32, Tom Lane wrote:
Jeff Rossjr...@wykids.org writes:
I'm trying to write my first plpgsql function and I'm running into a
problem that may or may not have to do with a coalesce statement.
No, it's not the coalesce ...
When I try to run this I get the following error:
On 04/25/10 14:20, Tom Lane wrote:
Jeff Rossjr...@wykids.org writes:
Now I'm *really* confused. I thought the table structure I created at
the beginning of the function was where the results would be returned
to.
Uh, you're using that as the destination for the FOR loop's SELECT.
What
...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jeff Ross
Sent: Thursday, March 11, 2010 11:37 AM
To: PostgreSQL
Subject: [GENERAL] Joining one-to-one and one-to-many tables
I'm stumped about the best was to retrieve the most recent entry in a
one-to-many type of table and combine
become important for me to get because more and more we are
moving to keeping things in the history type of table so we can keep a
progression of events.
Cluesticks or links welcome!
Thanks!
Jeff Ross
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Greg Smith wrote:
Jeff Ross wrote:
I think I'm doing it right. Here's the whole script. I run it from
another server on the lan.
That looks basically sane--your description was wrong, not your
program, which is always better than the other way around.
Note that everything your script
Greg Smith wrote:
Jeff Ross wrote:
pgbench is run with this:
pgbench -h varley.openvistas.net -U _postgresql -t 2 -c $SCALE
pgbench
with scale starting at 10 and then incrementing by 10. I call it
three times for each scale. I've turned on logging to 'all' to try
and help figure out
kernel will not run on this particular server. I think that means that I'm going to be shopping for an Opteron based server before long.
Thanks to all!
Jeff Ross
ErrorContext: 8192 total in 1 blocks; 8176
free (6 chunks); 16 used
2010-01-27 14:07:26.327874500
172.16.0.1(22842):_postgre...@pgbench:[17225]:ERROR: out of memory
2010-01-27 14:07:26.327881500
172.16.0.1(22842):_postgre...@pgbench:[17225]:DETAIL: Failed on request of
size 67108864.
Jeff
Tom Lane wrote:
Jeff Ross jr...@wykids.org writes:
Running a simple select only pgbench test against it will fail with an out of
memory error as it tries to vacuum --analyze the newly created database with
750 tuples.
Better look at the ulimit values the postmaster is started with;
you
,
Jeff Ross
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Greg Stark wrote:
On Sun, Aug 23, 2009 at 4:06 AM, Jeff Rossjr...@wykids.org wrote:
Greg Stark wrote:
Actually, I wonder if this isn't more likely to show the problem -- it
would explain why *all* your tables are showing up with duplicates
rather than just one.
select
Greg Stark wrote:
On Sun, Aug 23, 2009 at 2:18 PM, Jeff Rossjr...@wykids.org wrote:
I had to modify your query slightly to make it run--hope I got what you are
after!
select (h).* from (select
heap_page_items(get_raw_page('pg_namespace',0)) as h) as x;
Greg Stark wrote:
On Sun, Aug 23, 2009 at 5:02 PM, Greg Starkgsst...@mit.edu wrote:
On Sun, Aug 23, 2009 at 2:18 PM, Jeff Rossjr...@wykids.org wrote:
Incidentally, may as well ask the usual questions:
And just for reference, what does pg_controldata print?
Greg Stark wrote:
On Sun, Aug 23, 2009 at 5:37 PM, Jeff Rossjr...@wykids.org wrote:
pg_clog is 32K. �I've put it at http://www.openvistas.net/pg_clog
Sorry, I'm getting a 404
Oops--fixed now.
Jeff
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Tom Lane wrote:
Greg Stark gsst...@mit.edu writes:
On Sun, Aug 23, 2009 at 7:34 PM, Tom Lanet...@sss.pgh.pa.us wrote:
Urgh. I bet that's where the problem is then. Some path is failing
to clear that bit, or maybe there's a race condition that allows it
to become set incorrectly (ie
Tom Lane wrote:
Jeff Ross jr...@wykids.org writes:
Tom Lane wrote:
heap_update is broken. Details left as an exercise for the reader
Well, as the reader that started this all ;-) should I be worried?
Should I do a pg_dump and reinstall? Roll back to 8.3.7? Or just
is running OpenBSD -current.
Thanks,
Jeff Ross
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Greg Stark wrote:
On Sat, Aug 22, 2009 at 9:31 PM, Jeff Rossjr...@wykids.org wrote:
Hi,
I recently upgraded to 8.4 and everything went great. �All databases are
working as they are supposed to, no problems seen.
Today, however, I did a \d on a database and was surprised to see sets of 5
Greg Stark wrote:
On Sat, Aug 22, 2009 at 9:31 PM, Jeff Rossjr...@wykids.org wrote:
I browsed through the system catalogs but haven't found anything yet that
can shine some light on this.
Actually, I wonder if this isn't more likely to show the problem -- it
would explain why *all*
from test, people where test.person_id = people.person_id
union all
select
null as person_id,
null as service_id,
null as name,
null as address,
null as price_serv,
sum(price_serv) as total
from test;
Hope that helps,
Jeff Ross
--
Sent via
Joao Ferreira gmail wrote:
Hello all,
I need to print to a file a simple list of all the databases on my
postgresql.
I need to do this from a shell script to be executed without human
intervention
I guess something like:
su postgres -c 'psql ...whatever /tmp/my_databases.txt'
but I
Jeff Davis wrote:
On Tue, 2008-09-09 at 17:03 -0600, Jeff Ross wrote:
select
ts_date as Transcript Date,
ts_expiration_date as Current Expiration Date,
expiration_value as Expiration Interval
from transcript, training_expiration_value where
'expiration_value';
and I'm getting the following error:
ERROR: invalid input syntax for type interval: expiration_value
Is there a way to use the value in expiration_value for the interval?
Thanks,
Jeff Ross
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
of the SELECT must refer to this FROM
item as f not foo..
Does this apply in the WHERE clause as well? If it doesn't how can I
refer to the results of the case statements later in the where clause?
Thanks,
Jeff Ross
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Martijn van Oosterhout wrote:
On Wed, Aug 13, 2008 at 10:47:17AM -0600, Jeff Ross wrote:
I'm a little confused about how to use a column alias in the where
clause of a query. I'm sure the answer is something simple, but I
haven't found anything searching through Google or from reading
!
Jeff Ross
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Scott Marlowe wrote:
On 9/18/07, Jeff Ross [EMAIL PROTECTED] wrote:
I'm using copy to insert a bunch of rows into a new table with a unique
primary key. Copy is correctly incrementing the primary key, but
apparently the sequence itself is never updated because when I go to
insert again I get
pg_dumpall script runs
without a single error. The only difference that I can see is that this
third machine did not start with a freshly initialized database.
Thanks for any insights.
Jeff Ross
---(end of broadcast)---
TIP 9: In versions below
Tom Lane wrote:
Jeff Ross [EMAIL PROTECTED] writes:
When psql begins loading this file, it throws the error:
psql:/tmp/people.sql:79: ERROR: unrecognized node type: 655
Hmm. Can you try that with \set VERBOSITY verbose so we can determine
where the error is being thrown from?
Using
Tom Lane wrote:
Jeff Ross [EMAIL PROTECTED] writes:
Tom Lane wrote:
Hmm. Can you try that with \set VERBOSITY verbose so we can determine
where the error is being thrown from?
psql:/tmp/people.sql:79: ERROR: XX000: unrecognized node type: 655
LOCATION: _outValue, outfuncs.c:1707
Hmm
Robert Fitzpatrick wrote:
Can anyone suggest how one might be able to do this? I want to be able
to generate an 8 character random password for users in their password
field. Perhaps through the default setting of the field or a trigger
function. I found the following, but is there anything that
problems (it does fine until the backend goes away ;-) and
re-release it.
Thanks,
Jeff Ross
P.S. Apologies to the owner of the list--I inadvertently sent this to
the wrong address first.
---(end of broadcast)---
TIP 3: Have you checked our
Desire Athow wrote:
I am looking for a email list management solution (can be a script, an
open source application etc), which uses Postgre SQL (AKA Postgres) as
database.
Can you let me know whether this rare bird exist?
---(end of broadcast)---
Vivek Khera wrote:
On Feb 16, 2007, at 4:13 PM, Andrew Kirkness wrote:
I am currently setting up a website and have PostGreSQL database I'm
using for the backend. I'm researching an open source Content
Management System that uses PostGreSQL. Do you have any recommendations?
You need to
Tom Lane wrote:
Thanks for the reply, Tom.
Jeff Ross [EMAIL PROTECTED] writes:
This used to work before my upgrade to 8.2.1.
Which version were you using before?
8.1.x
The error the function now throws is:
jross%wykidsERROR: invalid regular expression: invalid
.
Any help would be greatly appreciated!
Jeff Ross
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through
65 matches
Mail list logo