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 (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

I dont see any link to download a portable version.

From: Adrian Klaver-4 [via PostgreSQL]
[mailto:ml-node+s1045698n5801295h81@n5.nabble.com]
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-tp58012
21.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-tp58012
21p5801295.html

To unsubscribe from portable version for Usb Pen, click here
<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=unsu
bscribe_by_code&node=5801221&code=Z3NzLml0YWx5QGlvbC5pdHw1ODAxMjIxfC03NTQ4OD
k1MzE=> .

<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=macr
o_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.B
asicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.templ
ate.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-insta
nt_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
NAML

--
View this message in context: http://postgresql.1045698.n5.nabble.com/portable-version-for-Usb-Pen-tp5801221p5801300.html
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:ml-node+s1045698n5801291h57@n5.nabble.com]
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-tp58012
21p5801291.html

To unsubscribe from portable version for Usb Pen, click here
<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=unsu
bscribe_by_code&node=5801221&code=Z3NzLml0YWx5QGlvbC5pdHw1ODAxMjIxfC03NTQ4OD
k1MzE=> .

<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=macr
o_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.B
asicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.templ
ate.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-insta
nt_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
NAML

--
View this message in context: http://postgresql.1045698.n5.nabble.com/portable-version-for-Usb-Pen-tp5801221p5801301.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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 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

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:

https://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows

In the section "Can I install PostgreSQL on a FAT partition?"

Regards.

***************************
Oscar Calderon
Analista de Sistemas
Soluciones Aplicativas S.A. de C.V.
www.solucionesaplicativas.com
Cel. (503) 7741 7850 Tel. (503) 2522-2834

2014-04-23 22:10 GMT-06:00 John R Pierce <pierce@hogranch.com>:

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general