On 11/10/2015 10:58 AM, tbro wrote:
The application is called Nable and is owned by Solarwinds
http://www.n-able.com
It is not uncommon for DAS to be much faster than NAS/SAN.
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack
On 11/05/2015 07:52 PM, M Tarkeshwar Rao wrote:
Hi,
one thing in oracle is there any difference between “DROP PRIMARY KEY”
used directly in oracle to drop primary key, or “DROP CONSTRAINT
CDRAUDITPOINT_pk”, as first syntax is not available in postgres and we
need to give primary key name as
On 10/24/2015 09:19 PM, David Blomstrom wrote:
I'm a writer. I studied programing and MySQL so I could create websites
that I can publish my articles to. I don't have time to keep up with the
endless technology - MySQL, PDO, stored procedures, PHP, JavaScript,
JQuery, and on and on - especially
On 10/14/2015 01:31 PM, Quiroga, Damian wrote:
Hi,
In case someone knows…
Does postgres support other (stronger) hashing algorithms than MD5 to
store the database passwords at disk?
No.
If not, is there any plan to move away from MD5?
Not currently although it has been mentioned.
On 09/17/2015 10:32 AM, Quiroga, Damian wrote:
Hi,
Is it possible to prevent users from running the “version” function or
all system information functions? If so, how?
You could probably revoke access to the function(s) (I haven't tried it
because it seems very silly).
JD
--
Command
On 09/10/2015 10:11 AM, Martín Marqués wrote:
El 10/09/15 a las 13:17, Ioana Danes escribió:
I could not find a mailing list for BDR/UDR so I thought to post my
issue here with my hope that somebody can help me.
It seems people are now looking for a specific mailing list for bdr/udr
On 08/31/2015 09:37 AM, Bruce Momjian wrote:
On Mon, Aug 31, 2015 at 12:30:52PM -0300, Alvaro Herrera wrote:
BDR is not currently part of community Postgres so you will need to
report it to them directly.
As discussed a year ago or so, this list is what to use for BDR reports
and discussions,
On 08/31/2015 12:14 PM, Bruce Momjian wrote:
On Mon, Aug 31, 2015 at 09:58:36AM -0700, Joshua Drake wrote:
On 08/31/2015 09:37 AM, Bruce Momjian wrote:
On Mon, Aug 31, 2015 at 12:30:52PM -0300, Alvaro Herrera wrote:
It clearly is being developed by 2nd Quadrant:
On 08/25/2015 05:28 PM, Adrian Klaver wrote:
On 08/25/2015 05:17 PM, Melvin Davidson wrote:
I think a lot of people here are missing the point. I was trying to give
examples of natural keys, but a lot of people are taking great delight
in pointing out exceptions to examples, rather than
On 08/25/2015 09:09 AM, Rob Sargent wrote:
On 08/25/2015 09:40 AM, Melvin Davidson wrote:
Adrian,
Stop being so technical. When we/I speak of natural keys, we are
talking about the column
that would NATURALly lend itself as the primary key.
No one ever said a number is not natural. just that
On 08/24/2015 07:58 AM, John Turner wrote:
On Mon, 24 Aug 2015 09:15:27 -0400, Ray Cote
Point 9 is well-intentioned, but perhaps needs to be
clarified/rephrased: Developers should not be creating production-grade
tables devoid of well-defined business keys, period. That would be
regardless
On 08/24/2015 08:56 AM, Melvin Davidson wrote:
The serial key is the default primary key amongst every single web
development environment in existence.
Methinks thou doest take too much for granted.
Yes, serial has it's purpose, but I sincerely doubt it is the default
primary key amongst
On 08/24/2015 09:34 AM, Melvin Davidson wrote:
And again, I am talking about _database_ design, not Web apps. Letting
Web developers design a database to work with their app, is a very,
Very, VERY bad idea.
And I don't argue that but we also live in a world based on reality.
DBAs are rare,
On 08/19/2015 06:56 PM, Scott Marlowe wrote:
hard to say here are our top 10 users when we don't really know who
the biggest users are. For all we know the Fortune 50 could be all
heavily using it and we'd never know unless someone there spoke up and
told us.
They are, extensively.
Joshua D
On 08/18/2015 09:41 AM, Alvaro Herrera wrote:
Alvaro Herrera wrote:
One thing to look at is the rate of WAL generation for a set number of
transactions. Maybe the later releases are generating more WAL due to
multixacts, for instance (prior to 9.3 these weren't wal-logged.)
Also try
On 08/18/2015 08:01 AM, Michael H wrote:
Hi,
I've been tuning our new database server, here's some info...
CentOS Linux release 7.1.1503 (Core)
3.10.0-229.11.1.el7.x86_64
8 x 16GB 1600MHz PC3-12800 DDR3- 128GB total
2 x AMD Opteron 6386SE 2.8GHz/16-core/140w - 32 cores total
On 08/18/2015 09:19 AM, Melvin Davidson wrote:
8 x 16GB 1600MHz PC3-12800 DDR3 - 128GB total
shared_buffers=60GB
I would say 60GB is too high when you have 128GB system memory.
Try lowering it to shared_buffers=32GB and let the O/S handle more of
the work.
I would also look
On 08/13/2015 08:52 AM, Wayne E. Seguin wrote:
BDR is only one in Beta compare to stable options:
https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling.
Not sure why this solution would be chosen. Experience with pgpool is
that you only needed to change a port and no
On 08/12/2015 05:33 PM, Edson Richter wrote:
Hi!
I've a situation where I would like to keep sync replication, where
servers have 10Mbps network connection but high latency (normally, ~20ms
but sometimes, 1000ms~2000ms, even 3000ms when network is under load).
Considering that I will keep
On 08/04/2015 12:47 PM, clingare...@vsoftcorp.com wrote:
Hi,
Please help me on:
what is the use of bidirectional replication in PostgreSQL?
How BDR works?
how to setup BDR?
on which versions BDR works?
Please do not cross post. What you are looking for is here:
On 07/29/2015 02:27 PM, Ravi Krishna wrote:
Not necessarily. There has been discussion of adding a new mode
which will delay the commit on the primary until it is visible on a
synchronous standby, but I don't recall where that left off.
Joshua: THis essentially contradicts your statement
On 07/28/2015 01:12 PM, AI Rumman wrote:
Hi,
I need to upgrade Postgresql database from 8.4 to latest stable version
(9.4). The db size is almost 2.5 TB.
Is pg_upgrade in-place is a good idea for it?
With quite a bit of testing, yes.
But keep in mind, it is still an outage.
JD
Thanks
On 07/28/2015 01:35 PM, AI Rumman wrote:
But what I read, in-place upgrade has smaller outage, compared to
dump/restore.
Correct, in fact if you do it with the link option, it will be very fast.
But so many articles on having bugs afterwards.
Do you think it is a good idea to use
On 07/24/2015 02:32 AM, Andres Freund wrote:
On 2015-07-24 10:29:21 +0100, Tim Smith wrote:
That's not the point. Backups are important, but so is the concept of
various layers of anti-fat-finger protection. Restoring off backups
should be last resort, not first.
Oh, comeon. Install a
On 07/22/2015 06:24 AM, Tim Smith wrote:
Adrian,
It still doesn't make much sense, especially as given the rather
obscure and questionable design decision of allowing triggers to refer
to truncate ops, but not allowing rules to refer to truncate ops !!!
Actually it makes perfect sense
On 07/22/2015 06:13 AM, Tim Smith wrote:
Melvin,
May I point out that the manual states :
TRUNCATE quickly removes all rows from a set of tables. It has the same
effect as an unqualified DELETE on each table
This is actually wrong. The end result is the same but it does not in
any way have
On 07/22/2015 08:42 AM, Geoff Winkless wrote:
On 22 July 2015 at 16:32, Joshua D. Drake j...@commandprompt.com
mailto:j...@commandprompt.comwrote:
This is actually wrong. The end result is the same but it does not
in any way have the same effect.
in any way?
I'd say
On 07/21/2015 08:34 AM, William Dunn wrote:
Hello Aviel,
On Tue, Jul 21, 2015 at 3:56 AM, Aviel Buskila avie...@gmail.com
mailto:avie...@gmail.com wrote:
How can I set a highly available postgresql in a share-nothing
architecture?
I suggest you review the official documentation on
On 07/21/2015 07:07 PM, Tatsuo Ishii wrote:
But it appears that the fail condition for watchdog is the failure of a
pgpool-II instance. In the configuration described in the wiki you would
put a pgpool-II instance on each Postgres node, and if one of the pgpool-II
instances fails it executes
On 07/21/2015 11:04 AM, William Dunn wrote:
If you dig deeper into pgpool-II you will find that it does not have
failover logic. Its intention is to pool connections and distribute
query load among replicas, but it cannot differentiate node failure from
network partition and cannot promote a
On 07/21/2015 02:48 PM, William Dunn wrote:
Maybe Linux-HA which you recommended is the more promising option for
open source tool.
http://www.linux-ha.org/wiki/Main_Page
The Postgres resource agent appears to monitor the instance by executing
'SELECT now();' which is typically the recommended
On 07/21/2015 01:21 PM, William Dunn wrote:
That's pretty cool! But the intended use of watchdog is so you can have
multiple pgpool-II instances and failover among them
(http://www.pgpool.net/docs/latest/pgpool-en.html#watchdog) rather than
failure of Postgres. In the configuration described in
On 07/21/2015 01:37 PM, William Dunn wrote:
But it appears that the fail condition for watchdog is the failure of
a pgpool-II instance. In the configuration described in the wiki you
would put a pgpool-II instance on each Postgres node, and if one of the
pgpool-II instances fails it executes a
On 07/08/2015 12:47 PM, John McKown wrote:
Why are they converting?
Would EnterpriseDB (a commercial version of PostgreSQL which has
extensions to make it a drop in replacement for Oracle) be a possibility?
http://www.enterprisedb.com/solutions/oracle-compatibility-technology
Because EDB
On 07/04/2015 12:19 PM, Jimit Amin wrote:
ello,
I have heavy transaction load production database 9.3 PPAS .Today
Database is not able to give new process. I checked pg_stat_activity ,
there are so many transaction in waiting stage because of one procedure
and lock on one table (Code inside
On 07/03/2015 04:32 PM, Edson F. Lidorio wrote:
Hello,
PostgreSQL 9.5 Alpha not appear on the downloads list in [1]
Where do I download for Windows?
[1]
http://www.enterprisedb.com/products-services-training/pgdownload#windows
For those in the community who may not know, EnterpriseDB
On 07/01/2015 02:59 PM, Scott Marlowe wrote:
postgresql.
When I try via terminal
apt-get install postgresql-9.3 there are the same messages about
postgresql-common (= 142~) ... defect packages ...
This isn't really a postgresql problem this is a problem with an
ubuntu machine with a broken
On 06/30/2015 09:05 AM, Jimit Amin wrote:
Dear Sir/Mam,
Can I have technical documentation for configuration of PgPool?
http://www.pgpool.net/mediawiki/index.php/Main_Page
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support,
On 06/30/2015 09:35 AM, Jimit Amin wrote:
Dear Sir,
Sorry for this type of question, I have already configured PgPool but
facing 3 issue. That's why I thought that I may have done wrong setup.
I would suggest the pgpool mailing lists.
JD
--
Command Prompt, Inc. -
On 06/29/2015 12:49 PM, Edson Richter wrote:
Dear all,
Another question about WAR archiving: what is the resend policy if
remote storage runs out of space?
The failed archives will be resend automatically in future, or there is
need for manual interation?
They will be resent.
Thanks,
On 06/05/2015 01:56 PM, Tom Lane wrote:
If we have confidence that we can ship something on Monday that is
materially more trustworthy than the current releases, then let's aim to
do that; but let's ship only patches we are confident in. We can do
another set of releases later that
On 06/02/2015 11:08 AM, Steve Pribyl wrote:
They all look like this.
CREATE ROLE dbA
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
And how are you connecting to the database via psql?
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL
On 06/02/2015 11:46 AM, Tom Lane wrote:
Adrian Klaver adrian.kla...@aklaver.com writes:
On 06/02/2015 11:04 AM, Steve Pribyl wrote:
I have noted that GRANT ALL ON SCHEMA public TO public is granted
on postgres.schemas.public. I am looking at this in pgadmin so excuse
my nomenclature.
Is
On 06/02/2015 10:36 AM, Steve Pribyl wrote:
Good Afternoon,
Built a fresh 9.3. postgres server and added some users and noticed that any
user can create tables in any database including the postgres database by
default.
Have I missed some step in securing the default install?
How exactly
On 05/28/2015 12:56 PM, Robert Haas wrote:
FTR: Robert, you have been a Samurai on this issue. Our many thanks.
Sincerely,
jD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing I'm offended
On 05/28/2015 09:56 AM, Ivann Ruiz wrote:
I'm trying to setup streaming replication but I'm stuck, please help!
autovacuum launcher started|
And then nothing else happens, please I really need help with this, I
appreciate all comments. Any questions, please feel free to ask.
I would like
On 05/21/2015 10:01 AM, Daniel Torres wrote:
I everybody, I'm new in the Postgresql world, and have an easy question:
Is it possible to have date type data that only contain month and year?,
how can I obtain that from a timestamp (without time zone) column?
I've made this, but I think the
On 05/19/2015 05:27 PM, Ravi Krishna wrote:
Not sure whether I am understanding this. I checked embedded C and did
not find any section which describes what I have asked, that is the
ability to do multiple inserts, or updates or deletes in one sql call.
For example, if my application does the
On 05/19/2015 04:47 PM, Ravi Krishna wrote:
To explain pls refer to this for DB2
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.cli.doc/doc/r0002329.html
Essentially in one single sql call, we can do
-- Add new rows
-- Update a set of rows where each row is
On 05/06/2015 08:11 AM, Sujit K M wrote:
On Wed, May 6, 2015 at 8:35 PM, Jason May j...@ionicsecurity.com wrote:
You find the description offensive? That’s interesting. You're very easily
offended. I think it reads more like an Engineer than a DBA
lol, you are cribbing like a third
On 05/05/2015 01:13 PM, Suresh Raja wrote:
Hi All:
I have tables with different versions in the same schema. Like
T1a, T1b, T1c
T2a, T2b, T2c, T2d
...
etc.
I'm interested in documenting various version of tables, may be in excel
sheet or may be in another schema in the database.
On 04/29/2015 10:53 AM, Alex Gregory wrote:
Hello-
I have been doing lots of reading and I really want to make sure that I get
this HA architecture I am working on correct. I figured the best way would be
to reach out to the community for advice.
I am installing Cisco Jabber and want to
On 04/29/2015 10:03 AM, John McKown wrote:
I am wondering about useful something might be. So I hope ya'll don't
mind me throwing out for feedback. I am fairly good with standard SQL,
but not the more advanced DBA things such as TRIGGERs. I am reading good
book, PostgreSQL Server Programming to
On 04/22/2015 01:09 PM, Jeff Ferguson wrote:
Hello (PostgreSQL) World,
We recently shipped our streaming-SQL analytics database, PipelineDB
http://www.pipelinedb.com/, which is based on PostgreSQL 9.4, in beta
and are looking for companies to participate as early access partners.
You can read
On 04/15/2015 12:14 PM, Andy Colson wrote:
Postgresql is on version 9. What do you mean version 2 or 3?
He probably means 9.2.7 to 9.3.6. Remember to a lot of people 9 means 9.
That said, pg_upgrade is the way to do this as long as you can have an
outage.
JD
--
Command Prompt, Inc. -
On 03/09/2015 08:57 AM, Adrian Klaver wrote:
On 03/09/2015 08:49 AM, Kevin Grittner wrote:
pinker pin...@onet.eu wrote:
INFO: vacuuming my_table
INFO: my_table: found 0 removable, 3043947 nonremovable row
versions in 37580 pages
DETAIL: 0 dead row versions cannot be removed yet.
So
On 03/02/2015 03:25 PM, David Kerr wrote:
Howdy,
I had an instance where a replica fell out of sync with the master.
Now it's in in a state where it's unable to catch up because the master has
already removed the WAL segment.
(logs)
Mar 2 23:10:13 db13 postgres[11099]: [3-1]
On 01/29/2015 05:05 PM, AI Rumman wrote:
Hi All,
This query are running fine when I am executing them separately.
Can you please let me know what does it mean by
parse unnamed
?
It means you prepared an unnamed statement and it is parsing that statement.
JD
Thanks.
--
Command
On 11/20/2014 08:21 AM, David Gallagher wrote:
Hmm, end of January in Bellingham... Sounds like a great excuse to ski Mt Baker
and beyond :D.
What I find funny is that Mt. Baker (mtbaker.us) is actually the resorts
on Mt. Shuksan. Which is not-arguably more beautiful :D
JD
--
Command
Hello,
Forwarding this because they are having a dedicated PostgreSQL track put
on by PgUS. I hope all will submit papers. This is a great conference of
about 1500. It is 100% non-profit and is a great opportunity to reach out!
Forwarded Message
Subject:[Blug-list]
On 09/13/2014 11:14 AM, Joe Conway wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/13/2014 08:24 AM, Edson Carlos Ericksson Richter wrote:
Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on
Linux?
Yes. It ran great for over a month but once we had some serious data
On 09/10/2014 06:50 AM, Vinayak wrote:
Hello,
We are converting the Oracle's CREATE SYNONYM statement into PostgreSQL.
I think to replace the SYNONYM we use search_path in PostgreSQL and the same
thing is explained in the below post also.
On 05/22/2014 11:25 AM, Torsten Förtsch wrote:
Hi,
time and again I need to build indexes. If they are big, that generates
a lot of WAL data that needs to be replicated to streaming replication
slaves. Usually these slaves don't lag behind noticeably. So, the
application often reads from
On 05/22/2014 12:04 PM, John R Pierce wrote:
On 5/22/2014 11:46 AM, Joshua D. Drake wrote:
This does not appear the domain of PostgreSQL as much as the domain of
your OS and network layer.
I think he's asking for a throttle on create index, so OTHER WAL
activity would proceed at full speed
On 03/21/2014 09:34 AM, Rich Shepard wrote:
Postgresql-9.0.5 is installed in /usr/local/pgsql/ and -9.4's data/
subdirectory is installed in /var/lib/pgsql/9.4/ with the executable in
/usr/bin/.
Running pg_upgrade fails at the end because of a locale difference:
lc_ctype cluster values
On 02/20/2014 12:53 PM, John R Pierce wrote:
On 2/20/2014 12:45 PM, Santo Campione wrote:
We are assessing how to migrate our current (and very old) Oracle
Database 10.1.2.4 to Postgres. Our question/concern is the data to be
migrated is used extensively by custom applications written with
On 02/19/2014 08:49 AM, Alejandro Carrillo wrote:
Hi,
PostgreSQL have a way to put alerts about number of connections,
tablespace used, etc like the DBMS_SERVER_ALERT package of Oracle?
Thanks you
No but any number of monitoring systems already support PostgreSQL:
Zabbix, New Relic,
*way*
Submit a patch. Is that so hard? I don't understand why you are up in
arms about this.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle
;
If you have NULL in the column, you don't have a primary key
Joshua D. Drake
Joey
--
Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
, I would upgrade to 9.2 precisely because it is battle tests, 9.3
isn't but it depends on your particular needs. 9.3 has a lot of cool
stuff in it.
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
PostgreSQL Support, Training, Professional Services
to donate?
Hello,
It depends. If you go to:
http://www.postgresql.org/about/donate/
You can select which non-profit is representative of where you want to
donate.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
PostgreSQL Support, Training
On 09/12/2013 09:37 AM, Merlin Moncure wrote:
On Thu, Sep 12, 2013 at 11:21 AM, Raymond O'Donnell r...@iol.ie wrote:
On 12/09/2013 17:11, Patrick Dung wrote:
By the way, for in-place major version upgrade (not dumping DB and
import again), MySQL is doing a better job in here.
to get a
more informed response.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
For my dreams of your image
On 07/18/2013 01:44 PM, Don Parris wrote:
Maybe I really need something like macros and BASIC or Python to make such
a thing work? If anyone knows a good tutorial on this subject, I can
certainly read - just haven't really found anything yet.
Many thanks in advance,
Hello,
Maybe this will
are local to each instances and it is not a pool, it is a
64bit allocation for each sequence within the local node, generally
constrained only when called from the serial (big serial being 64 bits)
type to 32 bits.
Sincerely,
Joshua D. Drake
Thanks,
Melvin
--
Command Prompt, Inc. - http
Sincerely,
JOshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
For my dreams of your image that blossoms
a rose in the deeps
On 06/28/2013 03:21 AM, bhanu udaya wrote:
Hello,
Grettings,
What is the best way of doing case insensitive searches in postgres
using Like.
Ilike - does not use indexes
function based indexes are not as fast as required.
CITEXT - it still taking 600 ms - 1 second on a 2.2 million rows...
On 06/29/2013 09:24 AM, bhanu udaya wrote:
Upper and Lower functions are not right choice when the table is 2.5
million and where we also have heavy insert transactions.
Prove it. Seriously, just run a test case against it. See how it works
for you. Inserts are generally a very inexpensive
On 06/23/2013 10:33 PM, Andreas Kretschmer wrote:
Arun P.L aru...@hotmail.com wrote:
Hi,
Is there any settings in postgresql version 9.2 similar to mysql strict mode? I
need to get rid of some type casting errors in the upgrading process from
version 7.4 to 9.2, if this mode is not
On 06/21/2013 04:49 PM, Daniel de Oliveira Mantovani wrote:
http://wiki.postgresql.org/images/d/d1/DB2UDB-to-PG.pdf
On 18 June 2013 05:52, sachin kotwal kotsac...@gmail.com wrote:
Function in DB2: BLOB() Criteria: Size of character string targeted for cast
is more than 1GB How can I migrate
On 06/17/2013 01:34 PM, Stuart Bishop wrote:
I've since heard that 3.4 also fixes this issue as well.
What are you using for your IO on these boxes?
I was able to demonstrate it over iSCSI to a Nimble Storage SAN as well as
DAS with 2 drive RAID 1 for xlogs and 8 drive RAID 10 for data
On 06/14/2013 09:12 AM, Bosco Rama wrote:
A colleague mentioned this LKML thread:
http://lkml.indiana.edu/hypermail/linux/kernel/1210.1/00725.html
Seems it was fixed in 3.9.x. I'm wonder if there is any way to easily
determine if the fix was back-ported to the various Ubunutu-maintained
On 06/14/2013 01:47 PM, Andreas wrote:
Am 14.06.2013 20:55, schrieb Peter Geoghegan:
On Fri, Jun 14, 2013 at 11:55 AM, Andreas maps...@gmx.net wrote:
How can I get more memory for PG on openSUSE 12.3 ?
http://www.postgresql.org/docs/9.2/static/kernel-resources.html
OK I think that did
Hello,
I had the distinct displeasure of staying up entirely too late with a
customer this week because they upgraded to 12.04 and immediately
experienced a huge performance regression. In the process they also
upgraded to PostgreSQL 9.1 from 8.4. There were a lot of knobs to
On 06/06/2013 03:48 PM, Scott Marlowe wrote:
On Thu, Jun 6, 2013 at 4:35 PM, Joshua D. Drake j...@commandprompt.com wrote:
Hello,
I had the distinct displeasure of staying up entirely too late with a
customer this week because they upgraded to 12.04 and immediately
experienced a huge
On 05/27/2013 05:43 PM, Sergey Konoplev wrote:
Try this step-by-step instruction
https://code.google.com/p/pgcookbook/wiki/Streaming_Replication_Setup.
I constantly update it when discovering useful things, including low
bandwidth issues.
On Mon, May 27, 2013 at 5:08 PM, Edson Richter
On 05/27/2013 08:13 PM, Edson Richter wrote:
I think the use of PITRTools is probably up your alley here.
JD
Assume I know nothing about PITRTools (which I really don't know!), can
you elaborate a bit more your suggestion?
It is an open source tool specificaly for working with
On 05/23/2013 05:58 AM, Rob Richardson wrote:
Greetings!
Another post on this list suggested using a DO block if the user's Postgres
version is 9.0 or later. The documentation for the DO block says what it is,
but not what it is for. The only benefit I could see for it is allowing the
On 05/10/2013 11:38 AM, Merlin Moncure wrote:
PostgreSQL configuration changes:
synchronous_commit = off
effective_io_concurrency = 4
checkpoint_segments = 1024
checkpoint_timeout = 10min
checkpoint_warning = 8min
shared_buffers = 32gb
temp_buffers = 128mb
work_mem = 512mb
maintenance_work_mem
On 04/16/2013 07:04 PM, ascot.m...@gmail.com wrote:
Hi,
I have managed to install 9.2.4 to an IBM Power System server ppc64 by
compiling pg 9.2.4 from source as I cannot find the 9.2.4 installer package for
ppc64. Can anyone advise me how to build my own installer package for ppc64
(e.g.
it on 4 connections.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
@cmdpromptinc - 509-416-6579
--
Sent via pgsql-general mailing list (pgsql
easier
(and cheaper) to get a lot of external functionality such as replication.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
@cmdpromptinc
it is true that if they can't trust their devs with this problem,
those devs shouldn't have root but that is a business policy problem
whereas ours is an actual security issue.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training
Hello,
It is great to see the Australian market pick up. However, this really
belongs in pgsql-jobs.
Sincerely,
JD
On 01/23/2013 09:21 PM, Cameron Shorter wrote:
I'm hoping this opportunity will be of interest to some of you on this
list:
LISAsoft [0] has expanded our Australian/New
On 01/23/2013 12:45 PM, Gauthier, Dave wrote:
Problem: Some users (scripts actually) try to connect to a DB who's
name is derived from environmental variables. The DB doesn't exist
(yet), and I want them to connect to a different DB for the time being.
Is there a way to define an alias for
On 01/23/2013 02:39 PM, Devrim GÜNDÜZ wrote:
Hi,
Oracle has a product called Oracle Workspace Manager:
http://www.oracle.com/technetwork/database/enterprise-edition/index-087067.html
Website says:
Workspace Manager, a feature of Oracle Database, enables application
developers and DBAs to
://www.commandprompt.com/blogs/joshua_drake/2010/07/a_better_backup_with_postgresql_using_pg_dump/
Sincerely,
Joshua D. Drake
Rich
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle
On 11/05/2012 12:46 PM, Moshe Jacobson wrote:
Is there any practical difference between defining a column as a
varchar(n) vs. a varchar vs. a text field?
No except for your already noted exception that you can limit the size
of varchar.
I've always been under the impression that if I am
On 10/31/2012 12:59 PM, cr...@gtek.biz wrote:
list all role privileges
Google:
site:archives.postgresql.org 'list all role privileges'
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle
On 10/31/2012 03:54 PM, Kevin Burton wrote:
I have successfully installed PostgreSQL on a Ubuntu Linux machine.
However right off the bat I type ‘psql’ and I get the error: ‘role
“” does not exist’. Where xxx is the user name logged in. How do I
overcome this hurdle. Right now all of our
201 - 300 of 2121 matches
Mail list logo