Re: changing my mail address
Am DATE hackte AUTHOR in die Tasten: wambac...@posteo.de > Hi, > > how can i change my mail adress for the postgresql mailing lists? > adding > my new address worked, but how do i get rid of the old one? Useing the List-Unsubscribe header from The Mailinglist? > regards > > walter -- Michelle KonzackMiila ITSystems @ TDnet GNU/Linux Developer 00372-54541400
Scheme conversion MySQL to PGSQL
Hello * I try to convert a Database scheme from mySQL to pgSQL and have problems with the line: KEY post_date (post_date) and later probably with the lines UNIQUE KEY user (stat_login) and KEY forum_id (forum_id) too. How to solv this prolem? Thanks Michelle 8< CREATE TABLE sqmf_forum ( forum_id serial NOT NULL, forum_namevarchar(50) NOT NULL, forum_description varchar(250)NOT NULL, forum_visible integer NOT NULL default '0', display_order integer NOT NULL default '1', PRIMARY KEY (forum_id) ); CREATE TABLE sqmf_post ( post_id serial NOT NULL, thread_id integer NOT NULL, post_loginvarchar NOT NULL, post_date timestamp NOT NULL, post_content textNOT NULL, PRIMARY KEY (post_id), KEY post_date (post_date) ); CREATE TABLE sqmf_stat ( stat_loginvarchar(70) NOT NULL, stat_post integer default '1', stat_thread integer default '1', PRIMARY KEY (stat_login), UNIQUE KEY user (stat_login) ); CREATE TABLE sqmf_thread ( thread_id serial NOT NULL, forum_id integer NOT NULL, thread_login varchar(70) NOT NULL, thread_date datetimeNOT NULL, thread_title varchar(200)NOT NULL, thread_contentlongtextNOT NULL, nb_view integer NOT NULL default '0', nb_post integer NOT NULL default '1', last_post_datedatetimeNOT NULL, last_post_login varchar(70) NOT NULL, PRIMARY KEY (thread_id), KEY forum_id (forum_id) ); 8<-------- -- Michelle Konzack 00372-54541400
Re: Scheme conversion MySQL to PGSQL
Hello James, Am "=!/-!"-"$ hackte James Keener in die Tasten: > What are the errors you're getting? psql (9.1.24lts2) Type "help" for help. postgres=# DROP DATABASE sqmail_forum_tdnet; DROP DATABASE postgres=# \i /srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql CREATE DATABASE ALTER DATABASE GRANT You are now connected to database "sqmail_forum_tdnet" as user "postgres". psql:/srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql:14: NOTICE: CREATE TABLE will create implicit sequence "sqmf_forum_forum_id_seq" for serial column "sqmf_forum.forum_id" psql:/srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql:14: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sqmf_forum_pkey" for table "sqmf_forum" CREATE TABLE psql:/srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql:24: NOTICE: CREATE TABLE will create implicit sequence "sqmf_post_post_id_seq" for serial column "sqmf_post.post_id" psql:/srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql:24: ERROR: type "post_date" does not exist LINE 8: KEY post_date (post_date) ^ psql:/srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql:32: ERROR: syntax error at or near "user" LINE 6: UNIQUE user (stat_login) ^ psql:/srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql:47: NOTICE: CREATE TABLE will create implicit sequence "sqmf_thread_thread_id_seq" for serial column "sqmf_thread.thread_id" psql:/srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql:47: ERROR: type "forum_id" does not exist LINE 13: KEY forum_id (forum_id) ^ > I don't think unique key is the correct syntax. > https://www.postgresql.org/docs/current/static/indexes-unique.html I found it already. it is only "UNIQUE" > I also don't think the key can be named the same as the field. This is, what I have to figure out. > Jim -- Michelle Konzack 00372-54541400
Re: Scheme conversion MySQL to PGSQL
Hello Igal Am 2017-12-24 hackte Igal @ Lucee.org in die Tasten: > I agree with Andreas. First create the tables, then create the > indexes. If you can copy the data before creating the indexes then > you > will probably save some time on all of the INSERTs. > > I am doing a similar thing migrating from SQL Server, and I am > considering to publish an open source Migrator. > > Can you tell me about some of the data types that you had to change > moving from MySQL to Postgres? I convert only those four CREATE TABLE from mySQL to pgSQL which is the forum pluging for squirrelmail. auto_increment -> serial int(NN) -> int datetime-> timestamptz (attention: it is NOT timestamp) longtext-> text ENGINE=MyISAM hast to be removed. This are things, which I found on the internet. Greetings Michelle -- Michelle Konzack 00372-54541400
[OT] subscribtion with no-mail option?
Hello anyone, is there an option for the pgsql lists to subscribe only for posting and not receiving messages? I can read them in the archives, but the is one of the most active lists I am subscribed to. Not even can beat that. (there I can whitelist me, without receiving messages) Oh, I should say, that I live in Estonia far away from any lelephone land lines, hence no DSL availlable and I am on GSM/4G/LTE and if I would not have the NO-MAIL option, I would need to download more the 3000 messages a day where I am only interested in less the 5%. Note: I am currently programming a new PHP-Webinterface for my mail server which let me better choose, what I want to se and what not, hence deleting anything which is not relevant to me and has not some keywords in it. It is just worse, that I have to be subscribed to more then 80 mailing lists only to be able to post 200-300 messages per month and get maybe 2000 messages back, but have to download more then 100.000 messages a month with more then 1000 MByte. THis is just waste of resources and is very costly over the time. There is no benefit for the mailinglste except for my ISP and Telecom provider which bill me nicely... more then 100€ per month! Thanks in avance Michelle -- Michelle Konzack 00372-54541400
Re: [OT] subscribtion with no-mail option?
Hello Kumar, On 2017-12-26 01:11:23 Rakesh Kumar hacked into the keyboard: > Well I do recollect the option in the old mailing list to not email any > postings. IIRC, there were following options: > > 1- Email every messgages > 2- Daily digest of messages > 3- No email of any message. > > Option (3) can be used for only posting. I did that for some time. When I was subscribed some years ago, it was easy, but the option is now missing. The Internet became realy crap... Sourceforge, PostgreSQL... everywhere you must create accounts to access mailinglists! Then every month, Sourceforge unsubscribe me from the lists and I have to re.subscribe. Subscribtion per EMail not more possibel. It is really annoying! -- Michelle KonzackMiila ITSystems @ TDnet GNU/Linux Developer 00372-54541400 signature.asc Description: Digital signature
[table partitioning] How many partitions are possibel?
Hello *, Long time ago I used VIEWs on my history database and when PostgreSQL introduced table partitioning I was switching to it. Currently I use Debian GNU/Linux 7.11 with PostgreSQL 9.1 (table space and table partitioning) using an Adaptec 16-Channel Raid-1 Controller with 16x 6 TByte SAS UltraStar (HGST) drives. I created partitions of 100 years range and have currently 132 of them. There are 8 base columns (1 data colum in english) and then for each language used an additional colum. Some of the data where translated into 27 languages but I have 56 non-english columns. So in total I have currently 64 columns and arround 156mio rows. Th etables are organised into history_earth history_earth_021_a history_earth_020_a history_earth_019_a ... history_earth_124_b ... "a" mean A.C. and "b" B.C. While checking my Root-Servers I discovered, that my PostgreSQL Box has a huge performance problem, because some table partitions became VERY large (3 table partitions exceed already 1 TByte and 14 are 500-1000GB). I like to make the partitions smaller, but the documentation say, you should not dare to make several 1000 partitions.. Question: What is with is today possibel with table partitioning? And there is another thing: The 16 "new" SAS Drives where sponsored, hence free for me including the new Raid-1 Controller, but I do not like the idea, to have a singel physical database of arround 40 TByte diskspace... I can get much less expensive (not cheaper) SAS drives of 1 or 2 TByte and since the Raid-1 Controller cost only 400, I can use several LOW POWER machines (Mini-ITX) to accomplish the task because the webinterface is anyway stored on a seperated server. Any suggestions? -- Michelle Konzack 00372-54541400
Re: [table partitioning] How many partitions are possibel?
Hi, Am 2017-12-26 hackte Michael Paquier in die Tasten: > On Tue, Dec 26, 2017 at 11:04:55AM +0100, Michelle Konzack wrote: >> I like to make the partitions smaller, but the documentation say, you >> should not dare to make several 1000 partitions.. > > Even more than a hundred may be already risky in my opinion here. The > issue with a large number of partitioning using the pre-9.6 grammar > comes from the planning time which sky-rockets because the optimizer > uses a O(N^2) algorithm to consider all the partitions. The v10 grammar > does not take care of this planning problem as far as I recall, but v11 > gets that better for partition-wise joins if my memory does not fail me. > -- > Michael I think on migrating to v10, but I have to backport the PostgreSQL. Currently I am thinking about hot to backup 28 TByte of data... Have to dump and compress table by table and thios take endless time, especially, if I am in Estonia and the database is in Germany. Is there already a rease date for v11? Thanks in avance -- Michelle Konzack 00372-54541400
Re: [table partitioning] How many partitions are possibel?
Thanks for the info. I think, it is not worth to do the migration to v10 now and then some month later to v11. I hope, my v9.1 will survive the version jump. What do you think? My database has no complex things in it. I keept it realy on basic level to avoid problems if I have to upgrade. Thanks in avance Am 2017-12-27 hackte Michael Paquier in die Tasten: > On Wed, Dec 27, 2017 at 08:53:11AM +0100, Michelle Konzack wrote: >> Is there already a release date for v11? > > Based on the pace of the most recent major releases, this could happen > around September. This depends on any issues encountered > post-development though. > -- > Michael -- Michelle Konzack 00372-54541400
Re: Mailing list archiver
Hello Jordan, what software is the server running? Is it Open Source? I am interested in it because I run a small site for my BioFarm in Estonia and use the Courier Mailing List Manager. Thanks in avance Michelle Am 2018-01-03 hackte Jordan Deitch in die Tasten: > This project serves to organize and archive the postgres mailing list: > > http://pg.rsa.pub/ > > Let me know what you think, or if you have any suggestions. > I left email addresses off the site to protect privacy. > > p.s: you can click messages to collapse the tree > > Thanks -------- -- Michelle Konzack 00372-54541400
Re: Mailing list archiver
This is bizzar, because the URL <http://pg.rsa.pub/> is perfectly working for me. Am DATE hackte AUTHOR in die Tasten: Peter J. Holzer > On 2018-01-03 11:28:06 +0100, Magnus Hagander wrote: >> I can't tell you how it differs from the one Jordan is posting, because >> if I go >> to that site I just get empty templates and it's failing to load the >> javascript >> properly from here. > > I'm surprised that you even get an empty template. > > pg.rsa.pub has a CNAME of > http://pg.rsa.pub.s3-website-us-east-1.amazonaws.com. which is a syntax > error (the value of a CNAME record must be a domain name, not an URL). > Here at least the Linux resolver library gives up and reports that the > host name doesn't exist. > > A less picky resolver might accept > http://pg.rsa.pub.s3-website-us-east-1.amazonaws.com as a valid host > name (although ":" and "/" aren't allowed in host names) and find that > there is actually another CNAME record which points to > s3-website-us-east-1.amazonaws.com which has an A record. So that might > work on some platforms. > > hp > -- Michelle Konzack 00372-54541400
Re: Mailing list archiver
Hi Jordan, I was on the GIT server, but is there a possibility, to get the whole thing as tar ball? I am currently under this horribel Windows 7 because the screen of my Compaq Laptop broke (simply black) and I am unable to get things from the GIT server except file by file. This, why I have to use the old squirrelmail instead of mutt... Ahja, I do not use Majordomo, which mean, I have to change things in the files but I like to know, how you get the incoming messages into the database? I generally filter the messages trough procmail and feed it to the appropriated program to process them. Thanks Michelle Am DATE hackte AUTHOR in die Tasten: Jordan Deitch > Thanks for the feedback! I will continue to address these issues, and I > intend on adding #postgresql IRC logs as well :-) > This software was written by me particularly for this purpose; I will > clean > up / comment, then publish the source to my github - I'll shoot a reply > here with that sometime in the next day or two > > > On Wed, Jan 3, 2018 at 8:50 AM, Alvaro Herrera > wrote: > >> Michelle Konzack wrote: >> > This is bizzar, because the URL <http://pg.rsa.pub/> >> > is perfectly working for me. >> >> It fails for me exactly as Peter described. >> >> I added this entry to /etc/hosts: >> >> 54.231.120.105 pg.rsa.pub >> >> and then I could see the site. It looks like an interesting interface. >> There are bugs related to loading pages, and the collapsing feature is a >> bit odd, but it seems promising. >> >> -- >> Ãlvaro Herrera https://www.2ndQuadrant.com/ >> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services >> >> > -- Michelle Konzack 00372-54541400
Re: Production Database requirement
Salam Mohammed, Am DATE hackte Azimuddin Mohammed in die Tasten: > Hello All, > Can anyone please let me know > > 1. What is the hardware and software requirement for postgressql to be > installed in production. We are planning to use postgres for hadoop > backend, to store user access info, metadata etc. So, it will not be high > transaction db, but we might see lost of reads to this db. It sound a only a little bit more what I have a s /etc/passwd, /etc/shadow, /etc/groups and /etc/gshadow replacement... I have exactly this too and it rund quiert well on a MiniITX with 1000MHz and 1 GByte of memory which is 60% unused. The Debian GNU/Linux 7.11 installation together with the postgresql database using less then 5 GByte... Lets say, the whole thing would run an a 20 GByte HDD. I manage currently 23.000 users with it... And no, I do not use LDAP. My webservices authenticate directly with the database server which is hostet at a friendly ISP in Estonia. > 2. Can we use Vm's to run the Db? Is it recommended ? Yes of course. > Thanks in Advance! -------- -- Michelle Konzack 00372-54541400
