Re: [GENERAL] fast refresh materialized view

On Sat, Nov 14, 2015 at 7:01 AM, Pradhan, Sabin wrote: > Does postgres has fast refresh materialized view that supports incremental > refresh. In oracle , this is achieve by materialized view log. Not sure > how to implement it in postgres. No. Postgres offers just the possibility to refresh

Re: [GENERAL]

Ubuntu 14.04 64bit + postgresql 9.4 are used here; What I have done are: 1,Sign In ubuntu by user alex 2,then:sudo -i -u postgres 3,then:psql jump into command client 4,then: create database icare; 5,then: \q jump out command client 6,then run: exit jump out psql 7,then pg_restore --clean -

Re: [GENERAL]

Hello I never used pg_restore, but I assume that it works similarly to other PG tools, i.e. if you don’t specify a user to connect to the database it will take your unix user name. I assume that your step number 6 is the closing of the shell where you were as user postgres because after 5 yo

Re: [GENERAL]

Instead of creating a superuser you may simply grant the privilege on the database: CREATE ROLE alex LOGIN PASSWORD '...'; GRANT CREATE ON DATABASE icare TO alex; Bye Charles From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Charles Cl

Re: [GENERAL]

On 11/15/2015 05:44 AM, Alex Luya wrote: Ubuntu 14.04 64bit + postgresql 9.4 are used here; What I have done are: 1,Sign In ubuntu by user alex 2,then:sudo -i -u postgres 3,then:psql jump into command client Assuming -U postgres, correct? 4,then: create database icare; 5,then: \q jump ou

Re: [GENERAL] can postgres run well on NFS mounted partitions?

How do you tell if a database is corrupted? Are there specific error messages/symptoms to look for? I have tried running multiple readers/writers, inserted data and verified the byte count from doing fetches. I also ran a reboot and checked that the db came back up after it with data. I still have

[GENERAL] Importing directly from BCP files

Does anybody have any documentation on what a BCP file from SQL server looks like? I have a directory full of BCP files and I would like to import them into PG. Has anybody done anything like this before? Thanks

Re: [GENERAL] Importing directly from BCP files

On 16 November 2015 at 15:31, Tim Uckun wrote: > Does anybody have any documentation on what a BCP file from SQL server > looks like? > That appears to depend on the -f option https://msdn.microsoft.com/en-nz/library/ms162802.aspx There's more details on the format files here https://msdn.micr

Re: [GENERAL] Importing directly from BCP files

On 11/15/2015 07:31 PM, Tim Uckun wrote: > Does anybody have any documentation on what a BCP file from SQL > server looks like? I have a directory full of BCP files and I would > like to import them into PG. > > Has anybody done anything like this before? I moved a database from MS Sql Server 20

Re: [GENERAL] Importing directly from BCP files

> > > That appears to depend on the -f option > > > I have the format files so that's good. > > Have you tried opening a file in a text editor to see what they look like? > > Yes. It looks like a binary file with lots of non printable ch

Re: [GENERAL] Importing directly from BCP files

> > > I moved a database from MS Sql Server 2000 to Postgresql a few years > ago via BCP files. I used a Python script to do some fixup on the > BCP files to make them importable as CSV files into Postgresql. I > don't know if quirks I ran into are still an issue with newer versions > of Sql Serv