Re: [GENERAL] efficient math vector operations on arrays

2015-12-24 8:34 GMT+01:00 Marcus Engene : > On 24/12/15 07:13, Pavel Stehule wrote: > > Hi > > 2015-12-24 8:05 GMT+01:00 Marcus Engene : > >> Hi, >> >> Are there highly efficient C extensions out there for math operations on >> arrays? Dot product and whatnot. >> > > what you mean "highly efficien

Re: [GENERAL] efficient math vector operations on arrays

On 24/12/15 07:13, Pavel Stehule wrote: Hi 2015-12-24 8:05 GMT+01:00 Marcus Engene >: Hi, Are there highly efficient C extensions out there for math operations on arrays? Dot product and whatnot. what you mean "highly efficient" ? Implemented as a C m

Re: [GENERAL] efficient math vector operations on arrays

Hi 2015-12-24 8:05 GMT+01:00 Marcus Engene : > Hi, > > Are there highly efficient C extensions out there for math operations on > arrays? Dot product and whatnot. > what you mean "highly efficient" ? PostgreSQL executor is interpret - so in almost all cases the special optimizations has not big

[GENERAL] efficient math vector operations on arrays

Hi, Are there highly efficient C extensions out there for math operations on arrays? Dot product and whatnot. Example usecase: sort an item by euclid distance. Kind regards, Marcus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: h

Re: [GENERAL] ERROR: could not read block 3 in file "base/12511/12270"

writes: >>> On 12/23/2015 04:17 PM, Paul Jones wrote: >>> This isn't the best characterization...the "postgres" data is not a >>> "system" database but rather a convenient default user database. Maybe I'm >>> being overly picky here but seeing "system" in this context does have a >>> connotati

Re: [GENERAL] ERROR: could not read block 3 in file "base/12511/12270"

> On 12/23/2015 04:17 PM, Paul Jones wrote: > > > >I have been having disk errors that have corrupted something in > >>my postgres database. Other databases work ok: > > This isn't the best characterization...the "postgres" data is not a "system" > database but rather a convenient defau

Re: [GENERAL] ERROR: could not read block 3 in file "base/12511/12270"

On Wednesday, December 23, 2015 6:45 PM, Tom Lane wrote: > Paul Jones writes: > > I have been having disk errors that have corrupted something in > > my postgres database. Other databases work ok: > > > postgres=# SELECT pg_catalog.pg_is_in_recovery(); > > ERROR: could not read block 3

Re: [GENERAL] ERROR: could not read block 3 in file "base/12511/12270"

On Wed, Dec 23, 2015 at 5:48 PM, Adrian Klaver wrote: > On 12/23/2015 04:17 PM, Paul Jones wrote: > >> I have been having disk errors that have corrupted something in >> my postgres database. Other databases work ok: >> >> Running on Ubuntu 10.04. >> >> paul@kitanglad:~$ psql -U postgres >> psql

Re: [GENERAL] ERROR: could not read block 3 in file "base/12511/12270"

On 12/23/2015 04:17 PM, Paul Jones wrote: I have been having disk errors that have corrupted something in my postgres database. Other databases work ok: Running on Ubuntu 10.04. paul@kitanglad:~$ psql -U postgres psql (9.4.5) Type "help" for help. postgres=# SELECT pg_catalog.pg_is_in_recover

Re: [GENERAL] ERROR: could not read block 3 in file "base/12511/12270"

Paul Jones writes: > I have been having disk errors that have corrupted something in > my postgres database. Other databases work ok: > postgres=# SELECT pg_catalog.pg_is_in_recovery(); > ERROR: could not read block 3 in file "base/12511/12270": read only 4096 of > 8192 bytes Hm. Evidently y

[GENERAL] ERROR: could not read block 3 in file "base/12511/12270"

I have been having disk errors that have corrupted something in my postgres database. Other databases work ok: Running on Ubuntu 10.04. paul@kitanglad:~$ psql -U postgres psql (9.4.5) Type "help" for help. postgres=# SELECT pg_catalog.pg_is_in_recovery(); ERROR: could not read block 3 in file

Re: [GENERAL] Transfer db from one port to another

