Thread: portable version for Usb Pen
Goodmornig... I'm new in this forum and new with PG. Existis a portable version of PG. Tks Sorry for my bed english. -- View this message in context: http://postgresql.1045698.n5.nabble.com/portable-version-for-Usb-Pen-tp5801221.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On 4/23/2014 1:59 AM, SAL21 wrote: > I'm new in this forum and new with PG. > Existis a portable version of PG. I'm assuming you mean http://en.wikipedia.org/wiki/Portable_application by 'portable'... a "portable" version of a database server doesn't make any sense. a USB stick is not at ALL suitable as database storage, they perform really poorly on random writes, and if you're going to store the data on the systems hard disk, you might as well store the software there too as you can't access the data without the server software. -- john r pierce 37N 122W somewhere on the middle of the left coast
On 04/23/2014 01:59 AM, SAL21 wrote: > Goodmornig... > I'm new in this forum and new with PG. > Existis a portable version of PG. > Tks Take a look at: http://www.turnkeylinux.org/postgresql > > Sorry for my bed english. > > > > > -- > View this message in context: http://postgresql.1045698.n5.nabble.com/portable-version-for-Usb-Pen-tp5801221.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > -- Adrian Klaver adrian.klaver@aklaver.com
I dont see any link to download a portable version.
From: Adrian Klaver-4 [via PostgreSQL] [mailto:[hidden email]]
Sent: mercoledì 23 aprile 2014 20:38
To: SAL21
Subject: Re: portable version for Usb Pen
On 04/23/2014 01:59 AM, SAL21 wrote:
> Goodmornig...
> I'm new in this forum and new with PG.
> Existis a portable version of PG.
> Tks
Take a look at:
http://www.turnkeylinux.org/postgresql
>
> Sorry for my bed english.
>
>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/portable-version-for-Usb-Pen-tp5801221.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
--
Adrian Klaver
[hidden email]
--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
If you reply to this email, your message will be added to the discussion below:
http://postgresql.1045698.n5.nabble.com/portable-version-for-Usb-Pen-tp5801221p5801295.html
To unsubscribe from portable version for Usb Pen, click here.
NAML
View this message in context: RE: portable version for Usb Pen
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Really my question is:
A cannot install any type of exe application on my pc farm. Not have admin permission.
But my idea is to make a portable SERVER (sql, oracle, Mysql…) on my pc an share it from the rest of pc of my farm.
From: John R Pierce [via PostgreSQL] [mailto:[hidden email]]
Sent: mercoledì 23 aprile 2014 20:18
To: SAL21
Subject: Re: portable version for Usb Pen
On 4/23/2014 1:59 AM, SAL21 wrote:
> I'm new in this forum and new with PG.
> Existis a portable version of PG.
I'm assuming you mean http://en.wikipedia.org/wiki/Portable_application
by 'portable'...
a "portable" version of a database server doesn't make any sense. a USB
stick is not at ALL suitable as database storage, they perform really
poorly on random writes, and if you're going to store the data on the
systems hard disk, you might as well store the software there too as you
can't access the data without the server software.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
If you reply to this email, your message will be added to the discussion below:
http://postgresql.1045698.n5.nabble.com/portable-version-for-Usb-Pen-tp5801221p5801291.html
To unsubscribe from portable version for Usb Pen, click here.
NAML
View this message in context: RE: portable version for Usb Pen
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
A cannot install any type of exe application on my pc farm. Not have admin permission.
But my idea is to make a portable SERVER (sql, oracle, Mysql…) on my pc an share it from the rest of pc of my farm.
if you don't have permissions to install software from your management, then you shouldn't be doing this at all.
if you have a business need for this, then get the network administrators to deploy a proper database server on the network, don't juryrig something up on your PC
-- john r pierce 37N 122W somewhere on the middle of the left coast
Oscar Calderon
Analista de Sistemas
Soluciones Aplicativas S.A. de C.V.
www.solucionesaplicativas.com
Cel. (503) 7741 7850 Tel. (503) 2522-2834
if you don't have permissions to install software from your management, then you shouldn't be doing this at all.On 4/23/2014 12:04 PM, SAL21 wrote:A cannot install any type of exe application on my pc farm. Not have admin permission.
But my idea is to make a portable SERVER (sql, oracle, Mysql…) on my pc an share it from the rest of pc of my farm.
if you have a business need for this, then get the network administrators to deploy a proper database server on the network, don't juryrig something up on your PC-- john r pierce 37N 122W somewhere on the middle of the left coast
On 4/24/2014 5:33 AM, Oscar Calderon wrote: > First of all, you have to format your USB as NTFS instead FAT or FAT32 > because NTFS has some features needed by PostgreSQL according to this > link: and now you have a HUGE problem. the postgres server has to run as a dedicated user, and that user will have a different UUID on each system you plug this portable stick into. oh, and as a non-administrator, you can't create said user. anyways, the whole idea is bad. postgres does a LOT of 8k block random writes. USB flash memory absolutely HATES random writes, and will burn itself out in short order, meanwhile running at molasses slow speeds. -- john r pierce 37N 122W somewhere on the middle of the left coast