hanks.
Dave.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
script as is... listed below.
Appreciate any feedback/comments.
Dave
# $FreeBSD: ports/databases/postgresql7/files/pgsql.sh.tmpl,v 1.9 2000/12/11
03:22:07 steve Exp $
#
# For postmaster startup options, edit $PGDATA/postmaster.opts.default
# Preinstalled options are -i -o "-F"
case
o rectify.
Dave
>-Original Message-
>From: Tom Lane [mailto:[EMAIL PROTECTED]]
>Sent: Sunday, March 10, 2002 11:22 AM
>To: Dave
>Cc: [EMAIL PROTECTED]
>Subject: Re: [ADMIN] Postgres not starting at boot(FreeBSD) - startup
>script not releasing
>
>
>"Dave"
nd not in in-progress state
.NOTICE: AbortTransaction and not in in-progress state
DEBUG: Data Base System shutting down at Sun Mar 10 14:37:28 2002
DEBUG: Data Base System shut down at Sun Mar 10 14:37:28 2002
done.
postmaster successfully shut down.
web5#
Thats interesting, per
Bingo! Dumb move. Dropped everything to password a few months back, never had
the occasion to restart after that. Will work on tweaking the pg_hba.conf
Thanks Matthew... if you are ever in Toronto, I owe you a beer.
Dave
>At a guess, you've set it up to not automatically trust loc
, and needs to access database tables and such...
as such it should be able to connect to and do whatever as needed... trusted
4) no one else should from any other machine should be able to access any
database resources on this server
mods, misconceptions, problems?
thanks
Dave
I am looking at it.
I do appreciate the response Tom.
Dave
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
t transaction id: 1081353; next oid: 37710
DEBUG: database system was not properly shut down; automatic recovery
in progress
DEBUG: ReadRecord: record with zero length at 0/DC2A454
DEBUG: redo is not required
DEBUG: database system is ready
DAVE
---
1024 Nov 24 13:58 ..
Scanning /var/tmp/scanmails5063/unpacked/*
Scanning file /var/tmp/scanmails5063/unpacked/mm.VBPik2
Scanning file /var/tmp/scanmails5063/unpacked/Navidad.exe
/var/tmp/scanmails5063/unpacked/Navidad.exe
Found the W32/Navidad@M trojan !!!
Info on the virus can be fo
nction not implemented) id=-2
FATAL 1: AttachSLockMemory: could not attach segment
%
Searching for jail faq's and posts regarding this matter produces some
close, but not helpful posts regarding chroot'ed environments.
Any insights, requests for details, and assistance are appreciated.
Dave
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: 23 February 2001 22:29
> To: Dave Page
> Cc: [EMAIL PROTECTED]; 'PostgreSQL Admin News'
> Subject: Re: [ADMIN] select * from pgadmin_users; causes error
>
>
> Dave Page <
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: 23 February 2001 15:23
> To: [EMAIL PROTECTED]
> Cc: 'PostgreSQL Admin News'; Dave Page
> Subject: Re: [ADMIN] select * from pgadmin_users; causes error
>
>
> John Hatfie
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: 23 February 2001 21:07
> To: Dave Page
> Cc: [EMAIL PROTECTED]; 'PostgreSQL Admin News'
> Subject: Re: [ADMIN] select * from pgadmin_users; causes error
>
>
> Dave Page <
nning with at least -B 1024 if you can.
Just try this:
explain select * from where =
(Use for fieldname an indexed field).
If postgres is using an sequential scan in stead of an index scan. You have
to vacuum your database. This will REALLY remove deleted data from your indexes.
Hope it will work,
Dave Mertens
System Administrator ISM, Netherlands
If you want to see your linux box in network neighbourhood, you have to
run samba on the linux box!
See: http://www.samba.org
regards,
Dave
Silky Mittal wrote:
>
> Dear Sir,
> Thanks for your precious advice now things have
> started working but now we are facing other pro
Title: Irrevocable privileges
I think it's silly that any privileges that an owner grants to himself are
essentially irrevocable. It's silly because it makes changing the object
owner pointless. Consider:
User joe creates table foo
User joe grants permission rw to himself on foo
User
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 10, 2005 6:11 PM
> To: Dave Held
> Cc: [email protected]
> Subject: Re: [ADMIN] Irrevocable privileges
>
>
> "Dave Held" <[EMAIL PROTECTED]> writes:
Or,
Kill -s SIGINT
Thanks,
Anjan
-Original Message-
From: Gourish Singbal [mailto:[EMAIL PROTECTED]
Sent: Friday, May 13, 2005 9:27 AM
To: Ing. Jhon Carrillo
Cc: [email protected]
Subject: Re: [ADMIN] how do i kill user sessions?
you can try.
1) ps -ef | grep "postgres"
I use kill -s SIGINT
Thanks,
Anjan
-Original Message-
From: Brandon Hines [mailto:[EMAIL PROTECTED]
Sent: Friday, May 13, 2005 2:32 PM
To: [email protected]
Subject: [ADMIN] Killing a Query
Is there a method for killing a query from the server.
I have a number of users that
For logging the queries taking 5+ seconds, try this:
In postgresql.conf:
syslog = 0# range 0-2; 0=stdout; 1=both; 2=syslog
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
log_min_duration_statement = 5000
Then, in your pg startup script (etc/init.d/Postgresql), you want to
have somethin
Probably some kind of a hardware issue
(you lost a path to the array for e.g.), or someone may have issued a kill -9
to postmaster?
Open another terminal and check the system
log (/var/log/messages) if you are not redirecting logs anywhere.
Can you paste the console messages on the
From: Andrew Janian
[mailto:[EMAIL PROTECTED]
Sent: Friday, June 17, 2005 4:37
PM
To: Anjan Dave;
[email protected]
Subject: RE: [ADMIN] startup
subprocess hangs
Do you want me to stop the recovery to get
the console messages? After issuing the start command I did not
Hi,
A developer is trying to use a Temporary Table via the java based
application. The problem is following the temp table creation, he wants
subsequent queries to query the temp table, but they are not in the same
database session as the temp table. Is this something I can setup somewh
Why don't you copy/move the entire data directory (minus pg_xlog if you are
separating them)
-Original Message-
From: Sergiusz Jarczyk [mailto:[EMAIL PROTECTED]
Sent: Wed 9/28/2005 3:34 PM
To: [email protected]
Cc:
Subject: Re:
Thanks - fix committed to svn.
Regards, Dave
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bastiaan
WakkieSent: 03 October 2005 17:04To: Andreas
PflugCc: PostgreSQL-development; pgadmin-hackers;
[email protected]: Re: [pgadmin-hackers
I've been through a similar situation before (partition was full, and
subsequently, PG wasn't able to access a pg_clog/.
Tom Lane had referred me to another archive about zeroing out that
particular file, which had worked for me and the database was up.
And yes, don't shutdown the machine like th
e this helps (and doesn't put
you off)!
Regards,
Dave
Not sure if the kernel shared memory segment size is appropriate, you are
allocating all your memory to the chunk.
With 32GB memory, effective_cache_size can be raised, higher, and you can go
down on shared_buffers. Check this:
http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e
Check in the contrib directory of the
source tree. Techdocs.postgresql.org site also has some to download I believe.
-anjan
From: Laureen Lampe
[mailto:[EMAIL PROTECTED]
Sent: Friday, December 16, 2005
12:01 PM
To: [email protected]
Subject: [ADMIN] startup scripts
Hi, I just had to cancel one VACUUM FULL (of a 4.3m row table) that someone ran in business hours. It was after an hour or so that I realized, and it was blocking queries, running out of connections, so I cancelled it. Are there any bad side effects of cancelling an ongoing full vacuum of a t
no trouble installing on Win XP Pro on my desktop, but am stumped on
XPhome.
Can anyone push me in the right direction?
Thanks for your time
:-)Dave
--
___
Play 100s of games for FREE! http://games.mail.com/
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hi,
Recently I restored a database from 7.4.1 (RHAS3.0) to 8.0.3
(RHAS4.0), and now we are running into locale issues:
[22:03] WARN SECUserDAO () - Problem retrieving user by username.
org.sourceforge.jxutil.sql.I18nSQLException: sqlError[invalid multibyte
character for locale]
…
Can also use a startup script from the contrib directory of the source.
-Original Message-
From: sandhya [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 21, 2006 7:14 AM
To: Paolo De Simone; [email protected]
Subject: Re: [ADMIN] problems to install PostgreSQL
Instead of exec
Title: Message
Hi All:
I am trying to restore a database on a
different machine (7.2.3 on Sol9 to 7.2.4 RH8), and i get the following error,
that i haven't seen before:
-bash-2.05b$ pg_restore -d access -Ft -a
access.dump.tarpg_restore: [tar archiver] could not open TOC file for input:
F
Hi All:
I am trying to restore a database on a different machine (7.2.3 on Sol9 to 7.2.4 RH8),
and i get the following error, that i haven't seen before:
-bash-2.05b$ pg_restore -d access -Ft -a access.dump.tar
pg_restore: [tar archiver] could not open TOC file for input: File too large
Segmen
Title: Upgrading from 7.2.4 (RH 8) to 7.4 (RH9)
Hi,
I would like to start planning on upgrading a few servers from RH8 to RH9, essentially, also upgrading Postgres from 7.3.2 to 7.4 from the OS.
There's also a box with RH7.3 (postgres 7.2.1) that could be upgraded to RH9 and Postgres 7.4.
Title: GRANT in pg7.2
Hi,
I need some help for the following:
Is there a way I can assign EXECUTE privilege for a user-defined function in the GRANT command in 7.2? (7.3 has it)
Also, how do I list all the user-defined functions/stored procedures. Once listed, how to give UPDATE privile
Title: Database taking up space rapidly
Hi All,
I just moved over a db from 7.2.3 to 7.4.0 on a new RH9 server.
The dump, I remember was about 2GB, 350MB compressed, when I restored it only about 3-4 days ago…
Now, the slice stands at about 30GB!!
/dev/sda2 50830616 300348
...
Thanks,
Anjan
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Fri 12/26/2003 6:29 PM
To: Anjan Dave
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Database taking up space rapidly
"Anjan Dave" <[EMAIL PROTECTED]> writes:
> Here's
Chuck,
Report bugs to <[EMAIL PROTECTED]>.
-bash-2.05b$ psql -c 'select version();' template1
version
-
PostgreSQL 7.2.3 on i686-pc-linux-gnu,
e. [...]
How about typing the "WHERE" part of the statement first, then
'left-arrowing' back to the start of the statement and do "DELETE FROM
..." *last*?
Dave.
--
Dave Ewart
[EMAIL PROTECTED]
Computing Manager, Epidemiology Unit, Oxford
Cance
Title: Message
Dear
All:
I am trying to
restore a database (size is about 7GB) from a dump file created by a simple
backup script..The format is data.pg.
The schema restores
fine, but during the data restore, i get the following
error:
-bash-2.05b$
pg_restore -a -d access backups/ac
PMTo: Anjan
DaveCc: [EMAIL PROTECTED]Subject: Re: [ADMIN]
pg_restore data block errorDear Anjan Dave ,
-bash-2.05b$
pg_restore -a -d access backups/access/data.pg
pg_restore:
[custom archiver] could not read data block -- expected 4096, got
3608To me this seems
riday, February 27, 2004 5:24 PM
To: Anjan Dave
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [ADMIN] pg_restore data block error
"Anjan Dave" <[EMAIL PROTECTED]> writes:
> Same error again.
> -bash-2.05b$ pg_restore -a -d access
> backups/access/data
tly
possible; you just need to decide what you're going to use to decrypt it
afterwards.
Dave.
- --
Dave Ewart
[EMAIL PROTECTED]
Computing Manager, Epidemiology Unit, Oxford
Cancer Research UK
PGP: CC70 1883 BD92 E665 B840 118B 6E94 2CFD 694D E370
-BEGIN PGP SIGNATURE-
Version: G
milar legislation in Italy and elsewhere.
Suggestions:
1. You need to decide which fields in the database should be encrypted.
2. Perhaps keep all 'personal' data in a separate table and control
access to that table more closely with database permissions.
Optionally, encrypt the contents
llow this - there's no point AT ALL in using LoopAES if you
can mount the encrypted partitions without needing manual intervention
at boot time.
Dave.
--
Dave Ewart
[EMAIL PROTECTED]
Computing Manager, Epidemiology Unit, Oxford
Cancer Research UK
PGP: CC70 1883 BD92 E665 B840 118B 6E94 2
On Friday, 05.03.2004 at 12:51 +, Silvana Di Martino wrote:
> Alle 09:51, venerdì 5 marzo 2004, Dave Ewart ha scritto:
> > I guess there may similar legislation in Italy and elsewhere.
>
> Actually, the Italian law is an implementation of a EU directive
> strictly inspired
uestion.
But as you say, encrypting 'the whole database' in some way is probably
safest ...
If you find any 'automated' front-end to do this at the database-level,
rather than something like loopback at the filesystem level or at the
field level for specific fields, I think th
- there's no point AT ALL in using LoopAES if
> > you can mount the encrypted partitions without needing manual
> > intervention at boot time.
>
> Why not, Dave? As far as I understand it, one of the major values of
> fs-level data encryption was protection from the abu
If it helps in future, I use this script (don't remember where I had
found it..) to backup the databases on disk, and then the backup
directory can be backed up to the tape --
#!/bin/sh
# Backup PostgreSQL
TMPDIR=/var/lib/pgsql/backups
export TMPDIR
echo $TMPDIR
# dump each database schema/dat
ps -eaf | grep postgres | grep -v idle (the last grep will get the actual command, and
not the idle connection)
If you have the stats_command_string enabled, you can also do a
$echo "select * from pg_stat_activity" | psql dbname
Thanks,
Anjan
-Original Message-
From:
Can I use the pg_dump from 7.4.1 on 7.4.2?
I tried copying a couple of libraries that it needed, and I can
copy one-by-one that it looks for, but I am not sure how many does it need in
all for the new version to work…
Purpose is to dump/restore a pretty good-sized db (19GB) on
7.2.4
ch is what I wanted to try.
-anjan
-Original Message-
From: Peter Eisentraut [mailto:[EMAIL PROTECTED]
Sent: Monday, April 05, 2004 1:36 PM
To: Anjan Dave; [EMAIL PROTECTED]
Subject: Re: [ADMIN] Use 7.4.1's pg_dump in 7.2.4?
Anjan Dave wrote:
> Purpose is to dump/restore a pretty
Corey,
In my case, I have tried using the 7.4.1 pg_dump in 7.2.3, and it was
missing a lot of libraries...did that happen in your case?
I am wondering if it's really possible in the first place.
Thanks,
Anjan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: W
Yes, you can create an index on the oid, but unless you are selecting on
it, it is of little use.
you would have to do select * from foo where oid=? to get any value out
of the index.
Dave
On Mon, 2004-04-26 at 12:38, Edoardo Ceccarelli wrote:
> I am using the oid of the table as the main
.
>
> Even better though is to not use oids at all, of course...
>
> Chris
>
>
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>
> !DSPAM:408
Edoardo,
Are you using them for referential integrity? If so you would be wise to
use sequences instead.
Christopher: yes you are correct, I wasn't sure if that is what he was
doing.
Dave
On Tue, 2004-04-27 at 11:01, Christopher Kings-Lynne wrote:
> > AFAIK, oids aren't u
We use XEON Quads (PowerEdge 6650s) and they work nice, provided you configure the
postgres properly. Dell is the cheapest quad you can buy i think. You shouldn't be
paying 30K unless you are getting high CPU-cache on each processor and tons of memory.
I am actually curious, have you researched
: Tue 5/11/2004 4:28 PM
To: Anjan Dave
Cc: [EMAIL PROTECTED]; Pgsql-Admin (E-mail)
Subject: Re: [PERFORM] Quad processor options
Anjan Dave wrote:
> We use XEON Quads (PowerEdge 6650s) and they work nice,
> provided y
g the entire table.
Dave
On Wed, 2004-06-09 at 23:39, Shanmugasundaram Doraisamy wrote:
> Dear Group,
> We are using Postgresql 7.3.4 on Redhat 8.0 with
> Java 1.4.2. We are developing our applications in Java. We call stored
> procedures from
Hi,
I recently upgraded from 7.2.4 to 7.4.1, but can’t
install the contrib rpm.
# rpm -ivh postgresql-contrib-7.4.1-1PGDG.i386.rpm
error: Failed dependencies:
perl(Pg) is
needed by postgresql-contrib-7.4.1-1PGDG
I installed the ‘postgresql-pl-7.4.1-1PGDG.i386.rpm’
pack
ility, and Load Balancing.
pgpool ftp://ftp.sra.co.jp/pub/cmd/postgres/pgpool/pgpool-2.0.8.tar.gz
and if you prefer java C-JDBC
http://c-jdbc.objectweb.org/
Dave
On Wed, 2004-08-18 at 06:10, JM wrote:
> Hi All,
>
> I just came off an exibit and I was wondering if there ways to
> -Original Message-
> From: Robert Treat [mailto:[EMAIL PROTECTED]
> Sent: 21 September 2004 12:27
> To: Magnus Hagander
> Cc: Bender, Cheryl; [EMAIL PROTECTED]; Dave Page;
> [EMAIL PROTECTED]
> Subject: Re: [ADMIN] windows docs?
>
?
> I'm th
All:
What’s the best way to separate pg_xlog to another
drive? I am using a soft link currently in the data directory (per docs), but
is there another way of doing this?
Thanks,
Anjan
osed to make the MD5 hash using Username, Password
and Salt, and forward that back for authentication. However it appears that
something is failing at the negotiation stage, and the client is trying to
use crypt, or perhaps the server is suggesting that crypt be used.
Any suggestion
Hi,
I need some help in bringing back this db please.
The partition ran out of space from an import process. I cleared up the space
and attempted to start the postgres service again, but it doesn't start and i
get following in the message log.
HINT: This probably means that some data is co
3f640b9ac1/d6bc3c75eed6c2a4?q=could+not+access+status+of+transaction#d6bc3c75eed6c2a4
Tom, is the issue resolved after 7.4.1?
Thanks,
Anjan
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon 2/21/2005 11:42 AM
To: Anjan Dave
Cc: [email protected]
Subject: Re: [ADMI
Hi,
I need some help on a logging situation. I am logging the
stdout to a file (/var/log/pglogs) like this:
In Postgresql.conf:
**
syslog =
0
# range 0-2; 0=stdout; 1=both; 2=syslog
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
Hi,
I need help compiling 7.4.7 please… It’s not
able to find readline library, when the package is already installed…
checking for readline... no
configure: error: readline library not found
If you have readline already installed, see config.log for
details on the
failure. It i
Thanks guys that did it!
Anjan
-Original Message-
From: Uwe C. Schroeder [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 30, 2005 11:43 AM
To: Anjan Dave
Cc: [email protected]
Subject: Re: [ADMIN] compilation problem with readline
you need to install the readline-devel
ng to lots of lists!
-l 2 is extremely unlikely to cause excessive CPU or IO, but it will
clutter logs, so you wouldn't want to leave it on permanently.
Regards, Dave
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, plea
all access?
Probably a mistake I made somewhere along the line... just not sure where,
usually I get my pgsql install working great!
Thanks
Dave
gt; DETAIL: Function's final statement must be a SELECT.
> CONTEXT: SQL function "check_for_null"
>
> Any suggestions why this happens ??
Choose pl/pgsql as the language, not SQL.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Wed, May 14, 2008 at 9:38 PM, Premil Agarwal <[EMAIL PROTECTED]> wrote:
> Tried that already, still the same error
It (using plpgsql instead of sql) works fine for me using your code.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-admin mailing li
Assuming you are are running 8.3, you can do this:
SELECT a.typname,b.enumlabel from pg_type a , pg_enum b where
a.oid=b.enumtypid and a.typname='NAME_OF_ENUM';
Chirag Dave
Afilias
On Mon, Sep 22, 2008 at 9:20 AM, Jagadeesh <[EMAIL PROTECTED]> wrote:
> Hi admins,
>
&g
rent version is 8.3.4 and I'm wondering why there
>> are no new rpm's for Opensuse ?!?!
>
> The answer is quite simply that no one is volunteering to do the work.
Oh, I thought you were looking after that build. If it's not being
maintained, we'll need to re
l look at doing that. We need the SUSE builds also.
Great, thanks Simon. If you can commit to ongoing maintenance then
we'll get you on the packagers list so you can get advance notice of
releases and having input on the scheduling details.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb
tats ? if table/tables are candidate for vacuuming after
crash recovery will never get auto-vac unless you do 'ANALYZE' twice.
Thanks in advance,
Chirag Dave
DBA
Afilias
What version of postgres are you running ? and please also provide more
information about your suspected slowdown ?
On Tue, Oct 7, 2008 at 4:21 PM, Rafael Domiciano <[EMAIL PROTECTED]
> wrote:
> Hello there,
> I'm having some slowndowns in my postgresql server, and I had been reading
> someth
running, to log all slower statement.
Chirag Dave
DBA, Afilias
On Wed, Oct 8, 2008 at 8:31 AM, Rafael Domiciano <[EMAIL PROTECTED]
> wrote:
> The server is running Postgres 8.2.4When the server is doing too much
> operations like I, U or D the postgres stop a while each 5 min...!
> I
nt of my work for the sake of
> knowledge share.
I think you forgot the attachment. It would be useful if you could add
it to the wiki though: http://wiki.postgresql.org/
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgre
ich can do
> more than assist you.
We don't have a converter, though we do have experience in this area
of course. Our Advanced Server product has direct support for pl/sql
however so you can run your code unmodified.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
--
Sen
Help?
Just configured a Slony-I cluster, two nodes, Centos 5.2 x64, master
logging errors like the excerpt below almost continuously. stopped the
slon daemons, and dropped replication on each node for now.
There were two file sets, one of 7 tables, and another of 21 tables. I
believe it was in
ard pane.
- Select the 'Keyboard Shortcuts' tab
- At the bottom, select the Full keyboard access: All controls option.
or, just press Control+F7 from anywhere.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
PGDay.EU 2009 Conference: http://2009.pgday.eu/start
--
f I turn on all controls, if I turn it off, I
get the behaviour you describe. I'm not sure what else to suggest.
(and please, Dave, not Mr Page :-) )
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
PGDay.EU 2009 Conference: http://2009.pgday.eu/start
--
Sent via pgsql-admin maili
Admin (NOT DBA!) language for me? If
it involves reading manuals or whitepapers, that's fine. If it involves
reading source code, I'm game to give it a try. If it involves years of
study in database theory, I think it needs to be a little simpler than
that!!
Many thanks
--
Dave Barton
Senior
Hi everyone,
I am looking for some Master-Master replication solutions for
PostgreSQL database. Please let me know if you are using one and if
you are happy with the performance.
Thanks
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
htt
You other option is to use Slony. Create replica and in a short outage you
can move master to replica.
Chirag Dave 416-673-4102
Database Administrator, Afilias Canada Corp.
[email protected]
On Wed, May 5, 2010 at 11:27 AM, raghu ram wrote:
> Hi Postgres Guru's,
>
>
>
On Thu, May 13, 2010 at 5:11 PM, Plugge, Joe R. wrote:
> Nevermind ... I RTFM ...
>
> echo "alter table mytable ENABLE REPLICA TRIGGER check_lockout;" | psql
> mydb
>
This is not good idea. Always run DDL script using Slony execute script.
http://www.slony.info/documentation/ddlchanges.html
SELECT reads
> from.
>
You can also use pg_stat_database view. you can compute cache reads
percentage of the total number of reads (cache and physical) between the two
snapshots using pg_stat_database.blks_hit and pg_stat_database.blks_read.
Chirag Dave 416-673-4102
Datab
On Wed, May 26, 2010 at 5:25 AM, Cédric Villemain <
[email protected]> wrote:
> 2010/5/25 Chirag Dave :
> >
> >
> > On Tue, May 25, 2010 at 1:48 PM, Balkrishna Sharma
> wrote:
> >>
> >> Hi,
> >> I am increasing the share
On Fri, May 28, 2010 at 6:56 PM, Bruce Momjian wrote:
> Marc G. Fournier wrote:
>> On Fri, 28 May 2010, Bruce Momjian wrote:
>>
>> >
>> > I talked to Dave Page and it seems the pginstaller (non-bitRock) Win32
>> > installers were _not_ moved fr
record with zero length at 0/2501DBB4
LOG: redo is not required
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
Any pointers would be appreciated; I'm far from an expert on either
Solaris or PostgreSQL, so it's very possible that I'm making o
es in fact have the function it's griping about
(ldap_simple_bind) in both the 32-bit and 64-bit versions.
--
Dave Pooser
Cat-Herder-in-Chief, Pooserville.com
"...Life is not a journey to the grave with the intention of arriving
safely in one pretty and well-preserved piece, but to sl
possibly try symlinking that to the version-numbered library.
Yep, and I did that to get past the configure problems, which allows me to
encounter a whole new problem in make :^)
>If all else fails you could --disable-thread-safety.
Is that safe to do on a server with a few dozen concurrent user
[1385] |104232| 760|FUNC |GLOB |0|12 |ldap_sasl_bind
[1309] |104992| 327|FUNC |GLOB |0|12 |ldap_sasl_bind_s
It seems there's some magic incantation to REALLY bind that I'm just not
seeing here. Any help gratefully accepted.
--
Dave Pooser
Cat-H
ight as well file a bug with Oracle, not that I expect them to be in any
hurry to improve compatibility with a rival DB.
--
Dave Pooser
Cat-Herder-in-Chief, Pooserville.com
"...Life is not a journey to the grave with the intention of arriving
safely in one pretty and well-preserved piece,
and too exhausted to put in the
Google-time looking for a step-by-step guide. Maybe this evening, unless
you can hit me with a step-by-step off the top of your head.
--
Dave Pooser
Cat-Herder-in-Chief, Pooserville.com
"...Life is not a journey to the grave with the intention of arriving
safely
I apologize if this is not the correct list to post this in, but I just
noticed that libpqxx is not in the yum repos for the 32-bit builds of RHEL.
Would it be possible to add them to the 32-bit repos?
Thanks,
Dave
1 - 100 of 117 matches
Mail list logo
