Re: [ADMIN] Need PGSQL ODBC Driver for Solaris
> 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 on unix. it is threadsafe on windows. -- Jeff Trout <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[ADMIN] Visibility of objects in other schema's
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. As the administrator I created two schema's for two users: create schema vosf authorization vosf; create schema snefru authorization snefru; If I logon to the database with psql as user vosf and create a table, it is created under schema vosf. That's good. If I logon to the same database with psql as user snefru and issue: \d vosf.* I can see all tables within the vosf schema. Paragraph 2.8.4 says I should not. I cannot do selects from these tables, but I think seeing what tables a user has created and which columns these have is wrong. I want to use a single database on a single server, but this visibility issue keeps me using multiple databases. Is it considered a problem? If so, is it a known problem? Not subscribed anymore to any PostgreSQL list, I searched the archives, but did not find a similar question. Thanks for any help. PostgreSQL is a great database. Fred ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[ADMIN] Starting postgresql service FAILED
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!? The New Yahoo! Shopping - with improved product search
Re: [ADMIN] Multi-Language server
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 multibyte ones. Does anyone have reccomendations on the database server configuration, pitfalls etc. Thanks. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] File system level backup
> 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. > Furthermore, do we really need to do File system level backup or pg_dump > is good enough? File system level backup is typically complicated to design, and is specific to your needs. pg_dump is nearly universally usable, but might not meet your needs, if you are a 24x7 shop. Online backup is almost always specific to your site, usually a big deal to set up, and rarely impossible. > Any suggestion is much appreciated. Without more information about what you're doing, I can't say anything more. But most likely, pg_dump will work for you. It covers most cases. -j -- Jamie Lawrence[EMAIL PROTECTED] Helpful Hint: Unbreakable toys can be used to break other toys. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[ADMIN] disaster recovery...
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 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 checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[ADMIN] Is there a NEW FEATURES section in docs?
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 Solutions Web: http://www.arsenaldigital.com <<...OLE_Obj...>> The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you.
Re: [ADMIN] disaster recovery...
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) > > 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 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 checked our extensive FAQ? > >http://www.postgresql.org/docs/faqs/FAQ.html > > ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] 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? Check the release notes: http://www.postgresql.org/docs/7.3/interactive/release.html HTH, -b ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[ADMIN]unsubscribe from pgsql-admin
__ 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-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
