Maarten Deprez wrote:
>>> My dbmail server using postgresql produces a lot of warnings about '\\'
>>> in strings. The particular string it is complaining about is escaped by
>>> EscapeBytea, and included in single quotes (not E''). Is it all right to
>>> set standard_compliant_strings to on?
>>
>>
Hi,
I have already done so ;-)
Also looking over the postgresql.conf file, I have changed the
checkpoint_segments to 128. From what i understood of the of the PerfList
page, this should not effect performance (only use up HD space), and the
write performance of the database is OK with this setti
Then you should set it to 100 or so. It helps to keep the number of
connections down to something reasonable.
On Wed, May 21, 2008 at 12:06 AM, Andy Dale <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I currently have max_connections set to 300, however if i think about it we
> will never have that many co
Hi,
I currently have max_connections set to 300, however if i think about it we
will never have that many connections (more like 50 - 100 at most).
Cheers,
Andy
2008/5/20 Scott Marlowe <[EMAIL PROTECTED]>:
> On Tue, May 20, 2008 at 8:14 AM, Andy Dale <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> >
On Wed, May 21, 2008 at 4:14 AM, Vlad Kosilov <[EMAIL PROTECTED]> wrote:
> as Greg pointed out: my use of rsync --remove-sent-files option had
> contributed to a short sized wal log file on standby.
> changing master's postgres crontab to the following helped to resolve the
> issue:
>
> # ship log
On Tue, 2008-05-20 at 17:04 -0400, Andrew Sullivan wrote:
> On Tue, May 20, 2008 at 08:56:41PM +0200, Ivan Sergio Borgonovo wrote:
>
> > I just would like to have a coherent snapshot of some tables.
>
> If you have a multi-statement transaction, then if you are in READ
> COMMITTED you can see ch
as Greg pointed out: my use of rsync --remove-sent-files option had
contributed to a short sized wal log file on standby.
changing master's postgres crontab to the following helped to resolve
the issue:
# ship logs to standby:
*/2 * * * * rsync -aq /wal_archive_local/ 10.10.10.12::wal_archi
A typo on my part in my posting. My Makefile has:
SHLIB_LINK = -lgsl -lgslcblas
Regards
John
Quoting Martijn van Oosterhout <[EMAIL PROTECTED]>:
> On Mon, May 19, 2008 at 06:23:03PM +0100, [EMAIL PROTECTED] wrote:
> > Thanks for the reply. My GSL libraries, 'libgsl' and 'libgslcblas', are in
On Tue, May 20, 2008 at 08:56:41PM +0200, Ivan Sergio Borgonovo wrote:
> I just would like to have a coherent snapshot of some tables.
If you have a multi-statement transaction, then if you are in READ
COMMITTED you can see changes, and if you are in SERIALIZABLE you
can't. You can't of course s
I've played about with DIA and the transform tool I can't remember the
name of right no that takes DIA input and creates DDL commands. not
bad.
But I keep coming back to a big white board... :)
On Tue, May 20, 2008 at 7:13 AM, Enrico SABBADIN <[EMAIL PROTECTED]> wrote:
> Hi, I'm evaluating diff
I need to add a field to a fairly large table. In the same alter
statement I'd like to add a FK constraint on that new field. Is there
any way to avoid the check of the table that the database is doing
right now? The check is pointless because the newly added field is
nothing but NULLs.
T
On Wed, 2008-05-21 at 02:43 +0930, Shane Ambler wrote:
> Yes - The only way to do it is DROP VIEW... then CREATE VIEW... - the
> catch is any other views that depend on the view you wish to drop.
Tip: It's sometimes useful to rename an existing view or table to
deprecate it. (I use names like _s
Hi,
Today one of the disk was marked as as failed and now some files
are corrupted.
I've decided to copy the pgsqldata directory and try to fix PG_VERSION
(see below for information - what PostgreSQL don't like) files ... and
see if the database will come up.
During copying files and etc.
Thanks Karsten!
Yes, there was another config file in another directory!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Karsten Hilbert
Sent: Tuesday, May 20, 2008 10:36 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] psql: FATAL: Ident auth
On Fri, 16 May 2008 09:55:56 -0400
Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> On Fri, May 16, 2008 at 09:06:11AM +0200, Ivan Sergio Borgonovo
> wrote:
> > Is
> > BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE
> > what I'm looking for?
>
> Yes.
OK...
What if I want to avoid the rollback proble
I have some scripts that connect to my 8.2 postgres server using ident
authentication, and maybe ~10% of the time, authentication fails like so:
2008-05-20 00:22:54 UTC LOG: invalidly formatted response from Ident server:
"49205 , 5432 : ERROR :dba
"
xinetd's logs show normal auth act
On Tue, May 20, 2008 at 8:14 AM, Andy Dale <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am currently trying to tweak Postgresql 8.1, to improve the overall
> performance of the database. I have read over the following page/artical
> http://www.powerpostgresql.com/PerfList/, however at the moment (not fo
On Tue, May 20, 2008 at 09:47:55AM -0700, Dan Joo wrote:
> Is there a command that I can use to find out which file PG is looking
> into for the settings in pg_hba.conf? Could it be that the config file
> is not even titled "pg_hba.conf"?
http://www.postgresql.org/docs/8.3/static/runtime-con
J. Manuel Velasco - UBILIBET wrote:
Hello,
The DB I am using has views. I need to modify the view adding one
field to the QUERY that build the query.
When I edit the VIEW and add the field, I get the error that tells me
"It's not possible to change columns number in a view"
So, do I need to re
Great suggestion!
I renamed it to "pg_hba.conf_tmp", and I can still log into PG. There
is another linux box in the network and changed the title of the
pg_hba.conf file as well, and still allows me to log in to PG.
Is there a command that I can use to find out which file PG is looking
into fo
On Tue, May 20, 2008 at 09:17:03AM -0700, Joshua D. Drake wrote:
> > The only non-commented lines are:
> >
> > [EMAIL PROTECTED] data]# cat pg_hba.conf | grep -v '^#'
> >
> > local all all trust
> > hostall all 127.0.0.1/32 tru
Hello,
The DB I am using has views. I need to modify the view adding one field
to the QUERY that build the query.
When I edit the VIEW and add the field, I get the error that tells me
"It's not possible to change columns number in a view"
So, do I need to remove the complete VIEW and create
On Tue, May 20, 2008 at 08:50:16AM -0700, Dan Joo wrote:
> The only non-commented lines are:
>
> [EMAIL PROTECTED] data]# cat pg_hba.conf | grep -v '^#'
>
> local all all trust
> hostall all 127.0.0.1/32 trust
> hostall
On Tue, 2008-05-20 at 08:50 -0700, Dan Joo wrote:
> Hi Karsten,
>
> The only non-commented lines are:
>
> [EMAIL PROTECTED] data]# cat pg_hba.conf | grep -v '^#'
>
> local all all trust
> hostall all 127.0.0.1/32 trust
> host
Hi Karsten,
The only non-commented lines are:
[EMAIL PROTECTED] data]# cat pg_hba.conf | grep -v '^#'
local all all trust
hostall all 127.0.0.1/32 trust
hostall all ::1/128 trust
Dan
-Ori
On Tue, May 20, 2008 at 08:24:30AM -0700, Dan Joo wrote:
> /home/djoo[8:25am]$ %psql kermit -U postgres
>
> psql: FATAL: Ident authentication failed for user "postgres"
> confused why I can't access. Is there another file that I need to alter
> besides the pg_hba.conf file?
That depends on
On Sun, May 18, 2008 at 02:04:56PM +0200, Ivan Sergio Borgonovo wrote:
> What is the effect of having nested functions all declared
> SERIALIZABLE?
You can't do that. You have to declare SERIALIZABLE right at the
beginning of the transaction, or it won't work (and, IIRC, it throws
an error). Th
Hi Luigi,
It is Linux. I am trying to login as postgres but as a user not in the
database. This is because I will be creating a web front end, and
various users, not registered in the database, will need to access the
database. Thus, as "postgres" I can log in fine:
bash-3.1$ psql kermit
> From: Greg Smith [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 19, 2008 9:03 PM
>
> So, yes, in 8.3 it's possible that you can have sequential
> scans of large
> tables or the VACUUM data pass through the buffer cache, but
> not remain in
> it afterwards. I didn't think George would ever r
I wrote:
> My dbmail server using postgresql produces a lot of warnings about '\\'
> in strings. The particular string it is complaining about is escaped by
> EscapeBytea, and included in single quotes (not E''). Is it all right to
> set standard_compliant_strings to on?
Laurenz Albe wrote:
> Dep
Perhaps meant for the list.
Original Message
Subject: Re: [GENERAL] i am looking for postgresql hosting server
Date: Tue, 20 May 2008 09:03:37 -0500
From: Vitaliyi <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
References:
<[EMAIL PROTECTED]>
<[EMAIL PROTECTED]>
<[EMAIL PROT
glene77is wrote:
On May 14, 3:27 pm, [EMAIL PROTECTED] (Sam Mason) wrote:
On Wed, May 14, 2008 at 02:08:47PM -0400, Justin wrote:
Sam Mason wrote:
What doesfoxprouse for storing numbers? or is it just that you never
pushed it hard enough for the abstractions to show through.
On Wed, May 14, 2008 at 10:36:31AM -0500, David McNett wrote:
> If the view is limited as you describe, don't use is.
Ah, of course, that was the best advice amongst all :-)
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
--
Sent via pgsql-ge
Hi,
I am currently trying to tweak Postgresql 8.1, to improve the overall
performance of the database. I have read over the following page/artical
http://www.powerpostgresql.com/PerfList/, however at the moment (not for
much longer hopefully) my hands aree tied when it comes to altering the
kerne
On Tue, May 20, 2008 at 7:11 PM, Kevin Hunter <[EMAIL PROTECTED]> wrote:
> At 4:36a -0400 on Tue, 20 May 2008, paragasu wrote:
> > I am looking for postgresql dedicated hosting.
>
> Have you looked at the Postgres site?
>
> http://www.postgresql.org/support/professional_hosting
>
> If you're to be
On May 14, 3:27 pm, [EMAIL PROTECTED] (Sam Mason) wrote:
> On Wed, May 14, 2008 at 02:08:47PM -0400, Justin wrote:
> > Sam Mason wrote:
> > >What doesfoxprouse for storing numbers? or is it just that you never
> > >pushed it hard enough for the abstractions to show through.
>
> > I know i pushed it
Christophe,
I agree with Dr. DeSoi that it may not always be possible to automate
schema transformations. However, if you need to compare the metadata
between two databases, the free, open-source SchemaCrawler for SQL
Server tool will do this for you. You can take human-readable
snapshots of the s
Hi, I'm evaluating different er modeling tools .. I have to support the same
logical db on postgresql and sqlserver ..
All tools I tried so far ignore the schema information .. all tables end up
living in the default schema.
What can you suggest ? thank you
PLS: reply directly as well
B
Maarten Deprez wrote:
> My dbmail server using postgresql produces a lot of warnings about '\\'
> in strings. The particular string it is complaining about is escaped by
> EscapeBytea, and included in single quotes (not E''). Is it all right to
> set standard_compliant_strings to on?
Depends.
You
J Ottery wrote:
> I am trying to distribute PostgreSQL with my applications but and need
> to simplify the installation procedure as much as possible for obvious
> reasons.
>
> Installing it to Windows environments only.
>
> Currently I prompt the end user to just start the postgre-8.3.msi
> inst
At 4:36a -0400 on Tue, 20 May 2008, paragasu wrote:
> I am looking for postgresql dedicated hosting.
Have you looked at the Postgres site?
http://www.postgresql.org/support/professional_hosting
If you're to be your own sysadmin/dba, you might also consider something
like slicehost. I've heard a
Hello,
In my db I have created a view that read data from a remote table
using dblink, I can modify the remote table using a couple of rules on
the view. My problem arise when I try to get the number of affected
rows since dblink_exec returns such information in a result set
instead of putting it
Hello.
My dbmail server using postgresql produces a lot of warnings about '\\'
in strings. The particular string it is complaining about is escaped by
EscapeBytea, and included in single quotes (not E''). Is it all right to
set standard_compliant_strings to on?
Greetings,
Maarten
paragasu wrote:
> i am planning to use postgresql server as a database backend of my project.
> currently, i have mysql5 database hosted on my VPS.
> my VPS only have 512MB ram and i already install many server inside.
> Apache2, Dovecot, postfix
> to name a few.
>
> I am looking for postgresq
J Ottery wrote:
> I am trying to distribute PostgreSQL with my applications but and need
> to simplify the installation procedure as much as possible for obvious
> reasons.
>
> Installing it to Windows environments only.
>
> Currently I prompt the end user to just start the postgre-8.3.msi
> inst
i am planning to use postgresql server as a database backend of my project.
currently, i have mysql5 database hosted on my VPS.
my VPS only have 512MB ram and i already install many server inside.
Apache2, Dovecot, postfix
to name a few.
I am looking for postgresql dedicated hosting. I just wa
I am trying to distribute PostgreSQL with my applications but and need
to simplify the installation procedure as much as possible for obvious
reasons.
Installing it to Windows environments only.
Currently I prompt the end user to just start the postgre-8.3.msi
install from an icon.
This however
On Mon, May 19, 2008 at 08:38:09PM +0200, Scott Marlowe wrote:
> OK. Assuming that the 50G is mostly dead space, there are a few
> possibilities that could be biting you here, but the most likely one
> is that your Free Space Map settings aren't high enough to include all
> the rows that have been
Klint Gore, 20.05.2008 09:39:
Thomas Kellerer wrote:
Hi,
I'm trying to download the HTML version of the manual (8.3.1). It does
not seem to be part of the Windows installer any more. Instead the a
chm version is included.
At http://www.postgresql.org/docs/manuals/ it says the HTML can be
down
Thomas Kellerer wrote:
Hi,
I'm trying to download the HTML version of the manual (8.3.1). It does
not seem to be part of the Windows installer any more. Instead the a
chm version is included.
At http://www.postgresql.org/docs/manuals/ it says the HTML can be
downloaded in the FTP area, but I c
Hi,
I'm trying to download the HTML version of the manual (8.3.1). It does not seem to be part of the Windows installer any more. Instead the a chm version is included.
At http://www.postgresql.org/docs/manuals/ it says the HTML can be downloaded in the FTP area, but I cannot find any download
zax zax wrote:
I installed postgresql on my pc
...
put it short: my whole pc slowed dramatically
...
my pc became useless
I tried uninstalling postgresql, freezing and slowing remained
i tried system restore, freezing and slowing remained
It's nothing to do with PostgreSQL then. It can't
52 matches
Mail list logo
