473,881 Members | 1,644 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How many secondary databases can I create?

Hello all,

I have accidently :-) found 'initlocation' and now I like to
know, how many secondary database i can create.

I like to do that, because I have a Virtual Webserver and for
each VirtualHost I have a local $USER. Now I like to create
seperatly secondary databases for each $USER/VHost.

Thanks
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBlNQ1C0F PBMSS+BIRAiPyAJ 4to+OYAS26IRPJd aPm04ba4eBAjQCe N7Ef
wWRRBUCRgxuftxT YhX1d2TE=
=1UtQ
-----END PGP SIGNATURE-----

Nov 23 '05 #1
6 2995
As many as you have disk space for I guess. You might need one
postmaster per location but I'm not sure about that, check the docs...

On Fri, Nov 12, 2004 at 04:18:13PM +0100, Michelle Konzack wrote:
Hello all,

I have accidently :-) found 'initlocation' and now I like to
know, how many secondary database i can create.

I like to do that, because I have a Virtual Webserver and for
each VirtualHost I have a local $USER. Now I like to create
seperatly secondary databases for each $USER/VHost.

Thanks
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)
--
Martijn van Oosterhout <kl*****@svana. org> http://svana.org/kleptog/ Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFBlN5QY5T wig3Ge+YRAqqYAJ 46SskSDg6IH48nz EvhTzjxJVW/wQCg3tD+
q7dd7xIqrmam0wu Uu9g8soo=
=Bw9H
-----END PGP SIGNATURE-----

Nov 23 '05 #2
Hello Martijn,

Am 2004-11-12 17:01:20, schrieb Martijn van Oosterhout:
As many as you have disk space for I guess. You might need one
postmaster per location but I'm not sure about that, check the docs...


I have read, that the "secondary databases" are attached to the main
database which mean, it builds a cluster. I have nothing read about
other postmasters...

Please note, that I do not run seperatly databases.
I like only to split it per $USER physicaly from the main database.

I like to have this setup for my new Virtual-Webserver where I have
for each VHost a local $USER.

Greetings
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBlOLrC0F PBMSS+BIRAuQIAK CjsqusVRNBPM7Gh +K8WLthLfkEDgCd HG6R
tpcc8odsDM0Ar2p LIkCb/hw=
=wp5Y
-----END PGP SIGNATURE-----

Nov 23 '05 #3
On Fri, 12 Nov 2004 17:20:59 +0100, Michelle Konzack
<li************ @freenet.de> wrote:
Please note, that I do not run seperatly databases.
I like only to split it per $USER physicaly from the main database.

I like to have this setup for my new Virtual-Webserver where I have
for each VHost a local $USER.


Some time ago I talked with a friend working at some ISP, and we were
talking about PostgreSQL's superiority to hmm, other RDBMSs... ;)
Blah, blah, blah. The question is - how to give many many users
access to PostgreSQL... I see three approaches, and all of these
have pros and cons.

1) One pgsql per user -- in other words each user runs its own copy of
pgsql -- waste of memory (each user having its own shared mem, etc),
but can enforce quota limits, etc. Hard to keep all those copies of
pgsql running.

2) one pgsql database per user. Probably most common. :) Each user
has full pgsql database at her disposal. It's a bit hard to manage quotas,
dbsize comes in handy but it involeves creating some sort of "quota
enforcing" daemon...

3) one pgsql database with one schema per user. Interesting, can very
easily create many "databases" , does not give full pgsql power, harder
to manage quotas than previous model...

Hmm, I wonder what are the feelings of people using such models.
I did not use them, so I have no idea. And I wonder how problematic
is "quota enforcement" there....

Regards.
Dawid

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #4
Dawid Kuroczko wrote:
On Fri, 12 Nov 2004 17:20:59 +0100, Michelle Konzack
<li*********** *@freenet.de> wrote:

Please note, that I do not run seperatly databases.
I like only to split it per $USER physicaly from the main database.

I like to have this setup for my new Virtual-Webserver where I have
for each VHost a local $USER.


Some time ago I talked with a friend working at some ISP, and we were
talking about PostgreSQL's superiority to hmm, other RDBMSs... ;)
Blah, blah, blah. The question is - how to give many many users
access to PostgreSQL... I see three approaches, and all of these
have pros and cons.

1) One pgsql per user -- in other words each user runs its own copy of
pgsql -- waste of memory (each user having its own shared mem, etc),
but can enforce quota limits, etc. Hard to keep all those copies of
pgsql running.

Hello,

We use this version as it allows us to provide the best security
and flexibility to the customer

Sincerely,

Joshua D. Drake


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandpromp t.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 23 '05 #5
Hello Dawid,

Am 2004-11-13 21:42:14, schrieb Dawid Kuroczko:
Some time ago I talked with a friend working at some ISP, and we were
talking about PostgreSQL's superiority to hmm, other RDBMSs... ;)
Blah, blah, blah. The question is - how to give many many users
access to PostgreSQL... I see three approaches, and all of these
have pros and cons.

1) One pgsql per user -- in other words each user runs its own copy of
pgsql -- waste of memory (each user having its own shared mem, etc),
but can enforce quota limits, etc. Hard to keep all those copies of
pgsql running.
This is what I have tried for 2 (???) years... and failed. It need to
much memory. I have on one of my older Servers only ~140 VHosts/$USERS
and I have tried to start for each $USER a postmaster... I was running
out of memory with 4 GByte of RAM on a Dual Athlon.
2) one pgsql database per user. Probably most common. :) Each user
has full pgsql database at her disposal. It's a bit hard to manage quotas,
dbsize comes in handy but it involeves creating some sort of "quota
enforcing" daemon...
This is what I like to do, but if I use

