2014-03-14 4:26 GMT+09:00 :
> 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 Barwick
--
Sent v
2014-03-12 12:00 GMT+09:00 Roy Anderson :
> 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 materialized views.
2014-03-01 9:34 GMT+09:00 Rich Shepard :
> 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 file formats(extens
2014-03-01 8:16 GMT+09:00 George Weaver :
>
>> - Original Message - From: Steve Atkins
>
>
>> On Feb 28, 2014, at 2:43 PM, George Weaver wrote:
>>
>> >Maybe this?
>>
>> >select regexp_replace('300 North 126th Street', '(\d+)(?:st|nd|rd|th)',
>> >'\1', 'gi');
>>
>> Hi Steve,
>>
>> Thanks, b
2014-02-11 0:43 GMT+09:00 peterlen :
> 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
> before. I am just trying
2014-02-01 Anh Pham :
> Hi,
> I had Postgres 9.3 setup and run successfully in Eclipse (MacOSX)
> I am trying to write a C user-defined function:
>
> #include
> ...
> #ifdef PG_MODULE_MAGIC
> PG_MODULE_MAGIC;
> #endif
> ...
>
> However, when I tried to compile the code:
> gcc -fpic -c ...
> It gav
2014-01-27 Vincent Veyron :
> 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 config? I've pi
2014/1/24 Emmanuel Medernach :
> 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).
> - What is the current s
2014/1/2 peterlen :
> 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" so I must be usi
014/1/2 peterlen :
> 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+ but I get results like
2013/12/20 Adrian Klaver :
> 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 SQuirrel:
>
> h
2013/12/10 Stephan Fabel :
> 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 effects of inte
2013/12/6 Peter Kroon :
> 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 name_of_data
2013/10/22 Stephen Frost :
>> 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 raw form of you
2013/10/18 Kevin Grittner :
> Ian Lawrence Barwick 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
2013/10/14 Florian Nigsch :
> 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 case with
2013/10/4 Jaime Casanova :
> 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 it
Read-only forei
2013/8/23 Robert James :
> 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, t_field2, t_field
2013/8/9 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 pgsql-general mailing
2013/8/8 dafNi zaf :
> 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 size?
--
Sen
2013/7/30 Massimo Costantini :
>
> 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 FUNCTION wr
2013/7/23 Adrian Klaver :
> 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_sett
2013/7/23 Michael Paquier :
>
> On Tue, Jul 23, 2013 at 9:15 PM, 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
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 (pgsql-
> Thanks
>
>
> On Wed, Jun 26, 2013 at 10:52 AM, Ian Lawrence Barwick
> wrote:
>>
>> 2013/6/26 Adarsh Sharma :
>> > Hi ,
>> >
>> > Today i m creating a function that includes dynamic concatenation of a
>> > partitioned tab
2013/6/26 Adarsh Sharma :
> 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$# abc varchar;
2013/6/7 Rebecca Clarke :
> 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 to track th
2013/6/3 Tom Lane :
> Matt Daw 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 sg_poznÁmka is NULL;
>> ERROR: colu
2013/5/26 bricklen :
>
> On Sat, May 25, 2013 at 8:45 AM, Karel Riveron Escobar
> 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 unnest(ARRAY[0,1,2,3,4,5]) n orde
2013/5/25 Scott Marlowe :
> On Fri, May 24, 2013 at 9:10 AM, Bèrto ëd Sèra 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 project is already delivered. The number of c
2013/5/24 YuChi :
> 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 it's stopping at
2013/5/9 Arun P.L :
> 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 version, data in so
2013/5/1 Yang Zhang :
> On Tue, Apr 30, 2013 at 5:31 PM, Darren Duncan
> 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 lose my temp tablespace upo
013/4/28 Bob Futrelle :
> 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 (localhost:5432)
> 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 me
2013/4/11 Joshua Berry :
>
>> 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 8
2013/4/9 Tatsuo Ishii :
>> 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
> place attachi
2013/4/8 Johann Spies :
> 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 booklet).
Get the bookle
2013/4/5 Konstantin Izmailov :
> 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 reproduce the i
2013/4/3 David Noel :
> 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 standard/default excep
2013/3/27 Tom Lane :
> Gavin Flower 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 functions in a SELECT list,
> the num
2013/3/27 Ken Tanzer
> 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 Ken Tanzer
>
> 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 unnest2(array['a','b']),unnest2(array['1','2']);
>
>
2013/3/17 Csanyi Pal :
> 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 semester_1 (
2013/3/14 Alexander Farber :
> Thank you -
>
> On Thu, Mar 14, 2013 at 10:40 AM, Ian Lawrence Barwick
> 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
2013/3/13 Alexander Farber :
> 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,
> because of the already
2013/3/13 Thor Michael Støre :
> 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 = ANY
2013/3/13 Alexander Farber :
> Unfortunately doesn't work -
>
> On Tue, Mar 12, 2013 at 5:53 PM, Ian Lawrence Barwick
> wrote:
>> 2013/3/13 Alexander Farber :
>>>
>>> I have a list of 40 non-english words,
>>> each on a separate line and in U
2013/3/13 Alexander Farber :
> 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 varchar(64) primary key,
>
2013/3/13 Ian Lawrence Barwick :
> 2013/3/12 Gauthier, Dave :
>> 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
>>
2013/3/12 Gauthier, Dave :
> 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. Is
> there a wa
2013/3/8 Frank Lanitz :
> 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 postgres_fdw you'
2013/3/7 Graham Leggett :
(...)
>> 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
---
Greg,
2013/3/7 Greg Williamson :
>
>
> 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 cause the value of
2013/3/7 Graham Leggett :
> 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 tried this
2013/2/21 Russell Keane
>
>
>
> >>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 = (
2013/2/21 ChoonSoo Park
>
> 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/16 Glenn Pierce :
> 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 is
>
> 'Ty
2013/2/15 Ian Harding
>
>
> On Feb 14, 2013, at 9:50 PM, Ian Lawrence Barwick wrote:
>
> 2013/2/15 Ian Harding
>>
>> 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
2013/2/15 Ian Harding
> 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 is there a reason
2013/2/14 Aleksey Tsalolikhin :
> 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 think not, because
2013/1/15 Martin Gainty :
> 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 subscript
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 to
w the schemas owned by the
user if the user is not a superuser).
Ian Lawrence Barwick
64 matches
Mail list logo