John R Pierce writes: >> FYI, you can go here: >> http://www.postgresql.org/mailpref/pgsql-general >> and set eliminatecc to have the listserver do that for you. > except, its the one from the list that I want to keep in my archive. > my filter isn't sophisticated enough to separate them (I'm

Re: [GENERAL] Transfer db from one port to another

On 12/23/2015 12:37 PM, Adrian Klaver wrote: p.s. please don't CC me answers, I get every email sent to the list, with the CC's I end up getting two of every one.\ FYI, you can go here: http://www.postgresql.org/mailpref/pgsql-general and set eliminatecc to have the listserver do that for y

Re: [GENERAL] Transfer db from one port to another

On 12/23/2015 12:12 PM, John R Pierce wrote: I was half awake early this AM and perused my email, and noted a fubar in one of the command sets shown to you but too sleepy to try and reply at the time, and now this thread is WAY too silly long to find it again, but I think someone neglected to put

Re: [GENERAL] Transfer db from one port to another

> *ERROR: syntax error at or near "1" at character 1* *That indicates a problem restoring data, but since it's probably from a previous restore attempt, and there is no time stamp, you might be able to ignore it.* *Do you have PgAdmin installed so you can look at the current contents of the res

Re: [GENERAL] Transfer db from one port to another

I was half awake early this AM and perused my email, and noted a fubar in one of the command sets shown to you but too sleepy to try and reply at the time, and now this thread is WAY too silly long to find it again, but I think someone neglected to put the database name on a pg_restore command.

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 21:06, Killian Driscoll wrote: > On 23 December 2015 at 20:59, Melvin Davidson > wrote: > >> >OK - I see the logs there - the last log was almost 12 hrs ago, so no >> recent one. >> >> That's not very helpful. Depending on how you've configured the logging, >> PostgreSQL m

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 20:59, Melvin Davidson wrote: > >OK - I see the logs there - the last log was almost 12 hrs ago, so no > recent one. > > That's not very helpful. Depending on how you've configured the logging, > PostgreSQL may only create one log file a day. > I didn't change a configurati

Re: [GENERAL] Transfer db from one port to another

>OK - I see the logs there - the last log was almost 12 hrs ago, so no recent one. That's not very helpful. Depending on how you've configured the logging, PostgreSQL may only create one log file a day. Conventional thinking is It's what is IN the log file that is important. On Wed, Dec 23, 2015

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 20:38, Melvin Davidson wrote: > You can rREDIRECT the output to a file! EG: psql -U postgres -p 5532 > > your_output.txt > then use notepad to see the result. > > But from your last reply, it looks like Postgres is finishing the restore > by VACUUMing the database. That me

Re: [GENERAL] Transfer db from one port to another

You can rREDIRECT the output to a file! EG: psql -U postgres -p 5532 > your_output.txt then use notepad to see the result. But from your last reply, it looks like Postgres is finishing the restore by VACUUMing the database. That means it has to vacuum every table. Since you never told us the info

Re: [GENERAL] Transfer db from one port to another

On 12/23/2015 11:27 AM, Killian Driscoll wrote: On 23 December 2015 at 20:24, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 12/23/2015 11:17 AM, Killian Driscoll wrote: On 23 December 2015 at 20:14, Adrian Klaver mailto:adrian.kla...@aklaver.com>

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 20:26, Melvin Davidson wrote: > Do not stop the active restore. > Just run psql from the command shell in the Bitnami binary directory and > use -U postgres and -p 5532 flags. > > > On Wed, Dec 23, 2015 at 2:22 PM, Killian Driscoll < > killiandrisc...@gmail.com> wrote: > >>

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 20:24, Adrian Klaver wrote: > On 12/23/2015 11:17 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 20:14, Adrian Klaver > > wrote: >> > > > >> >> So how are you determining it is running and that it is not doing >> anything?

Re: [GENERAL] Transfer db from one port to another

Do not stop the active restore. Just run psql from the command shell in the Bitnami binary directory and use -U postgres and -p 5532 flags. On Wed, Dec 23, 2015 at 2:22 PM, Killian Driscoll wrote: > On 23 December 2015 at 20:19, Melvin Davidson > wrote: > >> It's possible the restore is still

Re: [GENERAL] Transfer db from one port to another