initlocation /home/$USER/.postgresql/

to create a secondary database and use my it with tha master db as
cluster, I do not know, how I put the $USER database into this
location...

It seems not to be possibel.

I think, it works only, If I have ond HDD and it is not enough
diskspace so I attach a second HDD and a secondary db on the new HDD.
3) one pgsql database with one schema per user. Interesting, can very
easily create many "databases" , does not give full pgsql power, harder
to manage quotas than previous model...
To much administration.
Hmm, I wonder what are the feelings of people using such models.
I did not use them, so I have no idea. And I wonder how problematic
is "quota enforcement" there....
:-(

I have the wish, that $USER can create a secondary/cluster database
in there own $HOME. A feature which I am missing...
Regards.
Dawid

Greetings
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBl6FnC0F PBMSS+BIRAslKAJ 9KkiEyHfPnyIA6c wtqBbjf1NqNdwCf TIv0
Ae71xFT14aIyUgk S+3yZNIo=
=u8YC
-----END PGP SIGNATURE-----

Nov 23 '05 #6
Hello Joshua,

Am 2004-11-13 21:40:10, schrieb Joshua D. Drake:
Dawid Kuroczko wrote:
1) One pgsql per user -- in other words each user runs its own copy of
pgsql -- waste of memory (each user having its own shared mem, etc),
but can enforce quota limits, etc. Hard to keep all those copies of
pgsql running.

Hello,

We use this version as it allows us to provide the best security
and flexibility to the customer


This is right, but how many $USER do you have and what Computer ?

And I think, the database is only accessible local without TCP ?

If you have 100 $USER und 100 postmasers running and $USER wish
to connect via TCP how do you manage the Ports ?

I am searching a solution to split up a ~800 GByte big database...
and currently it increase around 100 MByte/day. (running with 9 x
SCSI-HDD 147 GByte in Raid-5 on a Quad-Athlon with only 4 GByte of
memory and not 8 GByte as I like)
Sincerely,

Joshua D. Drake


Greetings
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBl6NoC0F PBMSS+BIRAvHKAJ 94cgsYbCdPvNM23 51D05eI0AzwRwCa A8LB
70Nkan6G/yiIiNWEmjVfE6I=
=LrNe
-----END PGP SIGNATURE-----

Nov 23 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1768
by: robberjohn | last post by:
Hello all, I have a SQL 2000 Standard SP3 install. I was running low on free space so added a secondary data file on a separate hard drive. I did this for each of two databases. Since then, and I guess it could be only a coincidence, my weekly reindex maintenance plan has been failing, but only for one of the two databases I added the secondary file to. The 1st weeks emailed report shows that it rebuilds indices for 12 tables and then...
7
2841
by: hank | last post by:
Hi All In the Circular Logging when the Primary Log file fill up, the database manager will creat a secondary log files for the transaction; when this transaction finished, the secondary log files still allocated in log directory; when all application disconnect from database or database reactive or database restart the secondary log files will be deleted from log directory. For each transaction log request, database manager always...
2
11795
by: BG | last post by:
We're having trouble writing the code to update a UI control (label.Text) from a secondary thread. We're using C# with Windows Forms. We have a main form named MainForm, a splash screen form named SplashScreen, and a C# class library named BackgroundProcess.
3
3776
by: Dale Lundgren | last post by:
I have a c# class library that launches a Win Form in a secondary thread. From the Form (now running in the secondary thread) I need to be able to start a method that is defined in the class and have it run in the main thread. I have read many examples and tried numerous approaches based on delegates all of which will launch the method, but never in the main thread, always in the secondary thread. Is what I'm trying to accomplish...
0
1717
by: karen s via AccessMonster.com | last post by:
I searched the knowledge base for a way to do this but am having no luck with it. The directions state to select the data series that you want to plot along a secondary value axis, then on the format menu click Selected Data Series, and then click the Axis tab. I don't have an Axis tab when I do this. I have patterns, shapes, data labels and Options, none of which contain any mention of secondary axis. I am trying to plot on the y axis...
0
1535
by: Parveen.Beniwal.Daffodil | last post by:
Is it possible to do SQL log shipping to more than one Databases on same Secondry Server WITH A DIFFERENT SCHEDULE for each log shipping? You can set up log shipping to go to as many servers as you want, but you only get one schedule in the plan. If you set up a second log shipping schedule, you get an error because the server is already set up for log shipping in the other plan. Just wondering if this is possible.
2
3063
by: Ultrak The DBA | last post by:
We have logarchmeth1 set. Also, we have a monitoring script that checks the gap between any log files in the active log directory. We have just recently activated logarchmeth1 and what we have found is that we have a large occurrance of gaps. IBM has told us this is because the secondary logs are hanging out and will not leave the active log directory until the database is inactive. Our application is 24/7 so the databases do not...
3
2238
by: garyvale | last post by:
Hi, I am experiencing a recurrent bug with my secondary user profiles. I am using WIN XP Pro with SP2 and all current critical upgrades/patches. I am able to create secondary and tertiary accounts (et al) with my primary administrator access. The users can successfully enter their profiles/workspace via the log-on process, however, when applications like MS WORD and EXPLORER are launched via desktop shortcuts, a windows installer screen pops...
8
1994
by: Daniele Piccinini | last post by:
Hi all, In my vc++ 2005 dialog based application i need to use a comunication activex component in a secondary thread: CFINSAxEFS* pNewAx = new CFINSAxEFS(); if ( !pNewAx->Create( NULL, NULL, CRect( 0,0,0,0), pParent, pNode->m_nFinsID) )
0
9928
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9776
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11100
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10718
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10402
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7953
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
1
4597
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4196
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3225
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.