2014-03-14 4:26 GMT+09:00 fburg...@radiantblue.com:
PostgreSQL 9.3.3 RHEL 6.4
Total db Server memory 64GB
(...)
effective_cache_size = 48MB
I'm not sure if this will help directly, but is the value for
'effective_cache_size' intentional? 48 *GB* would be a more likely
setting.
Regards
Ian
2014-03-12 12:00 GMT+09:00 Roy Anderson roy.ander...@gmail.com:
Good day. We are transitioning over one database to Postgres as a test but
retain an Oracle presence. The PG db in question is (it is currently still
running Oracle) feeds a couple other Oracle dbs via materialized view logs
and
2014-03-01 8:16 GMT+09:00 George Weaver gwea...@shaw.ca:
- Original Message - From: Steve Atkins
On Feb 28, 2014, at 2:43 PM, George Weaver gwea...@shaw.ca wrote:
Maybe this?
select regexp_replace('300 North 126th Street', '(\d+)(?:st|nd|rd|th)',
'\1', 'gi');
Hi Steve,
2014-03-01 9:34 GMT+09:00 Rich Shepard rshep...@appl-ecosys.com:
On Fri, 28 Feb 2014, Adrian Klaver wrote:
Well JET is the database engine for Access and mdb is one of the file
format extensions for Access database files. JET has been used in other MS
products and Access has used different
2014-02-11 0:43 GMT+09:00 peterlen petera...@earthlink.net:
We are using PostgreSQL 9.3. Something seems to have changed with our psql
command-line output since we first installed it. When I run commands at my
plsql prompt, I am getting a lot of debug statements which I was not getting
2014-02-01 Anh Pham atpham@gmail.com:
Hi,
I had Postgres 9.3 setup and run successfully in Eclipse (MacOSX)
I am trying to write a C user-defined function:
#include fmgr.h
...
#ifdef PG_MODULE_MAGIC
PG_MODULE_MAGIC;
#endif
...
However, when I tried to compile the code:
gcc -fpic
2014-01-27 Vincent Veyron vv.li...@wanadoo.fr:
Le dimanche 26 janvier 2014 à 10:27 -0700, Scott Ribe a écrit :
Is there an article anywhere which documents everything the current state of
the art for the fastest dump/restore? What dump/restore format options?
What things to tweak in the
2014/1/24 Emmanuel Medernach meder...@clermont.in2p3.fr:
Hello,
I'm currently testing postgres_fdw feature on PostgreSQL 9.3.2 and I have
some questions:
- What are the limits to the number of foreign tables ?
As far as I know, there is no limit (beyond the usual PostgreSQL limits).
-
014/1/2 peterlen petera...@earthlink.net:
I am using PostgreSQL 9.1 and have boon looking for psql commands to list all
tables in the current database as well as how to describe a given table.
I have come across some info on the web (older mostly) that lists commands
like \d, \dt, or \d+
2014/1/2 peterlen petera...@earthlink.net:
Thanks for the responses. I found that I was using an older version of psql
(one that got installed when I installed Cygwin on my windows box. I
changed it so now the \d+
gives me the description but \d and \dt still gives me No relations
found
2013/12/20 Adrian Klaver adrian.kla...@gmail.com:
On 12/20/2013 01:08 AM, Arindam Mondal wrote:
Hi ,
please let me know how I can connect postgresql using squirrel sql
client 3.4.0.
Make sure you have the Postgres JDBC driver:
http://jdbc.postgresql.org/download.html
Configure
2013/12/10 Stephan Fabel sfa...@hawaii.edu:
Hi all,
and sorry if I'm asking a question that has been answered before; has the
PostgreSQL community ever considered different key/value backends (sort of
like
MySQL with its many different options)?
We'd be very interested in seeing the
2013/12/6 Peter Kroon plakr...@gmail.com:
When you click on a table in the Object browser you'll see in the SQL
pane the sql that is needed to create that table.
Which function can I call to get that SQL?
You can use the pg_dump command line function for this:
pg_dump -s -t name_of_table
2013/10/22 Stephen Frost sfr...@snowman.net:
You also mentioned an external CMS. Any suggestions?
I'm a big fan of git, but if you really want to keep things in-database
and track dependencies, etc, it occurs to me that you might be able to
use an actual table in the database to store the
2013/10/14 Florian Nigsch f...@nigsch.eu:
Hi all,
I am not sure if this is a bug or a misuse on my part.
I am creating a number of indices in parallel on a table by using xargs. To
do that, I write all my indices in a file indices.idx, and then have the
indices build in parallel (in this
2013/10/18 Kevin Grittner kgri...@ymail.com:
Ian Lawrence Barwick barw...@gmail.com wrote:
It works fine for me on Pg 9.3.1:
postgres=# CREATE TABLE foo(val1 text, val2 text);
CREATE TABLE
postgres=# CREATE INDEX on foo((lower(val1)));
CREATE INDEX
postgres=# CREATE INDEX on foo((lower
2013/10/4 Jaime Casanova ja...@2ndquadrant.com:
what version of postgres is this? starting in 9.3 you can create
foreign tables between postgres databases, before that you can create
a foreing server and use the functions from th dblink module to
connect to that server and query the table on
2013/8/23 Robert James srobertja...@gmail.com:
I would like to:
INSERT INTO t
SELECT * FROM r, (x + y) AS field3
How do I correlate the names of the fields? That is, how do I indicate
which fields from r or field3 should be inserted into the right
columns in t?
INSERT INTO t (t_field1,
2013/8/9 ascot.m...@gmail.com ascot.m...@gmail.com:
Is there any PG manual command available to remove archived files by
(archive) date/time?
pg_archivecleanup might be of use to you:
http://www.postgresql.org/docs/current/static/pgarchivecleanup.html
Regards
Ian Barwick
--
Sent via
2013/8/8 dafNi zaf dza...@gmail.com:
Hello to everybody,
I started to upload (via phpPgAdmin) to a local server a huge file (20GB) in
order to fill up a database.
20GB is a lot to be uploading from a browser, even in this day and age.
Is the web server configured to accept uploads of that
2013/7/30 Massimo Costantini massimo.costant...@gmail.com:
Hi,
I have a problem with Triggers on VIEW:
suppose I have:
CREATE TABLE work (
id integer NOT NULL,
work TEXT,
worktype TEXT
);
CREATE VIEW worksub AS SELECT FROM work WHERE worktype='subordinate';
CREATE OR REPLACE
2013/7/23 Adrian Klaver adrian.kla...@gmail.com:
On 07/23/2013 05:15 AM, Ian Lawrence Barwick wrote:
Is there some simple way of viewing the search path (or other
role-specific setting) for a role different to the current role? Apart
from
querying 'pg_db_role_setting' directly?
Just
Is there some simple way of viewing the search path (or other
role-specific setting) for a role different to the current role? Apart from
querying 'pg_db_role_setting' directly?
Just wondering if I'm missing something obvious.
Regards
Ian Barwick
--
Sent via pgsql-general mailing list
2013/7/23 Michael Paquier michael.paqu...@gmail.com:
On Tue, Jul 23, 2013 at 9:15 PM, Ian Lawrence Barwick barw...@gmail.com
wrote:
Is there some simple way of viewing the search path (or other
role-specific setting) for a role different to the current role? Apart
from
querying
2013/6/26 Adarsh Sharma eddy.ada...@gmail.com:
Hi ,
Today i m creating a function that includes dynamic concatenation of a
partitioned table name as below :-
test=# CREATE OR REPLACE FUNCTION tmp_trigger_function()
test-# RETURNS TRIGGER AS $$
test$# DECLARE
test$# tbl_name text;
test$#
Thanks
On Wed, Jun 26, 2013 at 10:52 AM, Ian Lawrence Barwick barw...@gmail.com
wrote:
2013/6/26 Adarsh Sharma eddy.ada...@gmail.com:
Hi ,
Today i m creating a function that includes dynamic concatenation of a
partitioned table name as below :-
test=# CREATE OR REPLACE FUNCTION
2013/6/7 Rebecca Clarke r.clark...@gmail.com:
Hi all
I'm looking for suggestions on the best way to track the updates to a
function.
We have two databases, Dev Live, so I want to update Live with just the
functions that have been modified in the DEV databas3e.
Is there another, easier way
2013/6/3 Tom Lane t...@sss.pgh.pa.us:
Matt Daw m...@shotgunsoftware.com writes:
Howdy, I loaded a client's DB on my Mac to debug an unrelated bug, but
I'm blocked because my Mac is rejecting SQL that works on our Linux
production servers. Here's a simple case:
# select * from shots where
2013/5/26 bricklen brick...@gmail.com:
On Sat, May 25, 2013 at 8:45 AM, Karel Riveron Escobar
kesco...@estudiantes.uci.cu wrote:
I want to generate random numbers in Pl/pgSQL. How can I do this?
To be more specific, I have to generate random numbers among 0 and 5.
One way:
select n from
2013/5/24 YuChi tp6m4fu6250...@yahoo.com.tw:
i use postgresql-9.2.4 install on ubuntu11.04(natty)
and i use the command:
*postgres@ubuntu:/$ postgres -D /usr/local/pgsql/data*
or use
*postgres@ubuntu:/$ /usr/local/pgsql/bin/postmaster -D
/usr/local/pgsql/data*
to start the server
but
2013/5/25 Scott Marlowe scott.marl...@gmail.com:
On Fri, May 24, 2013 at 9:10 AM, Bèrto ëd Sèra berto.d.s...@gmail.com wrote:
The Greater London Authority is also ditching Oracle in favour of PG. I
consulted them while they kick started their transition and the first new
PG/PostGIS only
2013/5/9 Arun P.L aru...@hotmail.com:
Hi,
How can I upgrade to latest postgresql version 9.2 from my current version
7.4.3? How complicated this will be as the db contains large amount of data?
I have installed the latest version 9.2 in new server and while restoring
the dump from old
2013/5/1 Yang Zhang yanghates...@gmail.com:
On Tue, Apr 30, 2013 at 5:31 PM, Darren Duncan dar...@darrenduncan.net
wrote:
On 2013.04.30 4:55 PM, Yang Zhang wrote:
I would intuit that it's fine, but I just want to make sure there are
no gotchas from a recovery point of view:
If I were to
013/4/28 Bob Futrelle bob.futre...@gmail.com:
I have two PG servers with the same data.
I know the data is the same, because if I change a value in a table
on one server, it changes the value in a table with the same
name in the other server.
in pgAdmin III:
Properties for server Local
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
Sent: 12 April 2013 08:41 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] list non alphanumeric
On 4/11/2013 11:23 PM, Baboo, Isa wrote:
Firstly let me mention I am
2013/4/11 Joshua Berry yob...@gmail.com:
Am 11.04.2013 10:29, schrieb jpui:
Hi,
I'm running a server using postgres 8.3 and i was adviced to update
it...
what i have to do in order to update it and don't stop the service?
8.3 is out of support so you will need to at a very minimum
2013/4/8 Johann Spies johann.sp...@gmail.com:
I would appreciate some advice from the experts on this list about the best
backup strategy for my database.
(...)
I have read about using pg_basebackup in an article from Shaun Thomas'
booklet on Packt Publishers (I will probably buy the
2013/4/9 Tatsuo Ishii is...@postgresql.org:
While debugging this with a coworker we figured out that pg_ctl was
attaching to the tty and then it clicked
that we needed to be using '-t' where I was using -T or (neither).
Are you sure? I checked the pg_ctl source code and could not find any
2013/4/5 Konstantin Izmailov pgf...@gmail.com:
I came across an issue that looks like a bug in COPY. There are many similar
posts, e.g.
http://stackoverflow.com/questions/13485030/strange-postgresql-value-too-long-for-type-character-varying500,
without a good unswer.
Simplified steps to
2013/4/3 David Noel david.i.n...@gmail.com:
I'm running into a strange issue whereby my postgres processes are
slowly creeping to 100% CPU utilization. I'm running
postgresql-server-9.2.3, FreeBSD 8.3-RELEASE-p6, and using the
postgresql-9.2-1002.jdbc4 driver.
(...)
postgresql.conf, all
2013/3/27 Ken Tanzer ken.tan...@gmail.com
I've been working on some queries involving multiple unnested columns. At
first, I expected the number of rows returned would be the product of the
array lengths, so that this query would return 4 rows:
SELECT
2013/3/27 Ken Tanzer ken.tan...@gmail.com
Basically you are getting Cartesian joins on the row output of
unnest()
Well that's what I expected too. Except look at this example, after you
delete c:
testdb=# DELETE FROM t2 where val='c';
DELETE 1
testdb=# SELECT * from t1, t2;
val | val
2013/3/27 Tom Lane t...@sss.pgh.pa.us:
Gavin Flower gavinflo...@archidevsys.co.nz writes:
The rule appears to be,
where N_x N_y are the number of entries returned for x y:
N_result = is the smallest positive integer that has N_x N_y as factors.
Right: if there are multiple set-returning
2013/3/17 Csanyi Pal csanyi...@gmail.com:
Hi,
I'm using postgresql 9.2.
I'm trying to figure out how can I use daterange type in my database
that is supposed to be a school calendar.
I did the followings at the postgresql command prompt:
create database schoolcalendar;
create table
2013/3/13 Alexander Farber alexander.far...@gmail.com:
Thank you, this was indeed the
(uneeded) semicolon at end of the COPY line.
May I ask another question -
(...)
When I add few more words to my text file
and then try to load it into my table again,
then the COPY command will fail,
2013/3/14 Alexander Farber alexander.far...@gmail.com:
Thank you -
On Thu, Mar 14, 2013 at 10:40 AM, Ian Lawrence Barwick
barw...@gmail.com wrote:
I also have an INSERT trigger on my table,
can I return a NULL from it or something similar?
Yes, if you test for the presence of the word you
2013/3/13 Thor Michael Støre thormich...@gmail.com:
Hello,
Could someone make sense of this for me?
$ /Library/PostgreSQL/9.2/bin/psql -d postgres postgres
psql (9.2.3)
Type help for help.
postgres=# select 1 = ANY (ARRAY[1,2,3]);
?column?
--
t
(1 row)
postgres=# select 1
2013/3/12 Gauthier, Dave dave.gauth...@intel.com:
Hi:
v9.0.1 on linux.
I have a table with a column that is a csv. Users will select records based
upon the existence of an element of the csv. There is an index on that
column but I'm thinking that it won't be of much use in this situation.
2013/3/13 Ian Lawrence Barwick barw...@gmail.com:
2013/3/12 Gauthier, Dave dave.gauth...@intel.com:
Hi:
v9.0.1 on linux.
I have a table with a column that is a csv. Users will select records based
upon the existence of an element of the csv. There is an index on that
column but I'm
2013/3/13 Alexander Farber alexander.far...@gmail.com:
Hello,
I have a list of 40 non-english words,
each on a separate line and in UTF8 format,
which I'd like to put in the word column
of the following table (also in UTF8 and 8.4.13):
create table good_words (
word
2013/3/13 Alexander Farber alexander.far...@gmail.com:
Unfortunately doesn't work -
On Tue, Mar 12, 2013 at 5:53 PM, Ian Lawrence Barwick barw...@gmail.com
wrote:
2013/3/13 Alexander Farber alexander.far...@gmail.com:
I have a list of 40 non-english words,
each on a separate line
2013/3/8 Frank Lanitz fr...@frank.uvena.de:
Hi folks,
I'm looking for a HowTo of Foreign Tables feature. We are thinking of
connecting two postgres databases via this way and I wanted to try
before I do say yes or no ;) However, I didn't find any good HowTo on
via §search_engine.
If it's
2013/3/7 Graham Leggett minf...@sharp.fm:
Hi all,
I have a text file, and I need to update the value of an element in a table
with the contents of this text file. Following the instructions at
http://stackoverflow.com/questions/10968039/postgresql-inserting-value-of-a-column-from-a-file
I
Greg,
2013/3/7 Greg Williamson gwilliamso...@yahoo.com:
Graham --
(...)
The colon (:) is not needed, just remove it. A pair of colons is used to
indicate a cast of a value; off hand I am not coming up with any use of a
colon in basic SQL.
This is psql-specific syntax; the colon should
2013/3/7 Graham Leggett minf...@sharp.fm:
(...)
Which psql version are you using, and what is the table definition?
Version as below, from RHEL6:
psql (PostgreSQL) 8.4.13
Aha, there is your problem:
testdb=# SELECT version();
version
2013/2/21 ChoonSoo Park luisp...@gmail.com
Hello Gurus,
Table A has integer[] column. I need to delete specific integer value from
that column.
f1 | f2
1 {100, 101, 102, 103}
2 {200, 300, 400}
I want to remove 101 from f2 and also preserve the order.
f1
2013/2/21 Russell Keane russell.ke...@inps.co.uk
Sorry,
It's not ordered by value. It's not sorted list unfortunately. It can be
'{100, 120, 102, 130, 104}'.
Do you have other suggestion?
Thank you,
Choon Park
This should work:
update a set f2 = (select
2013/2/16 Glenn Pierce glennpie...@gmail.com:
Hi
Does anyone know how one would
select from a table with a hstore field treating the key of the hstore as
case insensitive.
ie
SELECT id, lower(additional_info-'type') AS type FROM table
I would like this to work even if if the store tyoe
2013/2/15 Ian Harding harding@gmail.com
When I run pg_upgrade, it tries to start the old cluster with the -w flag,
which waits a while and declares failure, even though it starts the
server. If I start/stop without -w everything is great.
Can I tell pg_upgrade not to use that flag, or
2013/2/15 Ian Harding harding@gmail.com
On Feb 14, 2013, at 9:50 PM, Ian Lawrence Barwick barw...@gmail.com wrote:
2013/2/15 Ian Harding harding@gmail.com
When I run pg_upgrade, it tries to start the old cluster with the -w flag,
which waits a while and declares failure, even
2013/2/14 Aleksey Tsalolikhin atsaloli.t...@gmail.com:
Below is an example of feeding query output to gnuplot without leaving
psql.
I'd like to call it as select graph(select * from example), just for
fun.
What do I need to learn to do that, please? Can I create a function that
uses \o? I
2013/1/15 Martin Gainty mgai...@hotmail.com:
Hi Guys
anyone know where I can zip or tar version of PostgreSQL 8.4 ?
Here?
http://www.postgresql.org/ftp/source/v8.4.15/
Ian Lawrence Barwick
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
to do a INSERT... VALUES ...
WHERE...
INSERT INTO ... SELECT is what you are looking for.
Simple example:
CREATE TABLE seltest (id INT);
INSERT INTO seltest (id) SELECT 1;
HTH
Ian Lawrence Barwick
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
Lawrence Barwick
64 matches
Mail list logo