On 12/23/2015 11:17 AM, Killian Driscoll wrote: On 23 December 2015 at 20:14, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: So how are you determining it is running and that it is not doing anything? Since I ran the restore the windows shell has been 'active' with codes l

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 20:19, Melvin Davidson wrote: > It's possible the restore is still building indexes. > > What does it show when you run this query? > Where do I run this query? Do I stop the restore that is 'active'? > > SELECT datname, >pid as pid, >client_addr, >

Re: [GENERAL] Transfer db from one port to another

It's possible the restore is still building indexes. What does it show when you run this query? SELECT datname, pid as pid, client_addr, usename as user, query, CASE WHEN waiting = TRUE THEN 'BLOCKED' ELSE 'no' END as waiting,

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 20:14, Adrian Klaver wrote: > On 12/23/2015 11:09 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 20:07, Adrian Klaver > > wrote: >> >> On 12/23/2015 11:03 AM, Killian Driscoll wrote: >> >> On 23 December 2015 at 16:02,

Re: [GENERAL] Transfer db from one port to another

On 12/23/2015 11:09 AM, Killian Driscoll wrote: On 23 December 2015 at 20:07, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 12/23/2015 11:03 AM, Killian Driscoll wrote: On 23 December 2015 at 16:02, Adrian Klaver mailto:adrian.kla...@aklaver.com>

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 20:07, Adrian Klaver wrote: > On 12/23/2015 11:03 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 16:02, Adrian Klaver > > wrote: >> >> On 12/23/2015 06:50 AM, Killian Driscoll wrote: >> >> On 23 December 2015 at 15:47,

Re: [GENERAL] Transfer db from one port to another

On 12/23/2015 11:03 AM, Killian Driscoll wrote: On 23 December 2015 at 16:02, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 12/23/2015 06:50 AM, Killian Driscoll wrote: On 23 December 2015 at 15:47, Adrian Klaver mailto:adrian.kla...@aklaver.com>

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 16:02, Adrian Klaver wrote: > On 12/23/2015 06:50 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 15:47, Adrian Klaver > > > >> So cd into: >> >> C:\Program Files\PostgreSQL\9.3\bin >> >> and try: >> >> pg_dump --h

Re: [GENERAL] Shared system resources

Oleg, As others have pointed out, worrying about someone accessing database shared memory is like worrying about an asteroid striking the earth and wiping out all life. It's a one in a billion chance compared to other security violations that can occur. You are better off concentrating on proper O

Re: [GENERAL] Shared system resources

Thank you very much George, that is exactly the piece of information I was missing. Oleg On Wed, Dec 23, 2015 at 10:55 AM, George Neuner wrote: > Hi Oleg, > > On Wed, 23 Dec 2015 07:07:31 -0600, oleg yusim > wrote: > > >May we run into situation, when attacker dumps memory and analyses it for

Re: [GENERAL] Shared system resources

John, To my knowledge, TDE is employed not only by Microsoft, but by Oracle too. I recall it also has a mechanism of protecting keys. Here are references: https://msdn.microsoft.com/en-us/library/bb934049.aspx http://www.oracle.com/technetwork/database/options/advanced-security/index-099011.html

Re: [GENERAL] Shared system resources

Hi Oleg, On Wed, 23 Dec 2015 07:07:31 -0600, oleg yusim wrote: >May we run into situation, when attacker dumps memory and analyses it for >valuable content, instead of reserving it for own process, where it would >be zeroed? My understanding, it is a possibility. Does kernel have any >safeguard

Re: [GENERAL] Huge delay to finish even having all the records inserted

Yep, you're right! Thank you for your feedback! []s Alex On Wed, Dec 23, 2015 at 1:14 PM, Adrian Klaver wrote: > On 12/23/2015 06:49 AM, Alexander Franca Fernandes wrote: > >> Hi, >> >> I'm inserting 14 millions records from a text file using the Postgre >> COPY command. >> > > So how did you

Re: [GENERAL] Secret Santa List

Why not generate the required results in a SELECT then update from that. row_number() could allow you to generate a random number to each giver, then we can generate another random number and join to each random number. That'll give you a giver and recipient combination. e.g: select giver,r

Re: [GENERAL] Shared system resources

