I'm running PostgreSQL 9.2 on Windows Server 2012 and I've attempted to
follow these instructions for single sign-on:
http://wiki.postgresql.org/wiki/Configuring_for_single_sign-on_using_SSPI_on_Windows
I followed the simplified instructions for 9.2 and successfully executed
the setspn command rec
ould this setup work for failover, or is it only for situations where a
user might exist on primary.example.com but not on backup.example.com?
--
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 wel
Awesome. That was amazingly quick.
Thanks,
Dave
On Sun, Apr 8, 2012 at 1:29 PM, Devrim GÜNDÜZ wrote:
>
> Hi,
>
> On Sat, 2012-04-07 at 21:35 -0700, Dave Johansen wrote:
> > Yes, I think that I'll be using 9.0, but I also noticed that 8.4
> > doesn't have t
Yes, I think that I'll be using 9.0, but I also noticed that 8.4 doesn't
have them either.
Thanks a ton,
Dave
On Fri, Apr 6, 2012 at 1:37 AM, Devrim GÜNDÜZ wrote:
>
> Hi,
>
> On Thu, 2012-04-05 at 11:27 -0700, Dave Johansen wrote:
> > I just noticed that libpqxx is
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
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
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,
[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
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
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
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
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
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
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 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
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,
>
>
>
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
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
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
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
--
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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]
…
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, 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
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
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
e this helps (and doesn't put
you off)!
Regards,
Dave
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
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
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:
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
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
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
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
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
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"
> -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:
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
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
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
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'
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 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
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
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
> -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
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
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
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
: 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
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
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
.
>
> 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
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
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
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
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
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:
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
- 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
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
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
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
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
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
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
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
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
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
Chuck,
Report bugs to <[EMAIL PROTECTED]>.
-bash-2.05b$ psql -c 'select version();' template1
version
-
PostgreSQL 7.2.3 on i686-pc-linux-gnu,
...
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
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
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: 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.
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: 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
have another server that has a 7.0 branch installation... have not tried
transplanting the data files to that server as of yet.
thoughts, shared experiences, or other such insight would be appreciated.
Dave
---(end of broadcast)---
TIP 5: Have you
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: 10 July 2003 17:07
> To: Dave Page
> Cc: Donald Fraser; [ADMIN]; [pgADMIN]
> Subject: Re: [ADMIN] [pgadmin-support] Overloading functions
> that are used by operators.
>
>
>
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: 10 July 2003 16:38
> To: Dave Page
> Cc: Donald Fraser; [ADMIN]; [pgADMIN]
> Subject: Re: [ADMIN] [pgadmin-support] Overloading functions
> that are used by operators.
>
>
>
be the case for your citext datatype?
Regards, Dave.
-Original Message-From: Donald Fraser
[mailto:[EMAIL PROTECTED] Sent: 08 July 2003 21:27To:
Dave PageSubject: Re: [pgadmin-support] Overloading functions that
are used by operators.
Hi Dave,
if you want an easy way to
that there is a possible bug with postgresql.
Where was it discussed in depth? The last I heard was that
Andreas was going to look into it.
I will see if I can reproduce the problem
myself.
Regards, Dave.
some searches on this have produced mixed results...
do we have a stable means to replicate transactions between two physical
servers, preferrably in master - master configuration where updates/inserts can
be done on either database and the results replicated to the other master.
Dave
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
---
Michael Cupp wrote:
I know this is extremely remedial and trival for most of you - but I am a
very new user, and need to know what I have to do to get my database instance
created? Anyone that has a cheatsheet or something they can send me would
also be greatly appreciated.
I am a 10+ year
Dear admin,
How do you get your own primary keys, especially multiple primary keys, to
over ride the system key?
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
> -Original Message-
> From: Marc Mitchell [mailto:[EMAIL PROTECTED]]
> Sent: 05 June 2002 23:44
> To: Dave Page; Ramya Asokan; [EMAIL PROTECTED];
> [EMAIL PROTECTED]
> Subject: Re: [ADMIN] [pgadmin-support] Cache lookup error
>
>
> I've been experien
ger was dropped
correctly(and dropping it if not), and if that doesn't solve the
problem, dropping and recreating all the objects again, making sure that
all the dependencies are satisfied.
Regards, Dave.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
1 - 100 of 117 matches
Mail list logo
