On Mon, Aug 12, 2013 at 8:28 AM, David F. Skoll d...@roaringpenguin.comwrote:
3) Our current workload peaks at about 5000 transactions per second;
you can assume about one-third to one-half of those are writes. Do
you think we can get away with 16 10Krpm SATA drives instead of the
SSDs?
On Wed, Jun 19, 2013 at 2:35 AM, Rural Hunter ruralhun...@gmail.com wrote:
I really hate the error permission denied for sequence x when I
grant on a table but forget to grant additionally on the related sequence
to users. Can the permission of table and related sequences be merged?
You
On Thu, May 16, 2013 at 11:04 AM, Oscar Calderon
ocalde...@solucionesaplicativas.com wrote:
Hi everybody, this is my first message in this list. The company where i
work is bringing maintenance service of PostgreSQL to another company,
and currently they have installed PostgreSQL 9.1.1, and
On Thu, May 9, 2013 at 5:01 PM, Miu, Monica monica@asurion.com wrote:
Hi all,
** **
My name is Monica Miu and I work in Talent Acquisition for Asurion Mobile
Applications
Basically you just pissed everyone off that you're trying to recruit. This
is a highly technical discussion
Just out of curiousity, I see comments like this all the time:
(*please* stop top-posting).
I've been participating in newsgroups since UUCP days, and I've never
encountered a group before that encouraged bottom posting. Bottom posting
has traditionally been considered rude -- it forces
On Mon, May 6, 2013 at 11:25 AM, Szymon Guz mabew...@gmail.com wrote:
On 6 May 2013 20:15, Craig James cja...@emolecules.com wrote:
Just out of curiousity, I see comments like this all the time:
(*please* stop top-posting).
We are reading from top to bottom. That's why people should
Regarding top posting versus bottom posting, pretty almost everyone who has
commented agrees that top versus bottom posting isn't the problem. It's
laziness about editing, perhaps exacerbated by certain email systems that
encourage that laziness.
So how about this: instead of demanding PLEASE
On Fri, Apr 19, 2013 at 5:12 PM, Rodrigo Barboza rodrigombu...@gmail.comwrote:
Hi guys.
I created a database with default encoding (SQL_ASCII) and default collate
(C).
I created a table test like this:
create table test (a varchar (10));
Then i executed insert into teste (a) values
Hmmm the subselect is invalid, but not rejected. The outer select
returns every row in the customer_order_matches table. This seems pretty
wrong. This is PG 9.2.1 running on Ubuntu.
db= select count(1) from customer_order_matches where
customer_order_item_id in (select
On Wed, Apr 10, 2013 at 4:59 PM, Armin Resch resc...@gmail.com wrote:
Not sure this is the right list to vent about this but here you go:
I) select regexp_replace('BEFORE.AFTER','(.*)\..*','\1','g') Substring
II) select regexp_replace('BEFORE.AFTER','(.*)\\..*','\\1','g') Substring
On Thu, Mar 28, 2013 at 10:51 AM, Marc Fromm marc.fr...@wwu.edu wrote:
Is there a way to create a select statement that will select a record if
the exact term is found in a field that contains the text to describe
something?
** **
If I create a select statement using WHERE description
not
willing to make. Even if you don't upgrade the version (you should at
least upgrade to the latest 8.4.x release), dump/restore will fix your
problem.
Craig James
encourage their customers to keep their
Postgres software up to date.
If, on the other hand, this is your company's internal policies, then pass
Steve's message along in with a strongly worded admonition that they pay
attention.
Craig James
Cheers,
Steve
--
Sent via pgsql-admin mailing
On Wed, Nov 21, 2012 at 1:21 AM, Gnanakumar gna...@zoniac.com wrote:
Hi,
Our application requirement demands archiving of records, so that
performance/speed of the application is not compromised. So, am looking
out/evaluating on various techniques/solutions available for database
On Thu, Nov 15, 2012 at 1:32 AM, Lukasz Brodziak
lukasz.brodz...@gmail.comwrote:
2012/11/15 Craig Ringer cr...@2ndquadrant.com
Another option would be to monitor syslog or the csvlog and lock the
user out by changing their password or revoking CONNECT rights if they
trip the threshold. It
I installed 9.2 on our new server and am seeing something odd that doesn't
happen in 8.4:
postgres=# select datname, pid, usename, query from pg_stat_activity where
query != 'IDLE';
datname | pid | usename |
query
On Thu, Oct 18, 2012 at 2:54 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Craig James cja...@emolecules.com writes:
I installed 9.2 on our new server and am seeing something odd that
doesn't
happen in 8.4:
postgres=# select datname, pid, usename, query from pg_stat_activity
where
query
On Wed, Oct 10, 2012 at 10:08 PM, Craig Ringer ring...@ringerc.id.auwrote:
On 10/11/2012 02:22 AM, Craig James wrote:
I have a C-language function I've been using on 8.4 for a long time. On
9.2 it won't load:
test=# set search_path = public;
SET
test=# CREATE OR REPLACE FUNCTION
I have a C-language function I've been using on 8.4 for a long time. On
9.2 it won't load:
test=# set search_path = public;
SET
test=# CREATE OR REPLACE FUNCTION chmoogle_session_id() RETURNS integer
AS '/usr/local/pgsql/lib/libchmoogle.so', 'chmoogle_session_id'
LANGUAGE c VOLATILE;
ERROR:
Is it OK to mix 9.2.x and 8.4.x clients and servers? Can they talk to each
other? In other words, if I install 9.2 on a new server alongside older
servers running 8.4.x, can clients on the 8.4 systems talk to 9.2 servers,
and can the 9.2 clients talk to 8.4 servers?
Thanks,
Craig
On Tue, Oct 2, 2012 at 11:54 AM, Babay Adi, Hava hava.ba...@hp.com wrote:
Dear list,
** **
I’m new to PostgreSQL, planning now a migration to PostgreSQL and would
appreciate your help.
** **
One aspect of the migration is re-thinking our DB structure.
** **
The
On Wed, Oct 3, 2012 at 10:58 AM, Babay Adi, Hava hava.ba...@hp.com wrote:
Thanks Craig for the useful information.
** **
On the same regard – Some of the mentioned modules in the mentioned
application use a set of tables which is logically separate (there are no
join statements with
On Thu, Sep 27, 2012 at 2:23 AM, Gary Stainburn
gary.stainb...@ringways.co.uk wrote:
Hi folks.
I'm planning on extending a field in one of my main tables using:
alter table stock alter column type varchar(255);
Why not just do
alter table stock alter column type text;
That is, do you
On Thu, Sep 20, 2012 at 7:56 PM, Haifeng Liu liuhaif...@live.com wrote:
On Sep 20, 2012, at 10:34 PM, Craig James cja...@emolecules.com wrote:
On Thu, Sep 20, 2012 at 1:55 AM, Haifeng Liu liuhaif...@live.com wrote:
I want to write a hash function which acts as String.hashCode() in java
On Thu, Sep 20, 2012 at 1:55 AM, Haifeng Liu liuhaif...@live.com wrote:
I want to write a hash function which acts as String.hashCode() in java:
hash = hash * 31 + s.charAt(i)... but I got integer out of range error. How
can I avoid this? I saw java do not care overflow of int, it just make
On Mon, Sep 10, 2012 at 10:17 AM, Antoine Guidi antoine.gu...@gmail.comwrote:
Another question, when I get a reply from the list, to which email
should I then reply?
To all? the User posting, or pgsql-admin@?
Either reply-to-all or reply to the pgsql-admin address. Either way,
everyone gets
On Sat, Sep 8, 2012 at 1:26 PM, Sergey Konoplev gray...@gmail.com wrote:
On Fri, Sep 7, 2012 at 3:20 AM, Bruce Momjian br...@momjian.us wrote:
On Thu, Sep 6, 2012 at 05:55:05PM -0500, Antoine Guidi wrote:
Is it possible to do a pg_upgrade from 9.1.2 to 9.1.5 just using pg_upgrade?
For what I
On Wed, Sep 5, 2012 at 2:21 AM, Mathias Breuninger
I wasn't aware of the binary problem with replication.
Maybe the PostgreSQL docs should emphasize the architecture restriction.
That's sort of what binary file means -- a raw,
architecture-specific representation of data that's optimized for
On Tue, Sep 4, 2012 at 9:48 PM, Sergey Konoplev gray...@gmail.com wrote:
On Tue, Sep 4, 2012 at 8:35 PM, Craig James cja...@emolecules.com wrote:
Can anyone recommend a good tool for producing a good drawing of an existing
database schema? I don't need a design tool, but rather one that can
Can anyone recommend a good tool for producing a good drawing of an
existing database schema? I don't need a design tool, but rather one that
can take an existing schema and produce a nice diagram that can be further
edited and beautified. I want something I can print and hang on the wall
as a
On Fri, Aug 24, 2012 at 7:08 AM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
CS DBA cs_...@consistentstate.com wrote:
I've fired up 2 CentOS 6.2 VM's via vmware fusion 5 (on a mac).
psql -h 192.168.91.145
psql: could not connect to server: No route to host
That problem has nothing to
On Fri, Aug 10, 2012 at 7:19 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Haifeng Liu liuhaif...@live.com writes:
I have a program running like a daemon, which analyze data and write to
postgresql 9.1 on centos 5.8. There is only one connection between my
program and the postgresql database, and I
On Mon, Jul 30, 2012 at 4:06 AM, Amit Kumar helloam...@gmail.com wrote:
All,
I am facing a weired issue in PG 9.0.3. Sometime via application UPDATES
are not changing data in the database but in postgres logs its also not
raising any error. It is happening 2-3 times in a week. I have tried
On Wed, Jul 11, 2012 at 10:47 AM, Arnold, Sandra arno...@osti.gov wrote:
Tablelog would be ok for keeping up with transactions for tables.
However, we also need to audit who connects successfully and
unsuccessfully. As far as I am aware, if a user fails to log in
successfully, say three
On Wed, May 30, 2012 at 8:14 AM, Igor Shmain igor.shm...@gmail.com wrote:
Thank you, Liu, for your suggestion.
** **
I might be missing something (I am new to postgres), but it seems that
your suggestion will not help much in my case. Since the number of db
requests will grow with
I recently recompiled our Postgres extension functions and re-encountered a
problem that I thought was solved. When I call our function, the code just
hangs ... it sit there not executing, not using any CPU cycles. Forever.
The process is still running, but seems to be waiting for ... what?
I
2012/1/17 Mindaugas Žakšauskas min...@gmail.com
On Tue, Jan 17, 2012 at 7:23 PM, Tom Lane t...@sss.pgh.pa.us wrote:
.. Mindaugas, are you using SSL,
and if so can you turn it off and see whether things change?
(It should be safe to do so at least on the localhost connection,
even if you
On 12/21/11 12:34 PM, Elliot Voris wrote:
Hi, everyone
I've got 32,404 rows of data in a staging table (marcxml_import) that I'm
trying to get into my production table (biblio.record_entry) in my database
(evergreen). When trying to do so, I'm getting the following error:
evergreen=# INSERT
On 12/19/11 10:04 AM, Mario Splivalo wrote:
I need to have postgres role to be able to cancel queries run by that
same role.
I know that I can kill the client connection that started the query, but
I also need to have that role connect to postgres and kill some of it's
running queries.
It's on
On 11/29/11 10:36 AM, Scott Marlowe wrote:
On Tue, Nov 29, 2011 at 11:15 AM, Craig James
craig_ja...@emolecules.com wrote:
Several times recently one of our databases has gotten stuck with the
following situation:
postgres=# select datname, procpid, usename, current_query from
Several times recently one of our databases has gotten stuck with the
following situation:
postgres=# select datname, procpid, usename, current_query from
pg_stat_activity where current_query != 'IDLE';
datname | procpid | usename |
current_query
On 10/24/11 3:10 PM, Krishnamurthy Radhakrishnan wrote:
Hi,
I am new to PostgreSQL. We are using PostgreSQL 9.0.2 on our linux server. We
have an instance of PostgreSQL 9.0 running using the primary partition on the
server.
We want to use the pg_dump and psql programs to migrate the data
On 8/19/11 1:40 AM, Marko Kreen wrote:
On Fri, Aug 19, 2011 at 2:44 AM, Craig Jamescraig_ja...@emolecules.com wrote:
We had to temporarily assign two IP addresses to our servers. After doing
so and rebooting, Londiste will start, but it just sits there doing nothing.
The logfile has zero
On 8/19/11 1:40 AM, Marko Kreen wrote:
On Fri, Aug 19, 2011 at 2:44 AM, Craig Jamescraig_ja...@emolecules.com wrote:
We had to temporarily assign two IP addresses to our servers. After doing
so and rebooting, Londiste will start, but it just sits there doing nothing.
The logfile has zero
We had to temporarily assign two IP addresses to our servers. After doing so
and rebooting, Londiste will start, but it just sits there doing nothing. The
logfile has zero bytes, and it doesn't seem to connect to either the master or
the slave database.
We reconfigured Postgres to listen on
On 8/16/11 10:24 AM, Chris Travers wrote:
I can't let this slide :-D
On Tue, Aug 16, 2011 at 9:27 AM, Evan Rempelerem...@uvic.ca wrote:
Technically it can be done, but just because we can do something does not
mean we should do something. Having said that...
We have been using a middleware
On 8/7/11 10:30 AM, antismarmy wrote:
Hello community,
I need to execute pgsql2shp from the command line, but I am not interested
in the other functionalities offered by postgresql on this machine. I have
been told that installing an instance of a spatial database on the machine
in question
On 8/7/11 10:30 AM, antismarmy wrote:
Hello community,
I need to execute pgsql2shp from the command line, but I am not interested
in the other functionalities offered by postgresql on this machine. I have
been told that installing an instance of a spatial database on the machine
in question
On 6/17/11 11:51 AM, Shianmiin wrote:
Tom Lane-2 wrote:
What's not apparent however is why the stats collector is writing disk
so much. 8.4 does have the logic change to not write stats out unless
something is asking to see them. So either it's really pre-8.4, or you
have a monitoring task
On 6/14/11 1:42 PM, Tim wrote:
So I ran this test:
unzip -p text.docx word/document.xml | perl -p -e 's/.+?/\n/g;s/[^a-z0-9\n]/\n/ig;'|grep
.. text.txt
ls -hal ./text.*
#-rwxrwxrwx 1 postgres postgres 15M 2011-06-14 15:12 ./text.docx
#-rwxrwxrwx 1 postgres postgres 29M 2011-06-14 15:17
On 6/8/11 12:39 PM, Maria L. Wilson wrote:
Interested in using Londiste to set up replication of only one column in a
particular database to another database on a remote Postgres server. I've
installed and configured londiste on the servers - that was no problem. I just
don't see anything
On 5/21/11 8:11 AM, Tom Lane wrote:
Craig Jamescraig_ja...@emolecules.com writes:
On 5/20/11 4:25 PM, Scott Marlowe wrote:
On Fri, May 20, 2011 at 3:14 PM, Craig Jamescraig_ja...@emolecules.com
wrote:
Our development server (PG 8.4.4 on Ubuntu server) is constantly doing
something, and I
Our development server (PG 8.4.4 on Ubuntu server) is constantly doing
something, and I can't figure out what. The two production servers, which are
essentially identical, don't show these symptoms. In a nutshell, it's showing
10K blocks per second of data going out, all the time, and
On 5/20/11 3:38 PM, Joshua D. Drake wrote:
The other two servers are configured identically. If I diff the
configuration files, the only difference is the IP addresses for the
listen section.
Can anyone tell me what's going on? Why is pgstat.stat being rewritten
on this server constantly and
On 5/20/11 4:25 PM, Scott Marlowe wrote:
On Fri, May 20, 2011 at 3:14 PM, Craig Jamescraig_ja...@emolecules.com wrote:
Our development server (PG 8.4.4 on Ubuntu server) is constantly doing
something, and I can't figure out what. The two production servers, which
are essentially identical,
On 4/22/11 8:17 PM, Tom Lane wrote:
Craig Jamescraig_ja...@emolecules.com writes:
On 4/22/11 1:58 PM, Tom Lane wrote:
Craig Jamescraig_ja...@emolecules.com writes:
select objectid from archive where db_id is null limit 1 for update
The interaction between LIMIT and FOR UPDATE changed in
I thought I understood select ... for update, but maybe not.
We have a number of separate databases and a unique integer identifier that's supposed to
be global across all databases. A single archive database is used to issue
the next available ID when a process wants to create a new object.
On 4/22/11 1:58 PM, Tom Lane wrote:
Craig Jamescraig_ja...@emolecules.com writes:
select objectid from archive where db_id is null limit 1 for update
The interaction between LIMIT and FOR UPDATE changed in 9.0 ... what
PG version are you using?
8.4.4
thanks,
Craig
On 4/9/11 9:24 AM, H S wrote:
Dear Sirs,
I would like to include SELINUX MLS to my postgres DBMS,
I have just install mls package on my fedora 14 and mcstrans
But after relabelling my whole file system, I do not have any graphical user
interface , and must login to my system in text mode
On Thu, Jan 20, 2011 at 10:42 AM, Bradley Holbrook
operations_brad...@servillian.ca wrote:
Thanks Scott... a couple comments.
Our developers never decide what goes to where... they just happily
plumb away on the development db until we're ready to take
our product
to testing (at regular
Joshj...@saucetel.com wrote:
I am looking for suggestions on how best to secure a server that
is accessible via the internet. Even account creation for the
database is open to the world. Does anybody have any extra changes
they would make to postgresql.conf or OS changes they would
suggest?
On 12/11/10 7:47 PM, David Underhill wrote:
I have two tables. One has a foreign key referencing a serial
field in the other table. I've given INSERT privilege to a role
other than the owner, but I still can't insert into the table
containing the foreign key unless I grant the /owner/ of
On 12/1/10 7:54 AM, Kevin Grittner wrote:
Lello, Nicknick.le...@rentrakmail.com wrote:
What is considered the best filesystem to use for postgres data
stores ?
I held off for a bit to see if someone else would jump in with a
comparison of filesystems, but so far nobody has taken the bait.
On 11/22/10 10:42 AM, James Cloos wrote:
TL == Tom Lanet...@sss.pgh.pa.us writes:
TL It *is* configurable: make pg_xlog a symlink.
I notice that everyone suggests using a symlink, but I never see anyone
suggest just mounting a filesystem there.
Is there a (technical) reason for that? Or
On 11/15/10 11:42 AM, Chris Ruprecht wrote:
I was wondering if there is a way to pre-allocate tablespace on disk before
adding data and indexes.
My understanding is:
PG writes data into files sequentially. If more space is needed, disk space
is requested from the OS and if there is space, the
On 10/14/10 3:59 AM, Sebastien wrote:
Hello!
I'm writting to get some clues about PostgreSQL administration, and more
precisely SSL connection from one server to another with certificate
identification. I must underline than I'm new to postgreSQL and server
administration.
Here is the
On 10/5/10 11:08 AM, Dinesh Bhandary wrote:
Hi All,
Is there an easy way to restore to a new table where the column name have been
changed but data remains the same?
For example I am trying to restore from existing system, table1(col1) to
table1(col2) and it is erroring out on the new column
On 10/4/10 10:36 AM, Lou Picciano wrote:
(Think I've seen the answer to this already, but:) is there any 'innate', or
'default' session timeout function built in to PG?
We have certain clients who seem to timeout pretty frequently, while
others seem to never time out at all; before we start
On 9/16/10 3:54 PM, Aras Angelo wrote:
Hello All
I have a column in my table which is incrementally updated.
Try to give us more details...
Does the column need have contiguous values or are gaps ok? That is, does it
have to be 1,2,3,4,...,N-1,N or is it ok to have something like
On 9/7/10 12:06 PM, Jesper Krogh wrote:
On 2010-09-07 20:42, Scott Marlowe wrote:
With the right supplier, you can plug in literally 100 hard drives to
a regular server with DAS and for a fraction of the cost of a SAN.
Ok, recently I have compared prices a NexSan SASBeast with 42 15K SAS
On 8/27/10 9:48 AM, £ukasz Brodziak wrote:
I'm looking for actual versions of row data. What I want to achieve as a final
result is a kind of data change history.
What about a before-update trigger and an history table?
Craig
Date: Fri, 27 Aug 2010 08:25:26 -0500
From:
On 8/27/10 10:09 AM, Lukasz Brodziak wrote:
What do You mean by history table? Creating such table is out of the question.
You asked for actual versions of row data and a data change history. How
can you expect to get a history without the history being stored somewhere? The previous
On 8/9/10 5:14 PM, Bruce Momjian wrote:
ENGEMANN, DAYSE wrote:
Hi Kevin,
Sorry to disturb you.. But I am really new in it...
Let me see if I understood...
pg_dump -h sourcemachine -U sourceuser source_dbname | psql target_dbname
Has anyone done any measurement of whether it is faster to do
On 8/5/10 12:58 PM, Mark Steben wrote:
I would like to set up a facility that enforces password changes for roles
After a predefined period (30 days for instance) when logging into psql
Or, at the very least, send an email out to notify that your current
Password period is about to expire.
On 7/30/10 10:37 AM, Kevin Grittner wrote:
Craig Jamescraig_ja...@emolecules.com wrote:
Well, the if it ain't broke, don't fix it rule might come into
play here.
I should have given one more detail here: We've been the victim
of persistent CPU spikes that were discussed extensively in
I have a question that may be related to connection pooling.
We create a bunch of high-performance lightweight Postgres clients that serve
up images (via mod_perl and Apache::DBI). We have roughly ten web sites, with
ten mod_perl instances each, so we always have around 100 Postgres backends
This isn't exactly a Postgres question, but I hope someone in the community has
solved it.
I want to encrypt some data in Postgres that arrives from Apache. How do you
store an encryption key in such a way that Apache CGIs can get it, but a hacker
or rogue employee who manages to access the
On 7/16/10 3:31 PM, Patric Michael wrote:
Hi all...
I joined this list in an effort to solve a puzzle I fail to understand.
Thank you in advance for taking the time to read.
I've been managing a domain for the last eight years as an erstwhile
administrator. Erstwhile meaning it is largely a
I'm migrating from Postgres 8.3.10 to 8.4.4, and also from Fedora 9 to Ubuntu
10.04.
On 8.3.10, I have a C extension that worked on 8.3, but now refuses to load on
8.4:
CREATE OR REPLACE FUNCTION chmoogle_session_id() RETURNS integer
AS '/usr/local/pgsql/lib/libchmoogle.so',
On 7/15/10 12:52 PM, Tom Lane wrote:
Craig Jamescraig_ja...@emolecules.com writes:
On the Postgres 8.3 system, I simply put libopenbabel.so into the
/usr/local/pgsql/lib directory, and everything worked well. On 8.4, I can't
seem to get it to load libopenbabel.so. Other programs that use
80 matches
Mail list logo