On 12/23/2015 8:16 AM, oleg yusim wrote: To my knowledge, many databases are using what called TDE to encrypt data at rest and protect data from being accessed by attacker on host this way. Here is the reference to quick guide on it: https://www.simple-talk.com/sql/database-administration/tra

Re: [GENERAL] Shared system resources

Jim, Help me out with this statement: "There's tons of raw data stored in the shared memory segment, and some of that can be copied to process local memory at any time. If they OS doesn't secure that adequately there's certainly nothing that Postgres or any other database can do about it." To my

Re: [GENERAL] Shared system resources

On 12/23/15 7:55 AM, oleg yusim wrote: Sure David. For simplicity of modeling here, let's assume raw database data was encrypted and the only possibility for attacker to get something from raw data is to go and dig into sessions leftovers. Now, with that has been said, do you happen to know what

Re: [GENERAL] Huge delay to finish even having all the records inserted

On 12/23/2015 06:49 AM, Alexander Franca Fernandes wrote: Hi, I'm inserting 14 millions records from a text file using the Postgre COPY command. So how did you execute this? In other words what is the script you used? After waiting five days I've realized that all the records seems to be a

Re: [GENERAL] Transfer db from one port to another

On 12/23/2015 06:50 AM, Killian Driscoll wrote: On 23 December 2015 at 15:47, Adrian Klaver So cd into: C:\Program Files\PostgreSQL\9.3\bin and try: pg_dump --help that will at least establish that the command is being found

[GENERAL] Huge delay to finish even having all the records inserted

Hi, I'm inserting 14 millions records from a text file using the Postgre COPY command. After waiting five days I've realized that all the records seems to be already inserted, but the process is still running!! I don't know if there's any internal postgresql process that impose that I have to w

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 15:47, Adrian Klaver wrote: > On 12/23/2015 06:35 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 15:30, Adrian Klaver > > wrote: >> >> On 12/23/2015 06:13 AM, Killian Driscoll wrote: >> >> On 23 December 2015 at 14:56,

Re: [GENERAL] Transfer db from one port to another

On 12/23/2015 06:35 AM, Killian Driscoll wrote: On 23 December 2015 at 15:30, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 12/23/2015 06:13 AM, Killian Driscoll wrote: On 23 December 2015 at 14:56, Adrian Klaver mailto:adrian.kla...@aklaver.com>

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 15:30, Adrian Klaver wrote: > On 12/23/2015 06:13 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 14:56, Adrian Klaver > > wrote: >> >> On 12/23/2015 03:43 AM, Killian Driscoll wrote: >> >> On 23 December 2015 at 11:36,

Re: [GENERAL] Transfer db from one port to another

On 12/23/2015 06:13 AM, Killian Driscoll wrote: On 23 December 2015 at 14:56, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 12/23/2015 03:43 AM, Killian Driscoll wrote: On 23 December 2015 at 11:36, John R Pierce mailto:pie...@hogranch.com>

Re: [GENERAL] Transfer db from one port to another

We had that already upthread. Did you set the path to the bin dir of PostgreSQL as of previous posts? Regards Charles From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Killian Driscoll Sent: Mittwoch, 23. Dezember 2015 15:14 To: Adrian Klav

Re: [GENERAL] Transfer db from one port to another

> On 23 Dec 2015, at 12:43, Killian Driscoll wrote: > > OK - I did the dir and it shows that the dump and restore.exe are there, but > running the above gives the below errors > > 09/06/2014 08:35 381,952 pg_dump.exe > > 09/06/2014 08:35 180,224 pg_restore.exe > > C:\Us

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 14:56, Adrian Klaver wrote: > On 12/23/2015 03:43 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 11:36, John R Pierce > > wrote: >> >> On 12/23/2015 2:25 AM, Killian Driscoll wrote: >> >>> Sorry, forgot to add: once I get the war

Re: [GENERAL] Transfer db from one port to another

On 12/23/2015 03:43 AM, Killian Driscoll wrote: On 23 December 2015 at 11:36, John R Pierce mailto:pie...@hogranch.com>> wrote: On 12/23/2015 2:25 AM, Killian Driscoll wrote: Sorry, forgot to add: once I get the warning that the Pg_dump can't be found there is then a password prompt

