Re: [ADMIN] Need PGSQL ODBC Driver for Solaris

2003-10-23 Thread Jeff
> On Wed, 22 Oct 2003, David Wagoner wrote: > > > Jeff, > > > > Thanks, I saw that page but thought is was only for Windows since it > > said Win32. But, I'll try it on Solaris and see what happens. > > You'll need to download source and compile it yoruself. *WARNING* it is *NOT* threadsafe

[ADMIN] Visibility of objects in other schema's

2003-10-23 Thread Fred Vos
Hello, Since version 7.3 of PostgreSQL it's possible to create schema's. The User's Guide (paragraph 2.8.4) says that it is not possible to view objects from a schema you do not own: "By default, users cannot see the objects in schemas they do not own." I'm using PostgreSQL 7.3.4 under Linux.

[ADMIN] Starting postgresql service FAILED

2003-10-23 Thread Ed Muldowney
Had to hard reboot server due to server lockup.  After postgresql failed to start. Trying to manually restart postgresql but keep getting FAILED messages.  Nothing in any of the logs to indicate what the error is.  Any ideas on what next steps I  should take?    Thanks Ed Muldowney Do you Yahoo!?

Re: [ADMIN] Multi-Language server

2003-10-23 Thread CoL
Using unicode? C. Stephen J. Thompson wrote, On 10/22/2003 8:55 PM: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello all, I am looking for suggestions to the following problem. I need to run a database server that needs to allow the entry and searching in multiple languages including multib

Re: [ADMIN] File system level backup

2003-10-23 Thread Jamie Lawrence
> Dear all, > > All the while I was doing pg_dump as backup method for my pgsql db. > Today I came across File system level backup on Postgresql > Documentation. > > After reading it, I am quite unsure whether File system level backup is > better than pg_dump. You have to look at your needs.

[ADMIN] disaster recovery...

2003-10-23 Thread Dave [Hawk-Systems]
have a server that went belly up on us. We do have copies of the data directories on backups, but no recent dumps. Old server was ver 7.0 branch (7.0.3 if memory serves) New server is set up with pg ver 7.3 branch (7.3.4) Is there any way to recover the data using the 7.0 data files? We do have

[ADMIN] Is there a NEW FEATURES section in docs?

2003-10-23 Thread David Wagoner
Title: Is there a NEW FEATURES section in docs? Hi, I'm looking in the PostgreSQL online docs and do not see a section for New Features.  Is there such documentation that tells the new features by version number? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solut

Re: [ADMIN] disaster recovery...

2003-10-23 Thread scott.marlowe
You'll have to transfer the data over to a 7.0.x machine to recover it. On Thu, 23 Oct 2003, Dave [Hawk-Systems] wrote: > have a server that went belly up on us. > > We do have copies of the data directories on backups, but no recent dumps. > Old server was ver 7.0 branch (7.0.3 if memory serves

Re: [ADMIN] Is there a NEW FEATURES section in docs?

2003-10-23 Thread Bryan Encina
>Hi, >I'm looking in the PostgreSQL online docs and do not see a section for New Features. Is >there such documentation that tells the new features by version number? Check the release notes: http://www.postgresql.org/docs/7.3/interactive/release.html HTH, -b ---(end o

[ADMIN]unsubscribe from pgsql-admin

2003-10-23 Thread shilpi jain
__ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-noma