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 >

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:

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

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 > wrote: On 12/23/2015 03:43 AM, Killian Driscoll wrote: On 23 December 2015 at 11:36, John R Pierce

[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

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

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

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 > wrote: On 12/23/2015 06:13 AM, Killian Driscoll wrote: On 23 December 2015 at 14:56, Adrian Klaver

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

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

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

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

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 > wrote: On 12/23/2015 06:50 AM, Killian Driscoll wrote: On 23 December 2015 at 15:47, Adrian Klaver

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

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

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 > wrote: On 12/23/2015 11:17 AM, Killian Driscoll wrote: On 23 December 2015 at 20:14, Adrian Klaver

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:

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,

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

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

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

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 > wrote: On 12/23/2015 11:03 AM, Killian Driscoll wrote: On 23 December 2015 at 16:02, Adrian Klaver

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 > wrote: So how are you determining it is running and that it is not doing anything? Since I ran the restore the windows shell

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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,

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

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

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

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

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

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

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

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

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"

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

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

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

[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

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

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

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

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

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

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

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 >