Re: [GENERAL] Shared system resources

Sure David. For simplicity of modeling here, let's assume raw database data was encrypted and the only possibility for attacker to get something from raw data is to go and dig into sessions leftovers. Now, with that has been said, do you happen to know what information actually gets stored during t

Re: [GENERAL] Shared system resources

On Wed, Dec 23, 2015 at 07:07:31AM -0600, oleg yusim wrote: > May we run into situation, when attacker dumps memory and analyses it > for valuable content, instead of reserving it for own process, where > it would be zeroed? My understanding, it is a possibility. Does kernel > have any safeguard a

Re: [GENERAL] Shared system resources

HI George, Thanks, this information clears the situation. Now, question to you and David. May we run into situation, when attacker dumps memory and analyses it for valuable content, instead of reserving it for own process, where it would be zeroed? My understanding, it is a possibility. Does kern

Re: [GENERAL] Secret Santa List

On Tue, Dec 22, 2015 at 9:49 PM, Lou Duchez wrote: > I have a company with four employees who participate in a Secret Santa > program, where each buys a gift for an employee chosen at random. (For now, > I do not mind if an employee ends up buying a gift for himself.) How can I > make this work

Re: [GENERAL] Secret Santa List

Lou Duchez schrieb am 23.12.2015 um 04:49: I have a company with four employees who participate in a Secret Santa program, where each buys a gift for an employee chosen at random. (For now, I do not mind if an employee ends up buying a gift for himself.) How can I make this work with an SQL stat

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 11:36, John R Pierce wrote: > On 12/23/2015 2:25 AM, Killian Driscoll wrote: > > Sorry, forgot to add: once I get the warning that the Pg_dump can't be > found there is then a password prompt; I tried the db password and the pc > password but both fail: > > Password: > pg_d

Re: [GENERAL] Secret Santa List

On Wed, Dec 23, 2015 at 04:32:34AM -0500, Lou Duchez wrote: > >Of course: you can't UPDATE a field with a query returning more than one > >result, as you can check easily trying: > > I understand that, and my query does not return more than one result. The > problem is that it returns THE SAME re

Re: [GENERAL] Transfer db from one port to another

On 12/23/2015 2:25 AM, Killian Driscoll wrote: Sorry, forgot to add: once I get the warning that the Pg_dump can't be found there is then a password prompt; I tried the db password and the pc password but both fail: Password: pg_dump: [archiver (db)] connection to database "irll_project" faile

Re: [GENERAL] Transfer db from one port to another

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Killian Driscoll Sent: Mittwoch, 23. Dezember 2015 11:26 To: John R Pierce Cc: pgsql-general Subject: Re: [GENERAL] Transfer db from one port to another On 23 December 2015 at 11:19, Killian

Re: [GENERAL] Transfer db from one port to another

On 12/23/2015 2:19 AM, Killian Driscoll wrote: (or, click on an 'Command Prompt' shortcut). C:\Users\YourName>***path "c:\Program Files\PostgreSQL\9.4\bin";%path%* C:\Users\YourName>*pg_dump -Fc -p 5432 *//*| pg_restore -p 5532* Thanks. When I do this I get an error

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 11:19, Killian Driscoll wrote: > On 23 December 2015 at 11:07, John R Pierce wrote: > >> On 12/23/2015 1:40 AM, Killian Driscoll wrote: >> >> Try it with plain pg_dump. >>> >>> pg_dump -h localhost -p 5432 -Fc > dump.sql >>> >>> pg_restore -h localhost -p 5532 dump.sql >>

Re: [GENERAL] Transfer db from one port to another

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Killian Driscoll Sent: Mittwoch, 23. Dezember 2015 11:19 To: John R Pierce Cc: pgsql-general Subject: Re: [GENERAL] Transfer db from one port to another On 23 December 2015 at 11:07, John R Pier

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 11:07, John R Pierce wrote: > On 12/23/2015 1:40 AM, Killian Driscoll wrote: > > Try it with plain pg_dump. >> >> pg_dump -h localhost -p 5432 -Fc > dump.sql >> >> pg_restore -h localhost -p 5532 dump.sql >> > > I tried this, but nothing appears to happen when entering the

Re: [GENERAL] Transfer db from one port to another

