subject:"\[GENERAL\] To Postgres or not"

[GENERAL] Revolut - postgres ?

2017-10-01 Thread rakeshkumar464

https://blog.revolut.com/no-excuses-we-let-you-down-32f81e64f974

The career section of the company's web page lists PG as one of the tech
stack.

Would be interesting to know the details.

"At around 07:00 BST on Friday morning, our transaction database began to
malfunction. Naturally, we followed procedure and switched to a backup
server. Unfortunately, the backup server began to drastically slow down and
was struggling to process live transactions.
To make matters worse, we had an unexpected spike of 50% in user activity on
Friday and the backup server could not handle such a large increase in
volume."




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


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

[GENERAL] Inconsistent Postgres error when installing our product containing PostgreSQL 9.3.4

2017-09-06 Thread Diags101

Hi,

I'm getting inconsistent Postgres errors, when we upgrade our product that
bundles PostgreSQL 9.3.4.
We have 13 databases and we get errors at different places of the database
setup.

Here are the failures:
1.
$POSTGRES/bin/psql -c  " CREATE SEQUENCE serial1 START 1 CYCLE ;" -d $ARCHDB
exitIfCommandFailed "Schema creation"

ERROR:  index "pg_type_oid_index" contains corrupted page at block 0
HINT:  Please REINDEX it.

2.
$POSTGRES/bin/psql -c " CREATE TABLE RAWLOG (ID int8  PRIMARY KEY DEFAULT
nextval('serial1'),SOURCE varchar (100),RAWDATA bytea,WRITETIME timestamp
DEFAULT CURRENT_TIMESTAMP,BOOTTIME timestamp DEFAULT CURRENT_TIMESTAMP
,HIDDEN bool,VERSION int4);" -d $WORKINGDB

ERROR:  relation "pg_catalog.pg_database" does not exist
LINE 7: FROM pg_catalog.pg_database d

3.
$POSTGRES/bin/pg_restore -d $EVWEB_DB -p$EVWEB_DB_PORT -U$SFMDB_SU
$VAR_TMP/evwebdump

ERROR:  relation "pg_catalog.pg_namespace" does not exist
LINE 3: FROM pg_catalog.pg_namespace n

4.
$POSTGRES/bin/psql -c " CREATE TABLE RAWLOG (ID int8  PRIMARY KEY DEFAULT
nextval('serial1'),SOURCE varchar (100),RAWDATA bytea,WRITETIME timestamp
DEFAULT CURRENT_TIMESTAMP,BOOTTIME timestamp DEFAULT CURRENT_TIMESTAMP
,HIDDEN bool,VERSION int4);" -d $ARCHDB

ERROR:  invalid page in block 0 of relation base/216257/11812

All these errors are inconsistent and the errors appear in some other
database, when I repeat the installation.

Any pointers or suggestions are welcome.

On behalf of the Diagnostics team,
Sanjay

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Adrian Klaver


On 06/18/2017 01:13 PM, Martin Mueller wrote:

I think I get it. 'base' is not the data directory but a child of var-9.5, which (with 
its entire path) is the "data directory". I honestly don't recall how I 
installed Posgres, but I'm pretty sure that I picked the default method from the Postgres.


Not something you have to do right this instant, but I would try to 
track down how you did the install. It will come in handy when you do an 
upgrade as the various installers differ in how they do an install. 
Picking the wrong one when you do the upgrade could make things difficult.




Many thanks for your help, which is exceptionally clear and detailed.

MM





--
Adrian Klaver
adrian.kla...@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

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Martin Mueller

I think I get it. 'base' is not the data directory but a child of var-9.5, 
which (with its entire path) is the "data directory". I honestly don't recall 
how I installed Posgres, but I'm pretty sure that I picked the default method 
from the Postgres.

Many thanks for your help, which is exceptionally clear and detailed.

MM




On 6/18/17, 3:03 PM, "Adrian Klaver"  wrote:

>On 06/18/2017 01:00 PM, Martin Mueller wrote:
>> Did you mean  that "/users/martin/Library 
>> ApplicationSupport/Postgres/var9.5/base/" is above  or below the data 
>> directory?  As I understand it Postgres is the highest Postgres specific 
>> directory. It contains just one child directory, var-9.5, which has a lot of 
>> subdirectories, including 'base'. So I assume that "base" is the "entire 
>> Postgres directory". Is that correct
>
>Pretty sure the answer is no. I am going to say the Postgres data 
>directory is /users/martin/Library ApplicationSupport/Postgres/var9.5/.
>
>Take a look at this link:
>
>https://urldefense.proofpoint.com/v2/url?u=https-3A__www.postgresql.org_docs_9.6_static_storage-2Dfile-2Dlayout.html=DwICaQ=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk=EE03EBpU01pYlVG72ZO4h4D-1JJd--vXBmEvErByUOo=ekr93dxabdAgdsxrrTh5gg3pQOUFrX9muS6YFV9SIwM=
> 
>
>and see if what is under:
>
>/users/martin/Library ApplicationSupport/Postgres/var9.5/
>
>looks similar.
>
>*** It would also help to know how you installed Postgres? ***
>
>>   
>> 
>> 
>> 
>> 
>>>
>>> 3) You will need to make sure you are copying/syncing the entire
>>> Postgres data directory:
>>>
>>> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.postgresql.org_docs_9.6_static_storage-2Dfile-2Dlayout.html=DwICaQ=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk=lQpZV77iEes6tm1L3zsHQm9eceGhQh8UV4IOgzDvapg=MpRqOYUdfX_Z4OK9-AFg2b7glEe4lY2aYupB6508ZjQ=
>>>
>>>  From you original post the directory you mentioned:
>>>
>>> /users/martin/Library ApplicationSupport/Postgres/var9.5/base/
>>>
>>> looks to be below the top level data directory.
>>>
>>> While I remember, how are you installing/updating Postgres on your machines?
>>>
>
>
>-- 
>Adrian Klaver
>adrian.kla...@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

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Adrian Klaver

On 06/18/2017 01:00 PM, Martin Mueller wrote:

Did you mean that "/users/martin/Library ApplicationSupport/Postgres/var9.5/base/" is above or
below the data directory? As I understand it Postgres is the highest Postgres specific directory. It
contains just one child directory, var-9.5, which has a lot of subdirectories, including 'base'. So I assume
that "base" is the "entire Postgres directory". Is that correct

Pretty sure the answer is no. I am going to say the Postgres data
directory is /users/martin/Library ApplicationSupport/Postgres/var9.5/.

Take a look at this link:

https://www.postgresql.org/docs/9.6/static/storage-file-layout.html

and see if what is under:

/users/martin/Library ApplicationSupport/Postgres/var9.5/

looks similar.

*** It would also help to know how you installed Postgres? ***

3) You will need to make sure you are copying/syncing the entire
Postgres data directory:

https://urldefense.proofpoint.com/v2/url?u=https-3A__www.postgresql.org_docs_9.6_static_storage-2Dfile-2Dlayout.html=DwICaQ=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk=lQpZV77iEes6tm1L3zsHQm9eceGhQh8UV4IOgzDvapg=MpRqOYUdfX_Z4OK9-AFg2b7glEe4lY2aYupB6508ZjQ=

From you original post the directory you mentioned:

/users/martin/Library ApplicationSupport/Postgres/var9.5/base/

looks to be below the top level data directory.

While I remember, how are you installing/updating Postgres on your machines?

--
Adrian Klaver
adrian.kla...@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

1 2 3 4 5 6 7 8 9 10 >

1 - 100 of 1052 matches

Mail list logo