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
EDB: http://www.enterprisedb.com
The Enterprise
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 mailing list (pgsql
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
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
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your
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 log with entries
about routine activities.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
.
--
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
in need 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
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-admin mailing
max_prepared_transactions
set to zero, the latter query is not really necessary.
--
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
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://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via
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 mailing list (pgsql-admin@postgresql.org
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
many cores (not hardware threads) does the machine have? You
will probably have better throughput and latency if you use
connection pooling to limit the number of active database
transactions to somewhere arount two times the number of cores, or
slightly above that.
--
Kevin Grittner
EnterpriseDB
://www.postgresql.org/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 subscription
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 Enterprise PostgreSQL Company
--
Sent
.
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.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin
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
EnterpriseDB: http://www.enterprisedb.com
temporarily got 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
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
does this
for 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
apply all 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
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 list (pgsql-admin
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:
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:
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 assumption?
No. [...] If any indexed column is updated
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 retry.
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 the
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
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:
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.
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.
Could
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
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 second
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:
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 kind
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 changes
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
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 estimates
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
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
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
mean
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
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 of
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
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 information about autovacuum_freeze_max_age: if
autovacuum_freeze_max_age is set to its
[copying the list; please keep the list copied on all replies]
Ramana Panda ramana@gmail.com 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
ramana.pls ramana@gmail.com 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.
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
Craig James cja...@emolecules.com wrote:
Sergey Konoplev gray...@gmail.com wrote:
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 could read, the only
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 do with PostgreSQL; you might have
better luck on a list related to the other
Saravanakumar Ramasamy r...@zoniac.com 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
Craig Ringer ring...@ringerc.id.au 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 with wording
Radovan Jablonovsky radovan.jablonov...@replicon.com 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:
Radovan Jablonovsky radovan.jablonov...@replicon.com 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
Majid Azimi majid.merk...@gmail.com 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
Radovan Jablonovsky radovan.jablonov...@replicon.com 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)
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.
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 down is
Greg Williamson gwilliamso...@yahoo.com 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
lohita nama namaloh...@gmail.com 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
sgm sgm...@yahoo.com.cn 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
Igor Shmain igor.shm...@gmail.com 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
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 gna...@zoniac.com 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
Gnanakumar gna...@zoniac.com 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
Elizandro Gallegos elizandro...@hotmail.com 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
Gnanakumar gna...@zoniac.com 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
Fred Parkinson fr...@abag.ca.gov 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:
Brian Ferhle bri...@consistentstate.com 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
Jan-Peter Seifert jan-peter.seif...@gmx.de 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,
k...@rice.edu 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.
Plugge, Joe R. jrplu...@west.com 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
Hariraman Jayaraj hariraman@gmail.com 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.
Tony Capobianco tcapobia...@prospectiv.com 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?
Mitesh Shah mitesh.s...@stripes39.com 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
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 ricardo.bay...@gmail.com 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
A J s5...@yahoo.com 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.
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, the
L'Huillier, Jeff jeff.lhuill...@onstar.com 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
Wells Oliver wellsoli...@gmail.com 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
Sashbeer Bhandari sashb...@gmail.com 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
Wells Oliver wellsoli...@gmail.com 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
Wells Oliver wellsoli...@gmail.com 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?
[rearranged; please don't top-post]
Wells Oliver wellsoli...@gmail.com wrote:
Kevin Grittner kevin.gritt...@wicourts.gov wrote:
Wells Oliver wellsoli...@gmail.com 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
superman0920 superman0...@gmail.com 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 ?
amador alvarez aalva...@d2.com 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
superman0920 superman0...@gmail.com 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
Reinhard Asmus reinhard.as...@spdfraktion.de wrote:
Am 21.03.2012 14:51, schrieb Kevin Grittner:
Reinhard Asmusreinhard.as...@spdfraktion.de 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
Paul Wouters paul.wout...@resilion.be 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
Reinhard Asmus reinhard.as...@spdfraktion.de 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:
Khangelani Gama kg...@argility.com 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
Rural Hunter ruralhun...@gmail.com wrote:
triggers are not shared between parent and child tables. is it
true?
Yes.
You can use the same trigger *function* for more than one trigger
though.
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to
Piyush Lenka lenka.piy...@gmail.com wrote:
How can i backup only 5 records from that table using pg_dump or psql
or
both.
In psql:
\copy ( select * from that_table where ... ) to 'filename'
http://www.postgresql.org/docs/9.1/interactive/app-psql.html
Search the page for \copy
-Kevin
Rural Hunter ruralhun...@gmail.com wrote:
is it worth mentioning in the doc?
Do you have a suggestion for what language you would have found
helpful, or which section(s) of the docs should be modified?
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make
c k wrote:
One of our customer found that few of it's employees are trying to
change the data without having any proper rights. The simplest way
is to get the control of the server and then change the mode of the
authentication to trust and restart the server.
There's your problem right
umashankar narayanan umashan...@graffiti.net wrote:
Version : 8.3
Below is the log from the server.
-
--
The above is everything that showed up on your post. Make
1 - 100 of 775 matches
Mail list logo