jep
best regards
Hakan Kocaman
Software-Development
digame.de GmbH
Richard-Byrd-Str. 4-8
50829 Köln
Tel.: +49 (0) 221 59 68 88 31
Fax: +49 (0) 221 59 68 88 98
Email: [EMAIL PROTECTED]
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Craig Servi
On Tue, May 23, 2006 at 05:47:31PM +0200, Mario Splivalo wrote:
> I'm doing backup on a second, spare server, by backing up WAL files. I'm
> using that server for analysis queries and reporting. Every 15 minutes I
> need to shut down that server, place in new WAL files, and restart
> server. That i
The way you are reloading is not the right way to reload the configurations. As you are on Windows and have used the installer so a right way to reload your configuration after you have made the change to pg_hba.conf file will be to:
Go to Start --> Programs --> PostgreSQL --> Reload ConfigurationN
Can you clarify this for me? Does this mean that if we are using UTF-8 as the
encoding a like clause will not use the index unless we specify
varchar_pattern_ops as the index operator class?
Craig
On Tuesday 23 May 2006 03:14, Hakan Kocaman wrote:
> Hi,
>
> i think this explains, what you men
Tahir Tamba wrote:
> Hi Guys,
>
> I install Postgres 8.1.3 on WinXP Pro OS using msi.exe. Using Postgres with
> PGAdmin III, everything works well. But when I'm trying to use the psql
> terminal interface to connect into my database psql ask me to enter my
> password and when trying to enter m
Try using\c dbnameand if you want to get rid of the
asking password thing you can change your authentication method from
'md5' to 'trust' in your pg_hba.conf file and then reload the settings
using "pg_ctl reload"
/ShoaibOn 5/23/06, Tahir Tamba <[EMAIL PROTECTED]> wrote:
Hi Guys,I install Postgres
I think first you need to be aware about the nature of the ASCII encoding
within the postgresql server. ASCII encoding means that there is no encoding
at all. So it would be the full responsibility of the client applications to
store and read consistent encodings. Therefore it is clear that the
Hi Guys,
I install Postgres 8.1.3 on WinXP Pro OS using msi.exe. Using Postgres with
PGAdmin III, everything works well. But when I'm trying to use the psql
terminal interface to connect into my database psql ask me to enter my
password and when trying to enter my password, nothing happens fro
On Fri, 19 May 2006, Simon Riggs wrote:
On Thu, 2006-05-18 at 10:08 -0700, Jeff Frost wrote:
May 18 08:00:18 discord postgres[20228]: [129-1] LOG: archived transaction log file
"0001007F"
May 18 08:00:41 discord postgres[20573]: [254-1] LOG: archived transaction log file
"0
On Fri, 2006-05-19 at 08:23 -0700, Jeff Frost wrote:
> On Fri, 19 May 2006, Simon Riggs wrote:
>
> > On Thu, 2006-05-18 at 10:08 -0700, Jeff Frost wrote:
> >
> >> May 18 08:00:18 discord postgres[20228]: [129-1] LOG: archived
> >> transaction log file "0001007F"
> >> May 18 08:00
Jeff Frost <[EMAIL PROTECTED]> writes:
> Do you think the postmaster on 5432 is trying to archive the other
> postmaster's WAL files somehow?
Not as long as they aren't in the same data directory ;-). What Simon
was wondering about was whether an archiver process had somehow been
left over from
On Fri, 2006-05-19 at 08:53 -0700, Jeff Frost wrote:
> On Fri, 19 May 2006, Tom Lane wrote:
>
> > Jeff Frost <[EMAIL PROTECTED]> writes:
> >> Do you think the postmaster on 5432 is trying to archive the other
> >> postmaster's WAL files somehow?
> >
> > Not as long as they aren't in the same data
Jeff Frost <[EMAIL PROTECTED]> writes:
> Well now, will you look at this:
> postgres 20228 1 0 May17 ?00:00:00 postgres: archiver process
> postgres 20573 1 0 May17 ?00:00:00 postgres: archiver process
> postgres 23817 23810 0 May17 pts/11 00:00:00 postgres: archiver p
Oh, yes. It happends at 3am every night.
Does Postgres have some default scheduling?
Thanks,
Nick
>Hello All,
>
>I have just installed PostgreSQL 8.1.3 on FreeBSD 6.0. I have created
>one user postgres only and one test db to play with.
>
>Every night I see in the log the Subj.
>
>Which process
Hello All,
I have just installed PostgreSQL 8.1.3 on FreeBSD 6.0. I have created
one user postgres only and one test db to play with.
Every night I see in the log the Subj.
Which process could produce this error? I see nothing about psql in
postgresql.conf.
I suppose it could be some default da
Hellou all
i have a problem to convert data from utf8 to ascii. My localization is slovakia and we use characters like
'á é š ť' and so on. But many times it is the same if u use 'á' or 'a'. Som I need to translate theese special characters. Somebody told me to use function to_ascii() but this f
I'm doing backup on a second, spare server, by backing up WAL files. I'm
using that server for analysis queries and reporting. Every 15 minutes I
need to shut down that server, place in new WAL files, and restart
server. That is ok, except that I need to backup whole database cluster.
That wasnt't
Hellou all
i have a problem to convert data from utf8 to ascii.
I'm from slovakia and we use special characters like 'á é š ť' and so on. But many times it is the same if u use 'á' or 'a'. So I need to translate these special characters. Somebody told me to use function to_ascii() but this func
On Tue, May 23, 2006 at 03:49:20PM +0200, Meyer Marco wrote:
> I mean the transactions over time interval. Say the current db
> transactions per minute.
See the "Monitoring Database Activity" chapter in the documentation:
http://www.postgresql.org/docs/8.1/interactive/monitoring.html
One way wou
Hi,
I mean the transactions over time interval. Say the current db
transactions per minute.
Thanks
Marco
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 23, 2006 3:41 PM
To: Meyer Marco
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Howto get tran
On Tue, May 23, 2006 at 09:18:19AM +0200, Meyer Marco wrote:
> I've been asked to give the transaction rate of a deployed system. How
> can I mesure this in postgres. Could not find anything in the
> documentation. Are there any tools for this.
What transaction rate? The current rate over some ti
Run the "top" program. You'll see, that Your server CPU time is strongly
take by postmaster. The best way is to have two machines - servers: for
database server and for terminals. Maybe good will be to have more than
one CPU in the one server and run database server on CPU not used by
others ap
Jim C. Nasby wrote:
I think you could get away with doing a CASE or COALESCE statement, ie:
INSERT INTO subscription_purchase ... SELECT
COALESCE(currval('purchase_purchase_sid_seq'), NEW.purchase_sid)
BTW, it would be interesting to share whatever you finally come up with;
it's an interesting
Hello,
we are using PostgreSQL 8.0.3 under SuSE Linux 9.2 and SCO
OpenServer 6.0 and have some perfomance problems. We are working with
telnet-clients, which controlls our application on the server. The application
does the sql-statements
If we have sql-statements e.g. SELECT or UPDATE wh
Hi,
i think this explains, what you ment:
http://www.linuxshare.ru/postgresql/manual/creating-cluster.html
http://www.linuxshare.ru/postgresql/manual/charset.html#LOCALE
So you don't need to set the Locale-Settings on compile-time,
but on initdb-time.
Also check if this applies to your kinds of
Adam Radlowski wrote:
I can't find in the documentation, if it is possible to define our own
sort order for already compiled PostgreSQL.
I need it, because the best for my now building application were be to
build sort with normal LATIN2 sort order (for non alphanumeric chars
compatible with AS
I can't find in the documentation, if it is possible to define our own
sort order for already compiled PostgreSQL.
I need it, because the best for my now building application were be to
build sort with normal LATIN2 sort order (for non alphanumeric chars
compatible with ASCII sort order).
I saw
Title: How to mesure transaction rate in Postgres
Hello,
I've been asked for the transaction rate we have on an installed Postgres server. Where and how can I get this information. I could not find anything in the documentation. I have root access to the system.
Thank you for your Help.
Title: Howto get tranaction rate in postgres
Hello,
I've been asked to give the transaction rate of a deployed system. How can I mesure this in postgres. Could not find anything in the documentation. Are there any tools for this.
Thanx for your help
Marco
There's also an NFS mount point.
It's a long time since I used NFS but when I last did you had the choice
between hard and soft mounts. A hard mount would behave like a physical
drive (and would more-or-less never give up trying to commit a write)
while a soft mount would return an error t
30 matches
Mail list logo
