[ADMIN] Creating tables...not a usual question (I think)
Hi all, I have a question! Suppose that you have a 'virtualstore' database that are owned by Peter, the enterprise DBA. So why the tables that we create inside 'virtualstore' don't have peter as owner automatically??? I mean, why don't the tables inherits the owner of the database??? Thanks!
[ADMIN] encoding issue with postgres 8.0
hi i am migrating from postgres 7.3.9 to 8.0.3 I am facing a issue with encoding. By default when i create new database it creates as UNICODE In the earlier version the encoding was SQL_ASCII so i am passing this variable while initializing the db directory /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data -E SQL_ASCII but i get this warning when I run it. The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale en_GB.UTF-8. initdb: warning: encoding mismatch The encoding you selected (SQL_ASCII) and the encoding that the selected locale uses (UTF-8) are not known to match. This may lead to misbehavior in various character string processing functions. To fix this situation, rerun initdb and either do not specify an encoding explicitly, or choose a matching combination. what is the matching locale that i should be using in this case? thanks, kailash
Re: [ADMIN] Creating tables...not a usual question (I think)
Rodrigo Sakai wrote: > Hi all, I have a question! > Suppose that you have a 'virtualstore' database that are owned by > Peter, the enterprise DBA. So why the tables that we create inside > 'virtualstore' don't have peter as owner automatically??? I mean, why > don't the tables inherits the owner of the database??? > Why it should? If an user have permission to create table why the tables created shall be owned by another user ? It's like you create a file in your filesystem and the owner is someone else. Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [ADMIN] encoding issue with postgres 8.0
Kailash Vyas <[EMAIL PROTECTED]> writes: > The database cluster will be initialized with locale en_GB.UTF-8. > initdb: warning: encoding mismatch > The encoding you selected (SQL_ASCII) and the encoding that the selected > locale uses (UTF-8) are not known to match. This may lead to > misbehavior in various character string processing functions. To fix > this situation, rerun initdb and either do not specify an encoding > explicitly, or choose a matching combination. > what is the matching locale that i should be using in this case? If you want to use SQL_ASCII (ie, have no enforcement of encoding validity) the only really safe locale is "C". If you were using another combination with your old database and not having trouble, you may decide to ignore the warning and keep using that combination --- it'll work just as well or badly as before. But with what you have here, if you ever accidentally put any non-UTF8 data into the database, you'll likely get odd behavior. regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN] sleep?
Sorry for the delay in replying. The use-case that I have is the following. I'm writing a job-control tracking sub-system that will store when jobs are started, finished, failed, etc. I would like to have the ability to have a process that is requesting to start, to actually wait a specified period time before starting. It could wait for another job to finish. I'm writing this in plpgsql since I'm storing status in the db. -DonOn 8/22/05, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Mon, Aug 22, 2005 at 08:34:29AM -0500, Don Drake wrote:> I agree that a basic function (non-CPU intensive sleep) like this should be> built in.It's being discussed in pgsql-hackers: http://archives.postgresql.org/pgsql-hackers/2005-08/msg00633.phpDo you have any use cases in addition to what's already beenmentioned? Sleeping isn't really a database operation, so thereneeds to be some justification for making it a standard function. --Michael Fuhr-- Donald DrakePresidentDrake Consultinghttp://www.drakeconsult.com/ http://www.MailLaunder.com/http://www.mobilemeridian.com/312-560-1574
Re: [ADMIN] sleep?
Don Drake wrote: Sorry for the delay in replying. The use-case that I have is the following. I'm writing a job-control tracking sub-system that will store when jobs are started, finished, failed, etc. I would like to have the ability to have a process that is requesting to start, to actually wait a specified period time before starting. It could wait for another job to finish. I'm writing this in plpgsql since I'm storing status in the db. I would write a userspace daemon that ran outside of PostgreSQL to call your procedures as you need them to run. Sincerely, Joshua D. Drake ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[ADMIN] EnterpriseDB ?
I just saw the interview made in LinuxWorld with Enterprisedb, my question is: are they really supporting PostgreSQL like they claim? ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN] EnterpriseDB ?
Izoel Aguiar C wrote: I just saw the interview made in LinuxWorld with Enterprisedb, my question is: are they really supporting PostgreSQL like they claim? Yes. They hired David Cramer, Jonah Harris and Alverro. They also sponsored the community in their booth for LinuxWorld. They are also supposedly giving code back for 8.2. Sincerely, Joshua D. Drake ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---(end of broadcast)--- TIP 1: 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
Re: [ADMIN] EnterpriseDB ?
From what I've seen in their beta version, yes their just being a Red Hat like var and adding some gui based add-ons. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Izoel Aguiar C Sent: Tuesday, August 23, 2005 12:43 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] EnterpriseDB ? I just saw the interview made in LinuxWorld with Enterprisedb, my question is: are they really supporting PostgreSQL like they claim? ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---(end of broadcast)--- TIP 6: explain analyze is your friend
[ADMIN] Fwd: Indexes (Disk space)
-- Forwarded message -- From: jose fuenmayor <[EMAIL PROTECTED]> Date: Aug 22, 2005 1:37 PM Subject: Indexes (Disk space) To: pgsql-admin@postgresql.org Hi all, I have the following question. Is there anyway for me to know how much space on disk will ocupy an index, created in a determined row or rows of a table?, anything like a rule, formula, calculation? that allow me to know in advance how much space will the index use before actually created it. I aprecciate all the help you can give me Thanks in advance. ---(end of broadcast)--- TIP 1: 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
Re: [ADMIN] EnterpriseDB ?
Goulet, Dick wrote: From what I've seen in their beta version, yes their just being a Red Hat like var and adding some gui based add-ons. Well that isn't true at all. They have added a huge Oracle compatibility layer. Sincerely, Joshua D. Drake -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Izoel Aguiar C Sent: Tuesday, August 23, 2005 12:43 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] EnterpriseDB ? I just saw the interview made in LinuxWorld with Enterprisedb, my question is: are they really supporting PostgreSQL like they claim? ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---(end of broadcast)--- TIP 6: explain analyze is your friend ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [ADMIN] sleep?
On a related note, you might be interested in http://pgfoundry.org/projects/pgjob/ On Tue, Aug 23, 2005 at 09:42:27AM -0500, Don Drake wrote: > Sorry for the delay in replying. > > The use-case that I have is the following. I'm writing a job-control > tracking sub-system that will store when jobs are started, finished, failed, > etc. I would like to have the ability to have a process that is requesting > to start, to actually wait a specified period time before starting. It could > wait for another job to finish. I'm writing this in plpgsql since I'm > storing status in the db. > > -Don > > On 8/22/05, Michael Fuhr <[EMAIL PROTECTED]> wrote: > > > > On Mon, Aug 22, 2005 at 08:34:29AM -0500, Don Drake wrote: > > > I agree that a basic function (non-CPU intensive sleep) like this should > > be > > > built in. > > > > It's being discussed in pgsql-hackers: > > > > http://archives.postgresql.org/pgsql-hackers/2005-08/msg00633.php > > > > Do you have any use cases in addition to what's already been > > mentioned? Sleeping isn't really a database operation, so there > > needs to be some justification for making it a standard function. > > > > -- > > Michael Fuhr > > > > > > -- > Donald Drake > President > Drake Consulting > http://www.drakeconsult.com/ > http://www.MailLaunder.com/ > http://www.mobilemeridian.com/ > 312-560-1574 -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Softwarehttp://pervasive.com512-569-9461 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [ADMIN] Fwd: Indexes (Disk space)
select * from pg_class; or select relname, relpages from pg_class where relname = '[index-name]'; the pages give you the information about the space the index uses, a page has 8kb. [...]Every table and index is stored as an array of pages of a fixed size (usually 8Kb, although a different page size can be selected when compiling the server). In a table, all the pages are logically equivalent, so a particular item (row) can be stored in any page. In indexes, the first page is generally reserved as a metapage holding control information, and there may be different types of pages within the index, depending on the index access method. [...] Source-URL: http://www.postgresql.org/docs/8.0/interactive/storage-page-layout.html jose fuenmayor wrote: -- Forwarded message -- From: jose fuenmayor <[EMAIL PROTECTED]> Date: Aug 22, 2005 1:37 PM Subject: Indexes (Disk space) To: pgsql-admin@postgresql.org Hi all, I have the following question. Is there anyway for me to know how much space on disk will ocupy an index, created in a determined row or rows of a table?, anything like a rule, formula, calculation? that allow me to know in advance how much space will the index use before actually created it. I aprecciate all the help you can give me Thanks in advance. ---(end of broadcast)--- TIP 1: 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 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