On 12/23/2015 1:40 AM, Killian Driscoll wrote: Try it with plain pg_dump. pg_dump -h localhost -p 5432 -Fc > dump.sql pg_restore -h localhost -p 5532 dump.sql I tried this, but nothing appears to happen when entering the commands. Attached is a screenshot of the shell window -

Re: [GENERAL] Transfer db from one port to another

From: Killian Driscoll [mailto:killiandrisc...@gmail.com] Sent: Mittwoch, 23. Dezember 2015 11:02 To: Charles Clavadetscher Cc: Andreas Kretschmer ; pgsql-general Subject: Re: [GENERAL] Transfer db from one port to another On 23 December 2015 at 10:58, Charles Clavadetscher mailto:clavadets

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 10:58, Charles Clavadetscher < clavadetsc...@swisspug.org> wrote: > Hello Killian > > >> I want to transfer my db with three schemas from port 5432 to port 5532 > to use > >> within the bitnami stack. I have used pgAdmin to create a backup.sql > and when > >> using pgAdmin t

Re: [GENERAL] Transfer db from one port to another

Hello Killian >> I want to transfer my db with three schemas from port 5432 to port 5532 to >> use >> within the bitnami stack. I have used pgAdmin to create a backup.sql and when >> using pgAdmin to restore the .sql to port 5532 I get the following error > >Try it with plain pg_dump. > >pg_dump

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 10:29, Andreas Kretschmer wrote: > Killian Driscoll wrote: > > > I am using Windows 8 64 bit, with postgreSQL 9.3 on port 5432 and > postgreSQL > > 9.4 on port 5532 with the latter set up to use with Bitnami stack to > test php > > files I am generating from my db. > > > >

Re: [GENERAL] Secret Santa List

Of course: you can't UPDATE a field with a query returning more than one result, as you can check easily trying: I understand that, and my query does not return more than one result. The problem is that it returns THE SAME result each time, most likely because the subquery is evaluated exactl

Re: [GENERAL] Transfer db from one port to another

Charles Clavadetscher wrote: > Hello > > > > Why don’t you simply change the port in postgresql.conf and restart the > server? i think, he wants the data from the one database within the other, because of that he can't change the port. Andreas -- Really, I'm not out to destroy Microsoft.

Re: [GENERAL] Transfer db from one port to another

Killian Driscoll wrote: > I am using Windows 8 64 bit, with postgreSQL 9.3 on port 5432 and postgreSQL > 9.4 on port 5532 with the latter set up to use with Bitnami stack to test php > files I am generating from my db. > > I want to transfer my db with three schemas from port 5432 to port 5532 t

Re: [GENERAL] Transfer db from one port to another

On 23 December 2015 at 10:05, Charles Clavadetscher < clavadetsc...@swisspug.org> wrote: > Hello > > > > Why don’t you simply change the port in postgresql.conf and restart the > server? > I am attempting to learn to use the dump and restore, so would like to figure out how to do it via an export

Re: [GENERAL] Transfer db from one port to another

Hello Why don’t you simply change the port in postgresql.conf and restart the server? Bye Charles From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Killian Driscoll Sent: Mittwoch, 23. Dezember 2015 09:58 To: pgsql-general Subject: [GEN

[GENERAL] Transfer db from one port to another

I am using Windows 8 64 bit, with postgreSQL 9.3 on port 5432 and postgreSQL 9.4 on port 5532 with the latter set up to use with Bitnami stack to test php files I am generating from my db. I want to transfer my db with three schemas from port 5432 to port 5532 to use within the bitnami stack. I ha

Re: [GENERAL] Shared system resources

On Tue, 22 Dec 2015 23:21:27 +, David Wilson wrote: >On Linux the memory pages of an exiting process aren't sanitized at >exit, however it is impossible(?) for userspace to reallocate them >without the kernel first zeroing their contents. Not impossible, but it requires a non-standard kernel

Re: [GENERAL] Secret Santa List

On 23 December 2015 at 16:49, Lou Duchez wrote: > I have a company with four employees who participate in a Secret Santa > program, where each buys a gift for an employee chosen at random. (For > now, I do not mind if an employee ends up buying a gift for himself.) How > can I make this work wi