ything about broken
connections or client not responding?
Also, the pooler might maintanin some *minimum* number of
connections but go beyond that "on demand". Without knowing what
pooler and how it is configured, it's hard to say what might be
going on.
--
Kevin Grittner
E
not enough information to give much advice. Please read
this page and start a new thread on the pgsql-performance list:
http://wiki.postgresql.org/wiki/SlowQueryQuestions
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin ma
t if they all become active at one time, you can
have a seemingly-random server overload.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
hat direction a little at a time and watch the behavior. I
do think that periodic VACUUM ANALYZE statements (weekly?) of the
database might be a good supplement to the autovacuum jobs,
especially if you have a time when load tends to be lower to
schedule that in.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
ht pay to move to partitioning, so that a group of
rows could be deleted pretty much as fast as you can drop a table.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
es, table truncation after a large number of deletes is now
smarter, getting more done with less effort and blocking. This
message, which was useful for developing the fix, made it into
production at the LOG level. In the next minor release it will be
changed to the DEBUG level to avoid cluttering the
After getting past this crisis, I would take a close look at your
vacuuming regimen -- it sounds like it is not aggressive enough to
keep you out of trouble.
I'm sorry that I don't have a better suggestion for resolving the
crisis than running VACUUM at maximum speed.
--
Kevin Grittner
d of VACUUM was a shared table
and it just happened to mention db1 because that was the database
it was scanning at the time. (Every database includes the shared
system tables in its catalog.)
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsq
a couple large tables which take long enough
to scan to prevent small, frequently-updated tables from getting
attention soon enough, you might want to boost
autovacuum_max_workers, too.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admi
;);
select * from pg_prepared_xacts where prepared < (now() - interval '1 minute');
You can, of course, adjust the intervals to what makes the most
sense for your environment. If you have max_prepared_transactions
set to zero, the latter query is not really necessary.
if that's what you mean.
> Which means it is consistent at the time that the pg_start_backup
> is run.
No. It will be consistent with the time that pg_stop_backup was
run, or any later point in time that you choose, as long as you
have WAL to that point in time.
--
Kevin Grittner
EDB: http://
pg_dumpall client had an
error writing, due to permissions problems or disk space
exhaustion, and the reason needs to be found on the "client" side,
not in the server log.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mai
to have problems.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
to increase to 32 GB.
Well, you could try that; if the symptoms get worse, then you might
be willing to go the other direction
> max_connections = 500 and ~400 connections average
How many cores (not "hardware threads") does the machine have? You
will probably have better throughpu
rg/docs/9.2/interactive/backup.html
Of course, the machines must be of the same architecture.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscri
"Struckhoff, Kevin" wrote:
> From: Kevin Grittner [mailto:kgri...@ymail.com]
>> "Struckhoff, Kevin" wrote:
>>> I've installed postgres 9.2 on a server, call it db01. I now want
>>> to access postgres from my app server, call it app01.
>&g
seems that something else is missing or needs to be done.
> Googling wasn't much help, the results weren't current.
How are you trying to connect, and what happens when you try?
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
--
Kevin Grittner
EnterpriseDB: http://www.ent
target was done while normal production hit the
database, without too much of a performance hit. With this
technique we were able to let users in with near-normal performance
with 10 or 15 minutes of down time rather than hours.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The E
t Albe assumed you deleted or truncated the
underlying disk file rather than using the DELETE or TRUNCATE SQL
statement.
In any event, more details would help people come up with ideas on
what might be wrong.
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
--
Kevin Grittner
Ent
large, shrank again, and then wrapped around to the
beginning of the table's file space. In some cases performance was
so impaired that when such an event was triggered they would shut
down their application until a manual VACUUM could be run.
--
Kevin Grittner
EnterpriseDB: http://www.enter
you.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
fects on the explicit command were
unintended and should be reverted.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
of those bug fixes and see if you can make it
happen again.
In general, it pays to apply fixes as they become available.
http://www.postgresql.org/support/versioning/
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing l
ne
replica. To avoid stalls on the master, you may want to define
multiple synchronous replicas, so that when one goes down you keep
running without DBA intervention.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing
ally want to avoid RULES, especially where a trigger works
so well.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Benjamin Krajmalnik wrote:
> Kevin Grittner wrote:
>> Benjamin Krajmalnik wrote:
>>> I also assume that if no data has changed in an index, nothing
>>> is done when the record is updated as pertains to the
>>> particular index - am I correct in this assumpt
Benjamin Krajmalnik wrote:
> From a performance standpoint, is there a big hit on select performance
> if a query ends up utilizing more than one index, taking into account
> that an index has been used already to reduce the data set of potential
> records, and the secondary index would mostly be
Benjamin Krajmalnik wrote:
> It is ok if I am a little bit behind. What setting do
> I need to tweak to allow it to get further behind?
The relevant settings are described here:
http://www.postgresql.org/docs/9.0/interactive/runtime-config-wal.html#RUNTIME-CONFIG-REPLICATION
http://www.postgresq
Benjamin Krajmalnik wrote:
> I have 2 servers which are using streaming replication (pg 9.0.4).
>
> The secondary server is there primarily as a disaster recovery server,
> but we are also using it for reporting, so as not to place undue load on
> the primary server.
>
> As I review the logs on
Vinod V wrote:
> Below were the error messages that we were getting ... (while
> restarting the server).
>
>
> 2013-01-10 01:58:46 PST LOG: could not bind IPv6 socket: No error
> 2013-01-10 01:58:46 PST HINT: Is another postmaster already running on port
> 5432? If not, wait a few seconds and r
suhas.basavaraj12 wrote:
> We will be dumping data from version 9.0 and restore to 9.1.
That should work fine, as long as use use pg_dump from version
9.1 to dump the 9.0 database.
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
h
Armin Resch wrote:
> one needs to evaluate to what extent an upgrade of postgres is contained
PostgreSQL minor releases (where the version number matches to the
left of the second dot) only contain fixes for bugs and security
vulnerabilities. Dependencies on other packages should not change.
htt
Baptiste LHOSTE wrote:
> These queries are very simple : delete from table where
> start_date < availableTimestamp. We performed an EXPLAIN to try
> to understand what could be the problem. The query planner said
> that the index on start_date could not be used because it was not
> up-to-date.
Co
Baptiste LHOSTE wrote:
>> Just so we know how to interpret that, how many minutes, hours,
>> or days did you wait to see whether it would ever end?
>
> I have waiting for 15 minutes in this state. I can not wait more
> time without losing some data for our client.
Thanks. I wasn't suggesting you
satish kumar wrote:
> How to convert Mysql procedures to Postgresql Functions using migration
> tools.
http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscript
Kong Man wrote:
> The postgresql.conf file has always been using the default value, which is
> 'warning'.
Maybe it's not using the postgresql.conf file you think it is. Does
this show the file you've been looking at?:
SHOW config_file;
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admi
Baptiste LHOSTE wrote:
>> Was the blocking you described occurring at the time you
>> captured this? It doesn't seem to be showing any problem.
>
> Yes indeed. We have noticed that any process seems to be in
> waiting situation but :
> - before the autovacuum process starts to work on the both k
Baptiste LHOSTE wrote:
> Here's the pg_stat_activity during the issue :
> [no processes waiting]
> Here's the pg_locks during the issue :
> [all locks granted]
Was the blocking you described occurring at the time you captured
this? It doesn't seem to be showing any problem.
> Is there a way to
Baptiste LHOSTE wrote:
> - finally we delete old data of the second kind of tables
> Then the autovacuum process starts to work on the second kind of
> tables, but our process blocks into step 3 (truncate) or step 5
> (create index).
>
> As soon as I reset the autovacuum thresholds for the seco
Shams Khan wrote:
> select now()-query_start as runtime,client_addr,pid,query from
> pg_stat_activity where not query like '%IDLE%' order by 1;
> When I check Idle session running question, shows the many queries running
> but end of the query it shows Rollback and commit which take lot of time.
Shams Khan wrote:
> Question 1. How do we correlate our memory with kernel parameters, I mean
> to say is there any connection between shared_buffer and kernel SHMMAX. For
> example if I define my shared buffer more than my current SHMMAX value, it
> would not allow me to use that ??or vice versa.
amjad usman wrote:
> ERROR: index row size 3176 exceeds maximum 2712 for
> index "description_department_of_aeronautics_and_astronautics_5_pkey"
Can you show us the definitions of the table and the index?
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make change
Shams Khan wrote:
> *PERFORMANCE WAS BOOSTED UP DRASTICALLY* ---when I edited the
> work_mem to 100 MB---just look at the difference;
You only showed EXPLAIN output, which only shows estimated costs.
As already suggested, try running both ways with EXPLAIN ANALYZE --
which will show both estimate
Shams Khan wrote:
> *Need to increase the response time of running queries on
> server...*
> 8 CPU's and 16 cores
> [64GB RAM]
> HDD 200GB
> Database size = 40GB
Without more info, there's a bit of guesswork, but...
> maintenance_work_mem = Not initialised
I would say probably 1GB
> effecti
Haifeng Liu wrote:
> I wanna know if executeBatch really keep all the records in a
> batch untouched when the batch failed.
I recommend asking on the pgsql-jdbc list. You might want to
mention what autoCommit is set to during the attempt.
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-adm
Sabry Sadiq wrote:
> Does it work well with version 9.1.3?
It might work better in 9.1.6:
http://www.postgresql.org/support/versioning/
And it would probably pay to keep up-to-date as new minor releases
become available.
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.or
Aaron Bono wrote:
> (there are currently a little over 200 active connections to the
> database):
How many cores do you have on the system? What sort of storage
systeme? What, exactly, are the symptoms of the problem? Are there
200 active connections when the problem occurs? By "active", do you
m
Baptiste LHOSTE wrote:
>> Please show us the output from running this query:
>>
>> http://wiki.postgresql.org/wiki/Server_Configuration
> [very reasonable settings except for a very large work_mem]
Make sure that work_mem setting isn't driving you into swapping or
near-zero caching. A shortage
Baptiste LHOSTE wrote:
> Today I consulted the log of my PostgreSQL server and I saw that
> autovacuum tasks took to much time to do their work. I thought that
> ANALYZE was a fast operation ?
That depends on configuration settings and on whether the computer
(or VM) is so swamped that the autova
Adrian Heath wrote:
> I am unable to click on the Ok button to close the dialog box or
> either of the pgAdmin screens. I can drag the dialog box around the
> screen but cannot close it. Only option is to terminate the pgAdmin
> process.
You might want to try posting this on the pgadmin-support l
Bruce Momjian wrote:
> On Wed, Sep 12, 2012 at 10:13:38PM -0500, Kevin Grittner wrote:
>> Radovan Jablonovsky wrote:
>>
>>> In documentation
>>> http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html
>>> is this inform
[copying the list; please keep the list copied on all replies]
Ramana Panda wrote:
> I am using the Version : *"PostgreSQL 8.0.0 on i686-pc-mingw32,
> compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)"*
You didn't even keep up on bug fix releases? It's amazing that your
database is still r
Radovan Jablonovsky wrote:
> In documentation
> http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html
> is this information about autovacuum_freeze_max_age: "if
> autovacuum_freeze_max_age is set to its maximum allowed value of a
> little less than two billion". What is exact maximum
"ramana.pls" wrote:
> I am getting an error while restoring the Database Backup. I am
> postgre sql 8.0 with Windows XP O.S.
PostgreSQL version 8.0 has been out of support overall for years,
and out of support for Windows for years before that.
http://archives.postgresql.org/pgsql-announce/2
Craig James wrote:
> Sergey Konoplev wrote:
>> Bruce Momjian 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 could read, the only exception
would be if I was using a
CS DBA 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 do with PostgreSQL; you might have
better luck on a list related to the other technologies.
FWIW, on Li
"Saravanakumar Ramasamy" wrote:
> Now I am using postgres 9.1.3 version . Before I am used 8.2.22
> ERROR: function to_number(unknown, numeric) does not exist
> HINT: No function matches the given name and argument types. You
> might need to add explicit type casts.
> I found solution. T
[Forwarding to the -hackers list. Please respond there.]
Craig Ringer wrote:
> On 08/09/2012 04:24 AM, Kevin Grittner wrote:
>> http://wiki.postgresql.org/wiki/Number_Of_Database_Connections
>>
> Can we please please PLEASE link to that as a comment above
> max_connection
Craig Ringer wrote:
> On 08/09/2012 04:24 AM, Kevin Grittner wrote:
>> http://wiki.postgresql.org/wiki/Number_Of_Database_Connections
>>
> Can we please please PLEASE link to that as a comment above
> max_connections?
>
> Last time this came up nobody was happy wit
Radovan Jablonovsky wrote:
> PostgreSQL version 9.1.1 with 32GB of RAM
> shared_buffers = 8GB
> temp_buffers = 32MB
> work_mem = 64MB
> maintenance_work_mem = 512MB
> Currently there are maximum 600 connections.
Please read:
http://wiki.postgresql.org/wiki/Number_Of_Database_Connections
Radovan Jablonovsky wrote:
> In usual load there are not much pressure on memory, but it is
> possible to have all clients start using heavy reports. They are
> valid requests and could consume all memory.
Your clients will get their results back faster if you can arrange
some way to queue the
Majid Azimi wrote:
> ran VACUUM ANALYZE on it(it is not VACUUM FULL). but this cause
> the database to completely block.
Please show the results from running the query here:
http://wiki.postgresql.org/wiki/Server_Configuration
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@post
Radovan Jablonovsky wrote:
> We are running PostgreSQL version 9.1.1
You should apply the latest bug fixes by updating to 9.1.4.
http://www.postgresql.org/support/versioning/
> with 32GB of RAM, 32GB of SWAP and during high load we could reach
> (swap + RAM) memory limit.
If you're even
Mike Broers wrote:
> Ultimately the hosting service restored the files that they had
> not brought over during their maintenance migration and we started
> up ok. So that was a relief.
+1
> We had archived log files but it did not appear that the archive
> destination was caught up with the
wangqi wrote:
> An SQL execution is very slow.
> What can I do to makes it faster。
Without knowing more about the version of PostgreSQL, your PostgreSQL
configuration, your schema (including indexes), and your hardware,
it's hard to give advice.
http://wiki.postgresql.org/wiki/SlowQueryQuest
Mike Broers wrote:
> Mike Broers wrote:
>> We shut down our postgres 8.3 server last night cleanly for some
>> hosted services maintenance. When we got our server back, it didnt
>> have the pg_xlog mount with files and now when we start the
>> server, it complains
>> Since we had a clean shut
Greg Williamson wrote:
> I've got an 8.4.11 system that I am relatively new to and I am
> seeing multiple autovac processes kick off on several of the
> largest tables at once and it is causing pain.
>
> Are there any suggestions to
>
> a) quickly relieve the immediate pain
Set autovacuum_
lohita nama wrote:
> I am working as sql dba recently our team had oppurtunity to work
> on postgres databases and i had experience on sql server and on
> windows platform and now our company had postgres databases on
> solaris platform
>
> can u please suggest how to take the back up of postgr
sgm wrote:
> I have a question about PITR backup in a single server, the method
> is make a base backup, and backup the WAL archive log(eg, every
> day at 11:30 pm). But if the OS' harddisk is broken(eg,14:00
> pm),the system can't start, we have to recover the database on a
> another server usi
"Igor Shmain" wrote:
> Would it be possible for you to mention what hardware (cpu, ram,
> disks, etc.) and software your system uses to support this db size
> and number of transactions?
We have 4 Intel Xeon X7350 @ 2.93GHz for 16 cores with 128GB RAM.
We've got a pair of drives in RAID 1 fo
"Igor Shmain" wrote:
> I need to design a solution for a database which will grow and will
> require horizontal split at some moment.
Just one more bit of "food for thought" -- we have a database with
3TB processing approximately 50 million database transactions per day
(some with a great many
"Gnanakumar" wrote:
> I've already thought of converting this into a document and keep
> it handy so that I may want to refer back whenever I need.
I've put up a first cut at such a document as a Wiki page:
http://wiki.postgresql.org/wiki/Number_Of_Database_Connections
Everyone should feel
Elizandro Gallegos wrote:
> Please can I be removed from the mailing list
The answer was in the email to which you responded. Did you have
trouble using the referenced page?
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
-Kevin
--
Sent via pg
"Gnanakumar" wrote:
>> We get very good performance dealing with thousands of concurrent
>> users with a pool of 35 connections to the database.
>>
>> If you want to handle more users than you can currently support,
>> you probably need to use fewer database connections.
>
> First, please excuse
Brian Ferhle wrote:
> I've got a situation where I need to increase
> max_pred_locks_per_transaction value to allow the addition of a
> slony node to complete on postgres 9.1. We had this issue before
> and we increased the default value from 64 to 128, but now we have
> a sync that takes even l
"Fred Parkinson" wrote:
> 2. Is there way to tell psql NOT to clear the screen, so I can
> subsequently view it while I work?
\pset pager off
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pg
"Gnanakumar" wrote:
> our web-based application has crossed more than 500 concurrent
> users. Hence we've already upgraded RAM and now we want to
> upgrade max connection parameter too. Yes, we're already using
> pgpool-II v3.1.1 for connection pooling.
The main point of using a connection p
"Jan-Peter Seifert" wrote:
> I wonder whether extra measures are necessary to recover from a
> disk full error besides freeing enough disk space?
> Is it no problem if the WAL is within the same disk space and
> can't be written as well?
> Should you free enough disk space, do a checkpoint,
"k...@rice.edu" wrote:
> You may also want to consider setting a statement_timeout to
> prevent this until you can find the problem with the application.
How would a statement timeout help close a transaction on an idle
connection? It's idle because no statements are being run.
-Kevin
--
"Plugge, Joe R." wrote:
> Using postgres 9.0.7 on RHEL 5.4. I have a parent table that is
> partitioned by day. My inserts are working correctly and are
> being directed to the correct child table. I also have both an
> UPDATE and DELETE trigger on the parent table that are defined as
> AFTER
Mitesh Shah wrote:
> *pg_dump: server version: 9.1.2; pg_dump version: 9.0.5*
> *pg_dump: aborting because of server version mismatch*
This is not a bug. Use a version of pg_dump which is at least as
new as the server. The older version of pg_dump is unlikely to be
able to recognize everythi
Tony Capobianco wrote:
> I've issued the following statement:
>
> grant select on all tables in schema support to backup;
>
> How can I avoid having to issue the grant each time I create a new
table?
http://www.postgresql.org/docs/9.0/interactive/sql-alterdefaultprivileges.html
Also, please
Hariraman Jayaraj wrote:
> We are using postgres 8.3 in Open Suse 11 server.
> Front end - Java, struts
> Middle ware - Jboss
> Backend - Postgres 8.3 DB.
It helps to know the exact version number and PostgreSQL
configuration settings.
http://wiki.postgresql.org/wiki/Server_Configuration
>
Bèrto ëd Sèra wrote:
> I'm asked to benchmark a PG-related product. I was wondering if
> there is any "sort of standard" public dataset for such operations.
You might want to take a look at pgbench:
http://www.postgresql.org/docs/9.1/interactive/pgbench.html
-Kevin
--
Sent via pgsql-admin
Ricardo Bayley wrote:
> Does anybody know if it is possible to create a PL which sends an
> http GET request and retrieves its response ?
Have you looked at PL/Python?
http://www.postgresql.org/docs/current/interactive/plpython.html
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admi
A J wrote:
> In FTS, how do I search for partial substrings that don't form a
> English word.
> Example, in the text: 'one hundred thirty four' I want to find
> the records based on 'hun'
>
> SELECT to_tsvector('one hundred thirty four') @@
> to_tsquery('hun'); does not return anything.
It sou
"F. BROUARD / SQLpro" wrote:
> in every database there is a file nammed pg_filenode.map wich I
> suppose give the map of the real filenode while some command make
> a divergence betwen the actuel object oid and the "new" filenode...
> Am I wright ?
If you want to understand internals like this
Wells Oliver wrote:
> Looking at PGAdmin, "in recovery?" is "yes", but replay location
> is the same as receive location, and the data is absolutely up to
> date.
>
> Is the recovery bit an issue, or just SOP?
SOP. It's due to the gradual evolution of the hot standby feature
from the transac
"L'Huillier, Jeff" wrote:
> When enabling WAL archiving and setting up the archive_command, is
> it possible to add the date & time as an extension to the %f
> copied to the archive directory in order to avoid overwriting a
> file of the same name?
The recommended behavior is to exit the recov
[rearranged; please don't top-post]
Wells Oliver wrote:
> Kevin Grittner > Wells Oliver wrote:
>>
>>> I'd like to create a schema on my slave so that users who do not
>>> have access to the master can create some data. Clearly this
>>> data
Wells Oliver wrote:
> I'd like to create a schema on my slave so that users who do not
> have access to the master can create some data. Clearly this data
> won't be replicated, since it's on the slave, but will it cause
> any problems w/ data integrity to have it on the slave?
What are you us
Wells Oliver wrote:
> I admit to being scared as crap of rsync'ing a live database to
> another server. Like chills are running down my spine even typing
> it. Is this an approved, safe thing?
It is fine, as long as you're doing it between the pg_start_backup()
and pg_stop_backup() calls. We
Sashbeer Bhandari wrote:
> I am using Postgresql DB 8.2 and my encoding is in SQL_ASCII ,. I
> want to convert it in UTF8, Please help me it.
This has nothing to do with the thread on which you posted it.
Please start a new thread with an appropriate subject line.
By the way, PostgreSQL ver
superman0920 wrote:
> i have a table which has 850 rows record, i run 30 threads to
> update the record.
> i find the database of processing data speed so slow, per thread
> updating 1000 rows need take 260s
> How to configure the database to make processing speed faster ?
Performance iss
amador alvarez wrote:
> I am trying to find any kind of information or examples to deal
> with custom conflict resolution on swap syncs in a master-master
> replication.
What are you using for replication?
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make cha
superman0920 wrote:
> i want to insert a report to postgresql，the report contain
> something Chinese characters and the postgresql is utf-8.
>
> the response from db is this:
> ERROR: invalid byte sequence for encoding "UTF8": 0xb1
That's not a valid byte sequence for a character under the
"Paul Wouters" wrote:
> We have some problems using pg_dump. We get the following error:
>
> pg_dump: schema with OID 145167 does not exist
Make sure you have a copy of the entire PostgreSQL data directory
tree before trying to fix corruption.
> In the table pg_depend I have also e referenc
Reinhard Asmus wrote:
> Am 21.03.2012 14:51, schrieb Kevin Grittner:
>> Reinhard Asmus wrote:
>>
>>> when i make a sort this is the result:
>>
>>> [vowel with umlaut sorts equal to vowel without]
>>
>>> in german this is wrong. what is the
Reinhard Asmus wrote:
> when i make a sort this is the result:
> [vowel with umlaut sorts equal to vowel without]
> in german this is wrong. what is the problem?
It appears to be one of three different "right" ways:
http://en.wikipedia.org/wiki/German_alphabet#Sorting
Is there a differ
Khangelani Gama wrote:
> the issue we have is that we have many Linux users having root
> access into the system.
Which gives them rights to impersonate any other user on the system
and to erase any audit trail written on that system.
> Auditors wants PostgreSQL to tell who updated what insi
1 - 100 of 832 matches
Mail list logo
