Hello,
as of now we do a pg_dumpall on most of our PostgreSQL instances. This
has some drawbacks when restore of only one of the databases is
required, because from what i can see pg_restore is not able to limit
the restore to one database?
With pg_dump per database the problem will arise
Zitat von John Nash :
Hi,
Our IT Company systems architecture is based on IBM Websphere
Application Server, we would like to migrate our databases to
Postgres, the main problem which stops us from doing that is Postgres
is not supported by IBM Websphere Application Server.
There is a Request f
Zitat von Reinhard Asmus :
I install a new database and want to check which connections will be used.
How can i see which application from which host is connecting the database?
Any help is appreciated.
Hello
if you only want to check from time to time use something like PGAdmin
(http://w
Zitat von Craig Ringer :
On 22/12/2011 5:41 PM, lst_ho...@kwsoft.de wrote:
Zitat von "Liu, Jianli (Jianli)" :
No one has responded to my questions. I am wondering if anyone can
point me to where in postgresql source code I can further look
into the issue and explore the possibility of this
Zitat von "Liu, Jianli (Jianli)" :
No one has responded to my questions. I am wondering if anyone can
point me to where in postgresql source code I can further look into
the issue and explore the possibility of this change? Thanks.
I was already looking for the same topic but could not fin
Zitat von jan-peter.seif...@gmx.de:
Hello Andreas,
thank you very much for the link.
Original-Nachricht
Datum: Thu, 08 Dec 2011 13:04:30 +0100
Von: lst_ho...@kwsoft.de
Zitat von Jan-Peter Seifert :
> I wonder whether the number of connections is still limited on
> Windows
Zitat von Jan-Peter Seifert :
Hello,
I wonder whether the number of connections is still limited on
Windows 64-bit if you also use a 64-bit version of PostgreSQL:
http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#I_cannot_run_with_more_than_about_125_connec
Zitat von Scott Marlowe :
On Fri, Jul 15, 2011 at 3:39 AM, Scott Marlowe
wrote:
System: SuperMicro H8QG6
4xAMD Opteron(tm) Processor 6168
Total 48 cores
128G RAM
Areca 1680 w 512M battery backed cache
32 15k SAS 147Gig drives
pgbench -i -s 100
pgbench -c 48 -t 1
tps = .626762 (inclu
Zitat von Kevin Grittner :
Jenish Vyas wrote:
I am able to insert 1190- 1210 records per seconds.
Now I just want to know by what extend I could stretch it.
What is the maximum insert I can achieve in one second? What is
the maximum number of insert postgresql achieved so far?
I don't ha
Zitat von Scott Ribe :
Just had a hard crash, and pg came back looking ok. However, crash
was in the driver for the (battery-backed) RAID card, and I know for
a fact that one file that was written to the (journaled) file system
before the crash was not there after reboot. So, what steps are
Zitat von Chris Ernst :
On 04/24/2011 04:21 PM, David Hornsby wrote:
My SMB database is currently running on a HP-UX box running in a master
- slave slonyI cluster to create a hot spare database. Recently the
server has be getting hammered and we are consistently hitting our max
db connections.
Zitat von bilal ghayyad :
Hi All;
I am root and when I do ls /var/lib/pgsql/data, I do not see anything.
Why?
I need to find the pg_h.conf file but not able.
"find / -name pg_hba.conf" is your friend...
Regards
Andreas
smime.p7s
Description: S/MIME Cryptographic Signature
Zitat von "Md. Rakibul Islam" :
Dear Mr. / Ms.
I want to introduce myself, me Md. Rakibul Islam from LEADS
Corporation Limited. For your kind deliberation, LEADS Corporation
is a ISO 9001:2000 certified IT services provider. LEADS delivers a
broad portfolio of IT services and solutions
Zitat von Benoit Clennett-Sirois :
Hi,
We have a front-end server taking care of Nginx, memcached and
Postgresql. Last night the postgres daemon crashed (traffic was very
low at that time) with the following error:
2010-12-20 03:34:30 EST DETAIL: Failed system call was
shmget(key=5432001, siz
Zitat von Martin Povolny :
Hallo,
I have some quite grave problems with dumping and restoring large
databases (>4GB of
dump).
I had 5 databases, 4 dumped ok, the 5th, the largest failed dumping:
I was unable to
make a dump in the default 'tar' format. I got this message:
pg_dump: [tar a
Zitat von Greg Smith :
I've linked to everything I'm aware of at
http://wiki.postgresql.org/wiki/Category:Benchmarking and the TPC-H
page has probably the most relevant information for OLAP.
PostgreSQL doesn't do particularly well on OLAP benchmarks yet due
to how queries are limited by
Zitat von Peter Koczan :
Hi all,
I'm having some trouble configuring ident authentication for TCP
connections. I can get it to work fine for local connections, but I
can't
Local connection:
$ psql postgres
...
postgres=>
Server Log:
Dec 9 11:06:59 mitchell postgres[27482]: [4-1] LOG: conne
Zitat von Aras Angelo :
I have this server, Dual Intel Xeon 2.83GHz w 4gb ram.
My shared buffers were set to 1756 MB.
We have a high traffic e-commerce site, yesterday like 8 uniques.
We cache most of our dynamic pages to disk so its wierd we are experience
really slow response times with p
Zitat von Jan Muhammad :
Hi,
I have just downloaded, installed/configured postgresql version
8.2.11 on Fedora Core 6. While reading through the installation
manual have setup most of its parts; now while trying to run
datebase server with the command:
$ postmaster -D /usr/local/pgsql/d
Zitat von Suresh Borse :
Dear All,
How to migrate existing database which in Oracle to postgres?
Please provide me the solution/limitation for triggers , procedure ,
packages & views while migrating.
Thanks & Regards,
Suresh Borse
(DBA)
Not long ago someone posted the following link
htt
Zitat von Fabricio <[EMAIL PROTECTED]>:
Hi...
I have an IBM server with NUMA architecture, two nodes with 4 CPU
quad core and 64 GB of RAM each, and PostgrSQL 8.3.5. Is there any
way to avoid the performance degradation when the load goes up and
used the two nodes? I understand this per
21 matches
Mail list logo
